Going from bad to worse
Posted by: Ronald Gans
Date: September 11, 2013 08:20AM

I am trying to make MySQL work with ASP.NET (VS 2012 Web edition). I downloaded the MySql Workbench (community edition); created a table in one of the default dbs and can successfully query the table. So I know that works to some extent. Now I'm trying to create an ODBC connection. So I downloaded the 5.2 ANSI Drive (64-bit). But that didn't work. I put this into my webconfig file:

<connectionStrings>
<add name="MySQLConnStr" connectionString="{DRIVER=MySql ODBC 5.2 ANSI Driver};Database=world;Server=MySQL10;UID=XX;PWD=XXXXXX;"/>
</connectionStrings>

I get Datasource name not found; no drive specified.


I'm using the 32-bit driver.

From the Workbench, things look OK (to my untrained eye).

I've looked at ConnectionStrings.com but that doesn't seem to make a difference.

******************
NOT SURE WHAT HAPPENED: I moved the connection string data from the webconfig.xml to the app itself and, magically, it worked.


RON



Edited 3 time(s). Last edit at 09/11/2013 09:10AM by Ronald Gans.

Options: ReplyQuote


Subject
Written By
Posted
Going from bad to worse
September 11, 2013 08:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.