CODEWITHSUNDEEP
mysqlodbc
AnujAroshA
AnujAroshA

Reputation: 4821

Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I am running SMS Enabler software in a Windows 7 environment. When a message received, the database is not updating and gives the error.

Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I also added the required field in Control Panel\All Control Panel Items\Administrative Tools > Data Sources (ODBC) > User DSN

I am using MySQL.

Upvotes: 6

Views: 49128

Answers (3)

CITBL
CITBL

Reputation: 1677

To use SMS Enabler with MySQL you should install MySQL Connector/ODBC 5.1 32-bit. You should install 32-bit version of this connector even if you are on 64 bit Windows. This is because SMS Enabler is a 32-bit software.

Upvotes: 1

Garry M. Biggs
Garry M. Biggs

Reputation: 279

OK.... If test connection succeeds and your app fails then it is probably one of those awkward environment issues..

Things to check -

  • Have you creates a System DSN or User DSN?

    If your application is running as a System Service then it will only able to read System DSNs (not User DSNs)

  • Was the Driver installed for all users or just the installation user?

    I have seen instances where this has affected some drivers...

  • Use Process Monitor (an excellent tool for tracking down issues like this)

    If you haven't used Process Monitor - think of it as a sniffer for; file accesses, registry accesses and network access...

    That is - you will be able to determine whether there are any files or registry accesses that are failing or being blocked.

Upvotes: 6

Garry M. Biggs
Garry M. Biggs

Reputation: 279

Wondering again whether this is a 32/64bit issue?

There are two ODBC administrators on 64bit machines...

c:\Windows\system32\odbcad32.exe === 64bit === Also through Control Panel

c:\Windows\SysWOW64\odbcad32.exe === 32bit

If your application is 32bit then you need a 32bit ODBC Driver and have to create a 32bit ODBC data source.

If your application is 64bit then, similarly, you need a 64bit ODBC Driver and have to create a 64bit ODBC data source.

I am wondering whether your application is 32bit and hence cannot find the 64bit ODBC data source you have created...

(NOTE: all of this is only applicable on 64bit Windows OSs...)

Upvotes: 0

Related Questions