Solved

No odbc showing up after installation

Posted on 2011-03-07
11
612 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
 
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now