I am getting an error message and i have no idea where is the fault. I am getting the below mention error on my index file when i try to extract some data from tables. The error which i am getting is....
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I used correct user id and password in odbc dsn and able to connect to the server with the same user id and password thru sql tools. I am also able to ping my remote sql server.
As per my experience, i guess that there is some settings problem. Or it might be that I just plain can't do this?
I am using ASP and SQL Server 2000.
Can anyone put some light on it ? Where is the fault ??
Originally posted by sqlboy
Hello Satya !
Thanks for reply. But it would be great help if you eloborate your point atlength. I am not getting what you wish to convey.
Pardon me, for not getting your words.
As referred in KBA:
-The Trusted Connection box is not checked in the System DSN definition.
-The SQL Server security mode is not Windows NT Integrated.
-Within the connection attribute, the uid is not blank.
As I referred in my first post, try connecting the server by making TCP/IP as default netlib on server.
Okay fine. I'll try to make TCP/IP as default netlib and let you know after that. Though, I'll do that thing first time in my life so i amn't sure wether i am capable to do the thing right or not. If you have any article regarding the same sense then it would be great help.