General discussion

Locked

MS ODBC/OLEDB --> ASP & SQL SERVER he

By rsp05 ·
I am a novice here, so need some clarification on what I have. I built an ASP page using the following connection string:<br>strConnectString = "Driver={SQL Server}; Server="&gServer&";;"<br>
Basically, depending on the server on my network, it will login in using TRUSTED CONNECTION, on any SQL Server. I have verified that I can connect to each of the "problem" servers via trusted connection. THIS ALL WORKED BEFORE, and then had some problems with SQL 2000 sp1.
Anyway, regarding my<b> SQL v6.5 </b> servers, when I click on link to login in I get this:<br>
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed<br> Now, the strange part is that some 6.5 servers doconnect and get the info, others fail out. I am not sure, but is my DNS-less connection using ODBC, OLEDB, and what SQL Server driver??? (SQLSRV32.dll?)<br> I need DNS-less, so I don't have to create DSN for each server. The SQL Server driver I amusing now is: v.3.70.06.90 (4/5/99)..Funny thing is that all driver versions worked before, if in fact this is the driver it is using......HELP!!! THanks much!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

MS ODBC/OLEDB --> ASP & SQL SERVER he

by andrew In reply to MS ODBC/OLEDB --> ASP & S ...

It appears that you're using ODBC.

I would use a connection string similar to the following:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=[DB_Name];Data Source=[ServerName]

This will use pure OLEDB.

Personally, I prefer to use SQL authentication, even over trusted connections. This allows me to have tighter control on the security, and works on machines where no one is logged in.

One other thing to keep in mind: you should use the TCP/IP network library (dbmssocn)to connect to remote SQL servers, not Named Pipes (dbnmpntw).

If you don't have the Client network utility, you can run the following registry script to set this up:

REGEDIT4
[HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\ConnectTo]
"DSQUERY" = "DBMSSOCN"

Collapse -

MS ODBC/OLEDB --> ASP & SQL SERVER he

by rsp05 In reply to MS ODBC/OLEDB --&gt; ASP ...

Poster rated this answer

Collapse -

MS ODBC/OLEDB --> ASP & SQL SERVER he

by rsp05 In reply to MS ODBC/OLEDB --> ASP & S ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums