This topic is locked

ODBC Drivers error '80004005'

4/1/2008 12:38:29 PM
ASPRunnerPro General questions
S
soberholtzer author

I have generated a simple set of pages through SAPRunnerPro 5.2 and FTP the files to my Windows Hosting Account at GoDaddy.com. The site is running asp.net 2.0 and IIS 6.0.
When trying to display the page, I receive the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/include/dbcommon.asp, line 122
I am trying to determine first if this is a problem with the host server or with the code that has been generated based on the setting that I chose in my project.
Any ideas?

W
Wazup 4/1/2008

I have generated a simple set of pages through SAPRunnerPro 5.2 and FTP the files to my Windows Hosting Account at GoDaddy.com. The site is running asp.net 2.0 and IIS 6.0.

When trying to display the page, I receive the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/include/dbcommon.asp, line 122
I am trying to determine first if this is a problem with the host server or with the code that has been generated based on the setting that I chose in my project.
Any ideas?


This will sound dumb, BUT do you have a DB on the Hosting Server? I don't think I know of anyone using an SQL DB on godaddy.com. Most hosters will not provide you with DB services, at least where I live in western Canada.
Could be wrong, but that's what that error tells me.

J
Jane 4/2/2008

Hi,
this error message means connection string is incorrect and ASP engine cannot locate your database.

Connection string can be found in include/dbconnection.asp file.

W
Wazup 4/6/2008

Hi,

this error message means connection string is incorrect and ASP engine cannot locate your database.

Connection string can be found in include/dbconnection.asp file.


Jane, I understand and realize what your reply means and the why.
However, if it were a connection string error, a connection to the DB could not be made at design time so how could the files have been genned if the string was incorrect?
Just curious, cause I know that this error (in addition to the other 120 or so related messages) can be caused by no access to the schema or datasource on a hosted site. Ran into this dozens of times.
But, I would be interested in an answer to the first part of my post.
Cheers.

Admin 4/6/2008

In design time ASPRunnerPro connects to the database on your local box.

When you access generated application ASP pages connect to your database on the web server.
You need to make sure:

  1. Database is uploaded to the web server
  2. Connection string points to your database (connection string can be found in include/dbconnection.asp file)
    Probably the best way to resolve this is to contact support team at support@xlinesof.com supplying FTP connection info.