I have a web application which uses SQLOLEDB for connecting SQL server 2000
database (sp4). The application server and database server both runs on Win
strConn = "Provider=SQLOLEDB; "
strConn = strConn & "Data Source=PC; "
strConn = strConn & "Initial Catalog=ABC; "
strConn = strConn & "User Id=test; "
strConn = strConn & "Password=test"
The application works in Window 2000, however, after the OS (for both
servers) have changed to Window server 2003. I tried to run the web
application, I have the following error:
"SQL Server does not exist or access denied. "
The interesting thing is that the application works fine if both application
and database are installed in the same server.
Can anyone help me on this?