ODBC Troubleshooting - Revision history

Philip Lacey at 19:52, 9 November 2014

2014-11-09T19:52:16Z

Philip Lacey at 14:35, 23 October 2014

2014-10-23T14:35:45Z

Philip Lacey: Created page with " == 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 serv..."

2014-10-23T14:35:00Z

Created page with " == 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 serv..."

New page

== 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

== Step 1: Download latest C++ package ==

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

If step 1 fails proceed to step 2

== Step 2: Download latest .NET package ==

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

If step 2 fails proceed to step 3

== Step 3: Try fix the dll ==

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

← Older revision		Revision as of 19:52, 9 November 2014
Line 44:		Line 44:
	#This will create a new “msvcr100.dll” in the system32 folder.		#This will create a new “msvcr100.dll” in the system32 folder.
	#Execute the ODBC install file on the machine.		#Execute the ODBC install file on the machine.
		+
		+
		+
		+	[[Category:Topic:Support]]

@@ Line 21: / Line 21: @@
 #Copy the file from the Database server to the Web server
 #Execute the ODBC install file on the machine
 If step 1 fails proceed to step 2
@@ Line 31: / Line 32: @@
 #Copy the file from the database server onto the web server
 #Execute the ODBC install file on the machine
 If step 2 fails proceed to step 3