Can I connect without server?

Hi,
I have a customers program on my system - Omin 7 as at
http://www.omnis.net/products/omnis7/ - so I can pull the data into an
Access Database. I'd like to do this work at my place not theirs!
Is there anyway I can set up an ODBC connection so that I can read the
files. The .dsn file reads:
[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=salesteam
WSID=JERRY
APP=Microsoft(R) Windows(R) Operating System
SERVER=NTSERVER
if that helps at all.
I'm running Windows XP Pro. I guess the problem is that I don't have a
server '
Any help would be greatly appreciated, thank you.
JonAre you saying you are running SQL Server on XP? Then it should work
provided you've got file and printer sharing enabled.
If this is not the case, please elaborate on what you are attempting?
Steve
"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btk6qv$t3f$1@.hercules.btinternet.com...

quote:

---

> Hi,
> I have a customers program on my system - Omin 7 as at
> http://www.omnis.net/products/omnis7/ - so I can pull the data into an
> Access Database. I'd like to do this work at my place not theirs!
> Is there anyway I can set up an ODBC connection so that I can read the
> files. The .dsn file reads:
> [ODBC]
> DRIVER=SQL Server
> UID=sa
> DATABASE=salesteam
> WSID=JERRY
> APP=Microsoft(R) Windows(R) Operating System
> SERVER=NTSERVER
> if that helps at all.
> I'm running Windows XP Pro. I guess the problem is that I don't have a
> server '
> Any help would be greatly appreciated, thank you.
> Jon
>

---

|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.odbc:41677
Steve,
I have NOT got sql server running, just XP PRo with IIS.
Is there any way around this - without installing sql server?
Thanks
Jon
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Are you saying you are running SQL Server on XP? Then it should work
> provided you've got file and printer sharing enabled.
> If this is not the case, please elaborate on what you are attempting?
> Steve
> "Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
> news:btk6qv$t3f$1@.hercules.btinternet.com...
>

---

|||"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btpipc$mtu$1@.hercules.btinternet.com...

quote:

---

> I have NOT got sql server running, just XP PRo with IIS.

---

It's still not clear to me what you are attempting, I asked you to elaborate
and I'm only getting little tidbits.

quote:

---

> Is there any way around this - without installing sql server?

---

Is the source data you need in SQL Server? You can get the SQL Server 2000
developers edition for $49 USD.
I wish I could provide a better answer, however lack of detail is not
helping...
Steve

quote:

---

> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...
a[QUOTE]
>

---

can anyone give me a simple T/SQL program

please i just need itWhat do you mean by a TSQL program? TSQL is a language.

If all you want is a TSQL statement, try this...

SELECT GETDATE()|||Just guesing what you mean as well, if you mean a tutorial on t-sql, there is one here.

http://sqlcourse.com/

HTH|||I guess the simplest would be SQL Server's OSQL utility. It is command line driven, or you can send batch files through it.

blindman|||There is also the Query Analyzer utility to write, save and load SQL scripts.

Can AMO be used on VB.Net

Hi,

I want to program the Analysis Roles in AMO. Can I use VB.Net? What is the reference that I have to add to my project? Can you provide a simple sample connection.

Thanks a lot!

cherriesh

Hello,

you can find a kind of tutorial about AMO here

http://msdn2.microsoft.com/en-us/library/ms345081.aspx

HTH

J?rg

Can 6.5, 7.0 and 2000 all co-exist on same machine ?

I'm currently running SQL Server 6.5 and 7.0 together on the same
machine (i.e. switchable using the program switcher). Does anyone
know if i can install SQL Server 2000 to run alongside both of these?

Thanks in anticipation.
RobRob wrote:
> I'm currently running SQL Server 6.5 and 7.0 together on the same
> machine (i.e. switchable using the program switcher). Does anyone
> know if i can install SQL Server 2000 to run alongside both of these?

7.0 and 2000 certainly can, if you install 2000 as a named instance. As to
whether 6.5 and 7.0 can co-exist, 6.5 is so ancient I can't recall. I do
believe there was some utility to switch between the two on the same
machine, but not so much both available simultaneously.

--
Steve Troxell|||Steve,
Thanks, i've inherited an old 6.5 database i'd like to keep a copy of
and also run 7 & 2000. Anyway think i've found the answer on the web:

<quote>
If both SQL Server 7.0 and 6.5 are installed on the computer and
coexist by means of a version switch and you don't want to upgrade an
existing installation, you can safely install named instances of SQL
Server 2000 on the same machine and host all three versions on the
same computer. However, only one of the versions (i.e., 7.0 or 6.5)
that coexist by means of a version switch can run at one time, whereas
all named instances can run simultaneously.
</quote
Rob

On Fri, 05 Nov 2004 17:43:56 GMT, "Steve Troxell"
<steve_troxell@.nospam.hotmail.com> wrote:

>Rob wrote:
>> I'm currently running SQL Server 6.5 and 7.0 together on the same
>> machine (i.e. switchable using the program switcher). Does anyone
>> know if i can install SQL Server 2000 to run alongside both of these?
>7.0 and 2000 certainly can, if you install 2000 as a named instance. As to
>whether 6.5 and 7.0 can co-exist, 6.5 is so ancient I can't recall. I do
>believe there was some utility to switch between the two on the same
>machine, but not so much both available simultaneously.

Call-Level Interface (CLI)

I have just read about the Call-level interface, a library of DBMS
functions that can be called by an application program. Where can I
read more about the CLI function, Google & MSDN searches didn't yield
much and no examples etc. Does any one actually program to this to
facilitate data transfers? What is its performance similar to... OLE
DB?
Thanks.
The X/Open and ISO/IEC for database APIs implementation for SQL Server is
also known as ODBC, see
http://msdn.microsoft.com/library/de...bcoverview.asp
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"elizabeth" <ezelasky@.hotmail.com> wrote in message
news:78393913.0409271103.227fe929@.posting.google.c om...
>I have just read about the Call-level interface, a library of DBMS
> functions that can be called by an application program. Where can I
> read more about the CLI function, Google & MSDN searches didn't yield
> much and no examples etc. Does any one actually program to this to
> facilitate data transfers? What is its performance similar to... OLE
> DB?
> Thanks.