Solved

No odbc showing up after installation

Posted on 2011-03-07
11
611 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

744 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

14 Experts available now in Live!

Get 1:1 Help Now