Solved

No odbc showing up after installation

Posted on 2011-03-07
11
615 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

724 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