All geek questions in one place

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

I run SMS Enabler software in a Windows 7 environment. When the received message the database does not update and gives an error

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

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

I am using MySQL

+6
source share
3 answers

OK .... If the test connection succeeds and your application fails, perhaps this is one of the inconvenience issues.

What you need to check -

  • Are you creating a system DSN or custom DSN?

    If your application runs as a system service, it will be able to read system DSNs (not user DSNs)

  • Is the driver installed for all users or only for the installation user?

    I saw examples when this affected some drivers ...

  • Use Process Monitor (a great tool to track such issues)

    If you have not used Process Monitor - think of it as a sniffer; file access, registry access and network access ...

    That is, you can determine if there are files or registries that are not working or are being blocked.

+6
source

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

+1
source

Once again I wonder if this is a 32/64 bit problem?

On 64-bit machines, there are two ODBC administrators ...

c: \ Windows \ system32 \ odbcad32.exe === 64bit === Also through the control panel

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

If your application is 32-bit, you need a 32-bit ODBC driver and you need to create a 32-bit ODBC data source.

If your application has 64-bit, then in the same way, you will need a 64-bit ODBC driver and must create a 64-bit ODBC data source.

I am wondering if your application is 32-bit and therefore cannot find the 64-bit ODBC data source that you created ...

(NOTE: all this applies only to 64-bit Windows ...)

0
source

Source: https://habr.com/ru/post/887174/

More articles:


All Articles