Unable to connect web application to SQL Server via ODBC
From: Ken Sturgeon (ksturgeon_at_genelco.com)
Date: 01/27/05
- Next message: Jared: "RE: Multiple-step operation generated errors"
- Previous message: Jared: "RE: Multiple-step operation generated errors"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 Jan 2005 12:09:05 -0600
I have an Active Server Page web application running on IIS installed on a
Windows 2003 Server that attempts to connect to SQL Server 2000 installed on
a separate Windows 2003 Server. The problem is that when the application
tries to connect it errors out with the following error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
The web application attempts to connect using a FileDSN and ironically, when
using the ODBC Manager in windows, it tests successfully. Even more
disturbing is the fact that our client also installed SQL Server 2000 on the
web box... I can see the data server through Enterprise Manager.
Although I've reviewed the application's configuration settings countless
times I thought it wise to create a test page that has the connection string
embedded in the source code thereby attempting to establish a "DSN'less"
connection. The same error is returned.
I'm clueless as to why this problem manifests when I get a successful ODBC
test in ODBC Manager and I can see the database from Enterprise Manger.
One thing has happened that may have an impact. the database server was
originally set up as a domain controller but later demoted.
Any help is greatly appreciated.
Ken Sturgeon
- Next message: Jared: "RE: Multiple-step operation generated errors"
- Previous message: Jared: "RE: Multiple-step operation generated errors"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
