ODBC Troubleshooting

Contents

1 Introduction

This is an document in relation to the process involved with installing the ODBC file. The error that occurred was on both the web server and the DB server.

  • The file installed correctly after step 1 on the db server
  • The file installed correctly after step 3 on the webserver.

Common error code for installation on db server and Web server 1 :

MySQL Connector/ODBC 5.1 -- Error 1918.Error installing ODBC driver MySQL ODBC 5.1 ANSI Driver, ODBC error 13: The setup routines for the MySQL ODBC 5.2 ANSI Driver ODBC driver could not be loaded due to system error code 193: .. Verify that the file MySQL ODBC 5.1 ANSI Driver exists and that you can access it.

The best solution for this is to go through these method to solve the problem


2 Step 1: Download latest C++ package

  1. Download the latest “Microsoft C++ x64 redistributable package” from the Microsoft website
  2. Copy the file using Filezila onto the Database server
  3. Copy the file from the Database server to the Web server
  4. Execute the ODBC install file on the machine


If step 1 fails proceed to step 2


3 Step 2: Download latest .NET package

  1. Download the latest “Microsoft .net frameworks package” current version is 4.5
  2. Copy the file using Filezilla onto the database server
  3. Copy the file from the database server onto the web server
  4. Execute the ODBC install file on the machine


If step 2 fails proceed to step 3


4 Step 3: Try fix the dll

  1. On the machine where you want to install ODBC go to the directory “C:\Windows\System32”
  2. Locate the file “msvcr100.dll” and remove it from this folder to a back-up location.
  3. Reinstall the “Microsoft C++ x64 redistributable package” on the machine
  4. This will create a new “msvcr100.dll” in the system32 folder.
  5. Execute the ODBC install file on the machine.