Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 ODBC CONNECTION PROBLEM

Author  Topic 

innocent73
Starting Member

20 Posts

Posted - 2002-09-27 : 03:32:04
Hello,
I have installed seven MSDE on seven different machines.Some of these machines are Win98 and some of them are Win2000 professional.I am trying to connect these different MSDEs via ODBC and I could connect some of tha machines and unfortunately there is no standard rules for connecting.
For example I am trying to connect to Computer2 by the settings
username=sa
password=BLANK
and it works.But when I try to connect to this machine from another computer it does not work.
Any idea???
Please help

automicgina
Starting Member

25 Posts

Posted - 2003-04-10 : 14:50:36
I run into the same problem mainly with Win98. Some of the systems can be fixed with typing the IP address instead of the server name.

Go to Top of Page

Doug G
Constraint Violating Yak Guru

331 Posts

Posted - 2003-04-11 : 00:40:54
You must connect via TCP/IP from W9x boxes, Named Pipes isn't supported. There is a MS KB article somewhere that illustrates how to reconfigure MSDE for TCP/IP, or you should be able to force TCP/IP through your connection string from a W9x box.


======
Doug G
======
Go to Top of Page
   

- Advertisement -