Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem to connect to SQL Server
Message
From
29/05/2009 15:02:12
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Problem to connect to SQL Server
Environment versions
SQL Server:
SQL Server 2000
Application:
Desktop
Miscellaneous
Thread ID:
01402669
Message ID:
01402669
Views:
118
A friend called for help to connect to SQL Server from a VFP station and he passed the string to connect to the server.
The string is this:
x = ("DRIVER={SQL Server};SERVER=SERVIDORBANCOS;UID=sa;PWD=obavai;DATABASE=master;Network=DBMSSOCN")
nConnect = SQLSTRINGCONNECT(x)
I dont see nothing wrong here, but it doesn't connect to the server.

I asked him to see what are the protocols used in the Client Network Utility and in the Server Network Utility.
Both have TCP/IP and Named Pipes enabled protocols.

I asked him to just use TCP/IP as a enabled protocol and try to connect again to the server, but it failed.
Then he returned to both protocols.

When I removed the "Network=DBMSSOCN" from the string, the connection was established.
this string to connect works
x = ("DRIVER={SQL Server};SERVER=SERVIDORBANCOS;UID=sa;PWD=obavai;DATABASE=master")
nConnect = SQLSTRINGCONNECT(x)
The question is: Why it works if he removes the network protocol from the connection string?

TIA

Peter
Next
Reply
Map
View

Click here to load this message in the networking platform