We help IT Professionals succeed at work.

ASP IIS DSN/ODBC issues

929 Views
Last Modified: 2008-01-09
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.
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

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


hongjun

Commented:
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

Author

Commented:
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.

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

hongjun
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.