Groups | Blog | Home
all groups > sql server odbc > october 2004 >

sql server odbc : SQL server access problem



Pupo
10/4/2004 9:46:51 AM
Hi
i have a windows xp pro, i using odbc to connect to sql 2000 server. i have
two connection that work fine. Now when i try to connect i receive a popup
message of error.
If i try to configure or recreate my odbc i receive the followin errors:
impossible make connection
sqlstate: '01000'
sqlstate: '08001'
sql server error 17

can help me to resolve this problem?
Tia Pupo

Uri Dimant
10/4/2004 9:53:29 AM
Pupo
Can you show us your connection string?

[quoted text, click to view]

Pupo
10/4/2004 10:06:06 AM
Can tell me where find the string please, because i use odbc procedure in
administratirve tools.
Thanks


[quoted text, click to view]

Uri Dimant
10/4/2004 10:30:45 AM
Pupo
Do you have ACCESS application to read the data from SQL Server?
You've said "i have
two connection that work fine. Now when i try to connect i receive a popup
message of error." What could be changed? Did you change a SA password?





[quoted text, click to view]

Michael Shiffman
12/28/2004 7:47:03 AM
I'm running SQL2000 on an Win2k box also running IIS.
I would think it would be faster to connect using a "localhost" type of
connection rather than a machine name but I haven't been able to get the
syntax. For security conecrns we changed the default port.

The Connection string I am using for my web apps is:

Dim Connect
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.open "DRIVER={SQL
Server};SERVER=SERVERNAME;DATABASE=DATABASENAME;UID=USERID;PWD=PASWSWORD;"

Is there a faster way to connect?
Thanks --
Michael Shiffman
AddThis Social Bookmark Button