locked
Data source name not found and no default driver specified RRS feed

  • Question

  • User99241475 posted

    Hi,

       I was trying to built a asp.net web app and I have theconnection string defined in the webconfig file. When I try to debug I am getting the following exception:

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

    The connection string looks like this:

    connectionString="Driver={MySQL ODBC 5.1 Driver};server=XX.XX.XX.XX;port=3306;database=db_name;user=username;pwd=pass;option=3;" providerName="System.Data.Odbc"/>

    The driver is installed and I can see it listed in the 'ODBC Data Source Administrator'.

    I tried changing the build configuration to 'Any CPU', still it failed.

    Can somebody help me out to figure whats going on here??

    Thanks,

    Uday

    Monday, November 21, 2011 4:21 PM

All replies

  • User99241475 posted

    I just want to add one more thing...if i use the same connection string in a console app, it works!!

    Monday, November 21, 2011 4:51 PM