Solved

No odbc showing up after installation

Posted on 2011-03-07
11
613 Views
Last Modified: 2012-05-11
Hi, I'm using sql 2005 express(32bit, x86) on windows 7 enterprise(64bit).  I want to set up a link server for mysql.
I downloaded and installed the mysql-connector-odbc-5.1.8-win32.msi, mysql odbc connector drvier.  I run this and it seeems to install no problem.(any other step after this?)  I then run odbc32ad.exe, click on the the System DNS, but there is no odbc driver for me to select.  There is only "sql native client" and "sql server".  
I check the local drive, C:\Program Files (x86)\MySQL\Connector ODBC 5.1, and there is several files in there folder including some dlls, pdb and a "myodbc-installer.exe".  Do I need to run this installer exe again?  I double click on it and it flases a cmd dialog box then closes it very quickly.  How can I get this driver installed?  Thanks.
0
Comment
Question by:lapucca
  • 6
  • 5
11 Comments
 
LVL 15

Expert Comment

by:derekkromm
ID: 35059879
Incredibly sorry - I misread your initial question. You should install the 64-bit drivers.
0
 
LVL 15

Expert Comment

by:derekkromm
ID: 35059883
If that works, just cancel this question and get your points refunded.
0
 

Author Comment

by:lapucca
ID: 35060033
NP, you still help me with that question here.
I did a complete install.  In the installation panel it seems to be saying that it will install both 32bit and 63 bit driver.  I'm running mysql-connector-odbc-5.1.8-winx64.msi.  
Should I use DDBC.EXE or ODBCAD32.EXE to add this System DSN?  I ran both, did not complete the process, and now it both detects the odbc driver.  Does it matter which one I run?  thanks.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 15

Expert Comment

by:derekkromm
ID: 35060073
You'll still run the odbcad32 utility. Even though it says "32", your OS should have a 64-bit version that it is using.

0
 

Author Comment

by:lapucca
ID: 35060143
Sorry Derek, I didn't quite get what you mean.  I assume the ODBC.EXE is the 64bit version.  Should I run this if I want 64 bit version?  Why do I want to run odbcad32.exe and assuming that OS would "have" a 64bit?  Do you mean these 2 are the same program ire-regardless which exe I execute?  thanks.
0
 
LVL 15

Expert Comment

by:derekkromm
ID: 35060168
0
 

Author Comment

by:lapucca
ID: 35060253
From the URL, "The 32-bit version of the ODBC Administrator tool displays 32-bit system DSNs, 32-bit user DSNs, and 64-bit user DSNs. The 64-bit version of the ODBC Administrator tool displays 64-bit system DSNs, 32-bit user DSNs, and 64-bit user DSNs."
So, if I run the ODBCAD32.EXE then in the System DSN when I click add, the MYSql ODBC driver 5.1 that I see is a 32 bit version of this driver?  Is this what I want?  thanks.
0
 
LVL 15

Expert Comment

by:derekkromm
ID: 35060301
If you installed both the 32 and 64-bit versions, you may see both.

If you only see 1, it should be choosing the 64-bit version over the 32-bit.
0
 

Author Comment

by:lapucca
ID: 35060356
I only ran the 64 bit version but like I said the installation panel says it's installing both 32bit and 64bit.  But, both odbc exe are only showing 1 odbc driver so I guess I would be fine running either odbc.exe or odbcad32.exe, right?  Thanks.
0
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 35060360
Correct
0
 

Author Closing Comment

by:lapucca
ID: 35060422
Thank you for clarifying this confusing issue for me.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question