Board index » delphi » How to connect client to MS SQL Server 2K

Stojce Mirkovski

Delphi Developer
Mon, 09 Jun 2003 15:11:31 GMT

How to connect client to MS SQL Server 2K

I know this is totally newbie question, but I don't know
what I am doing wrong...

I've installed both server (which is working perfectly) and
client, and on client side I cann't configure ODBC since
it doesn't see server!!! What to do???

And another question - how to know the value of identity
record at the moment of posting?

Regards.

 
Mike Wals

Delphi Developer
Tue, 10 Jun 2003 02:18:36 GMT

Re:How to connect client to MS SQL Server 2K


Hi,

How do you have the server and client configured? What OS are you using for
both?

I haven't played with 2k yet (it's installed on a test machine, just haven't
had the time yet),  but with SQL7,  I had fits using win9x machines for the
server, and you have to set up the server in the client network utility.

Maybe if you explain some of your settings, I could help.

Mike Walsh

Quote
> I've installed both server (which is working perfectly) and
> client, and on client side I cann't configure ODBC since
> it doesn't see server!!! What to do???

> And another question - how to know the value of identity
> record at the moment of posting?

> Regards.

Stojce Mirkovsk

Delphi Developer
Wed, 11 Jun 2003 18:10:51 GMT

Re:How to connect client to MS SQL Server 2K


Huh, it was my mistake...
When the SQL Server was installed, it was choosen
Windows NT authorization system, and the user on
the client computer haven't existed on the server...

Anyway, it seems to me that security and authorization
system on the SQL Server is a bit complicated...

Viva SQL Anywhere :)

Regards.

Quote
"Mike Walsh" <te...@msllib.com> wrote in message news:3a4248db$1_2@dnews...
> Hi,

> How do you have the server and client configured? What OS are you using
for
> both?

> I haven't played with 2k yet (it's installed on a test machine, just
haven't
> had the time yet),  but with SQL7,  I had fits using win9x machines for
the
> server, and you have to set up the server in the client network utility.

> Maybe if you explain some of your settings, I could help.

> Mike Walsh

> > I've installed both server (which is working perfectly) and
> > client, and on client side I cann't configure ODBC since
> > it doesn't see server!!! What to do???

> > And another question - how to know the value of identity
> > record at the moment of posting?

> > Regards.

Other Threads

1. delphi client - ms-sql server mods dont connect

2. Interbase vs MS SQL Server 2K

3. Connecting client to MS-SQL Sever 6.5 via BDE

4. connect to SQL Server 7.0 without Microsoft Client?

5. Connecting to MS SQL 7 SERVER

6. Connecting to MS SQL server using NT security

7. Staying connected to MS SQL Server

8. How to connect to MS SQL Server

9. MS SQL Server / mixed security / Connecting

10. Connecting to MS SQL Server Table through Firewall