Posted on 2007-10-05
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.
Question by:benoitmarcotte
    LVL 33

    Accepted Solution

    Make sure you created a System DSN instead of a User DSN
    LVL 33

    Expert Comment

    You may also read this

    LVL 25

    Expert Comment

    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: to see if there is an alternative

    Author Comment

    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.
    LVL 33

    Expert Comment

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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now