B
Buddy Ackerman
I have a web app that I have setup on numerous web servers. I've set one up for a new client at their hosting facility
and cannot get it to connect to their database. I get a "SQL Server does not exist or access denied." error. Well, the
strangeness is that I have a SQL Query tool installed on this server and can connect to the database fine using the
exact same connection parameters that I have specified in my web app. Even more strange is that I have a copy of the
web app on a another web server at another location and I took the connection string from the web server that is not
working and put it on my copy and the copy connects and works fine. Well, it doesn't stop there, on the server that has
the problem I went to create an ODBC datasource just to see if it had any problem. Well, it connected fine but it
wouldn't see the database that I'm trying to connect to (I remind you though that I have connected to this database from
this and other machines with no problems and can query the database). I want to call the hosting facility support desk
to see if there is something funny going on with the database but I'm afraid that they'll just connect with query
analyzer and say there's nothing wrong with the DB and that I need to check my app configuration. I'm not sure where to
go from here, I need some suggestions.
One more thing, when I try to connect through the web app it takes about 30 seconds to return the "does not exist error"
(which is typical when the web server cannot find the DB server on the network). Also, I'm accessing the database
server using it's IP address. I've never see anything this strange before. I'll appreciate any suggestions.
--Buddy
and cannot get it to connect to their database. I get a "SQL Server does not exist or access denied." error. Well, the
strangeness is that I have a SQL Query tool installed on this server and can connect to the database fine using the
exact same connection parameters that I have specified in my web app. Even more strange is that I have a copy of the
web app on a another web server at another location and I took the connection string from the web server that is not
working and put it on my copy and the copy connects and works fine. Well, it doesn't stop there, on the server that has
the problem I went to create an ODBC datasource just to see if it had any problem. Well, it connected fine but it
wouldn't see the database that I'm trying to connect to (I remind you though that I have connected to this database from
this and other machines with no problems and can query the database). I want to call the hosting facility support desk
to see if there is something funny going on with the database but I'm afraid that they'll just connect with query
analyzer and say there's nothing wrong with the DB and that I need to check my app configuration. I'm not sure where to
go from here, I need some suggestions.
One more thing, when I try to connect through the web app it takes about 30 seconds to return the "does not exist error"
(which is typical when the web server cannot find the DB server on the network). Also, I'm accessing the database
server using it's IP address. I've never see anything this strange before. I'll appreciate any suggestions.
--Buddy