• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • Last Modified:

No odbc showing up after installation

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
lapucca
Asked:
lapucca
  • 6
  • 5
1 Solution
 
derekkrommCommented:
Incredibly sorry - I misread your initial question. You should install the 64-bit drivers.
0
 
derekkrommCommented:
If that works, just cancel this question and get your points refunded.
0
 
lapuccaAuthor Commented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
derekkrommCommented:
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
 
lapuccaAuthor Commented:
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
 
derekkrommCommented:
0
 
lapuccaAuthor Commented:
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
 
derekkrommCommented:
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
 
lapuccaAuthor Commented:
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
 
derekkrommCommented:
Correct
0
 
lapuccaAuthor Commented:
Thank you for clarifying this confusing issue for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now