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

Posted on 2008-11-18
Last Modified: 2012-08-13
Hi ,
when ia m trying to unit test my application using Visual studio unit tests when i am testing the webservice call my test is failing and giving me this message .
as i am doing this as part of migration from earlier version..

"Test method BusinessLogicUnitTest.xxRepositoryTest.IsOpenTest threw exception:  System.Web.Services.Protocols.SoapException: Server was unable to process request. --> ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."

System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
BusinessLogic.Info.Isxyz(String osAttrCode, String osDateInQuestion, String osTimeInQuestion) in
Question by:Swetha_aJaX
    LVL 6

    Accepted Solution

    The error message says Data Source Name not found.  If this is a webserver application, create a System Data Source Name on the webserver or if its a desktop application, create it on your desktop.
    To create Data Source Name:
    Control Panel => Administrative Tools => Data Souces (ODBC)

    Please select System DSN so that it applies for all users

    Author Comment

    It is happening when i am calling web service from my application.
    is there any problem withthe webservice or my app ?
    LVL 6

    Expert Comment

    From the error message, it appears the issue is in the WebService.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    745 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

    13 Experts available now in Live!

    Get 1:1 Help Now