Search code examples
vb.netodbcadvanced-installer

"[ODBC Driver Manager] Data Source name not found and no default driver specified"

I created a vb project and made an installer of it, it works fine with my PC, and it also works on some of the users who used the system on their machine. But, there's this particular user who received this error.

I tried:

  1. checking my connection string on my vb project just to make sure, but it's fine.
  2. check if my system deployed is 32 bit and the MySQL ODBC connector, both are 32 bit.
  3. tried checking if the MySQL ODBC driver is properly installed on the 32-bit ODBC data source, I search this ⊞ Win + R (c:\windows\sysWOW64\odbcad32.exe) to make sure that I'm in a 32-bit data source, since both 64 bit and 32-bit data source has the same name on my laptop.

64-bit Data Source

32-bit Data Source

Also, I noticed that the drivers installed on 32-bit data source doesn't have version, company and such (refer to image 2), while on the 64-bit data source it does have version, company and such (refer to image 1).

Solution

  • It turns out that the network of that particular user has blocked the access to the installed drivers, it got resolved when they connected to a different network.