Klein
February 2nd, 2005, 03:53 PM
I have an ASP page which has commands to access a SQL Server 2000 database.
Ex:
rsDatabase.ConnectionString = "Provider=SQLOLEDB;Data Source=xx.xxx.xx.xxx,yyyy;Initial Catalog=ABCDEF;uid=john;pwd=smith"
This line returns the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
1. There is not much load on both the web and sql server and this is the only connection which I'm trying to open with the database.
2. I have tried connecting to the database using the System DSN, but it won't connect
3. On some days and at some times, the page works perfectly with no complaints.
Can anyone please help me out with suggestions?
Ex:
rsDatabase.ConnectionString = "Provider=SQLOLEDB;Data Source=xx.xxx.xx.xxx,yyyy;Initial Catalog=ABCDEF;uid=john;pwd=smith"
This line returns the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
1. There is not much load on both the web and sql server and this is the only connection which I'm trying to open with the database.
2. I have tried connecting to the database using the System DSN, but it won't connect
3. On some days and at some times, the page works perfectly with no complaints.
Can anyone please help me out with suggestions?