Data source name not found and no default driver specified (ODBC)

Question

Hi,

I have a ASP.NET webapplication where I use ODBCConnection to connect a MySQL server, it will take the connectionstring from the web.config file and this works grate.

But when I put the same code in a WPF application and hardcode the same connection string I get the followin exception when runnint ODBCConnection.Open() :

Data source name not found and no default driver specified

I have checked the ODBCConnection orbject and its instansiated with the exact same connectionstring as in the webapplication.

The connection string looks like this :

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=X.X.X.X;DATABASE=X;USER=X;PASSWORD=X;OPTION=3"

The X is set to propert values

I am running both from the same computer so the MYSQL ODBC connection is installed correct.

Pleas advice.

BestRegards

Banshee · Accepted Answer · 2011-01-03 11:39:22Z

1

The problem was resolved by changing the Building for CPU from Any to x86 on thw WPF application.

answered Jan 3, 2011 at 11:39

Banshee

15.9k41 gold badges139 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data source name not found and no default driver specified (ODBC)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related