• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 910
  • Last Modified:

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.
0
benoitmarcotte
Asked:
benoitmarcotte
  • 3
1 Solution
 
hongjunCommented:
Make sure you created a System DSN instead of a User DSN
0
 
hongjunCommented:
You may also read this
http://support.microsoft.com/kb/306345


hongjun
0
 
kevp75Commented:
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
0
 
benoitmarcotteAuthor 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.
0
 
hongjunCommented:
Most probably you are using a constant that is not defined.
Define them.

hongjun
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now