[developer]

Hello

I am getting error while connected to Mssql server in asp. How to resolve it. Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()).

[smartzkool]

I don't know what you are talking about as I don't know much about the MSSQL part. I tried to help you out by searching google. I got a list of sites.


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.

[Sandeep]

Hello,

It seems that it is due to some permissions level issue you are getting this error message. You can refer below mentioned URL for reference which I have found from various search engines:


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.


As an alternative you can use DNS Less connection string. I have posted sample code here:

====================================
Dim SqlConn
Set SqlConn = Server.CreateObject("ADODB.Connection")

SqlConn.ConnectionString="Driver={SQL Server};" & "Server=MS SQL Server IP;" & _"Database=dbname;" & "Uid=username;" & "Pwd=password;"

SqlConn.Open
Response.Write "SQL Connection Successful"
====================================

Thanks,

Sandeep Gandhi

[a2zorkut]

First of all, what is the need of using ODBC when there is an option of OLEDB/SQLOLEDB? In Asp, we should have a practice to use OLEDB/SQLOLEDB providers for MS ACCESS and MS SQL.