asked on

ASP IIS DSN/ODBC issues

I am trying to set up a simple application. A survey with a front end in ASP. The data are inserted into a SQL server via system DSN/ODBC on IIS identically set up on my local machine and on a remote server (VM ware) that we're using for the first time. Although the application works fine locally, I have the following error as a result:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/ecru/surveys/africaRenewal/surveyonlineenglish.asp, line 113

Someone has an idea of what can possibly have occured?

Any assitance will be most welcome.

ASKER CERTIFIED SOLUTION

hongjun

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hongjun

You may also read this
http://support.microsoft.com/kb/306345

hongjun

kevp75

let's see your connection string.

This error usually means that it cannot find the server you are requesting it from, or the file (if access)
Also, the server may not support the driver you are attempting to use, so check out:
http://www.connectionstrings.com to see if there is an alternative

benoitmarcotte

ASKER

Thanks hongiun. That was a silly distraction. But I now have a new error message. If you could look into it:

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

hongjun

Most probably you are using a constant that is not defined.
Define them.

hongjun