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

Question

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.

Answer 1

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.

Answer 2

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.