Mongodb Mongodb - 5 months ago 23
MySQL Question

Connecting to mysql via odbc in a 64 bit system

I have installed the community server on my computer but for some reason i keep on getting this error

Driver={MySQL ODBC 5.3 ANSI Driver};Server=localhost;Database=smsserver;
User=root;Password=123456;Option=3;

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


This is my connection string

Driver={MySQL ODBC 5.3 ANSI Driver};Server=localhost;Database=smsserver;
User=root;Password=123456;Option=3;


I have not done anything really,i just installed the community edition and tried to connect.

Answer

This should work:

Provider=MSDASQL;Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;

Data origin