Re: ODBC download problems

[Ryan Hunter \(PersonalFA\)]

Hello,

SUCCESS!!!!

I really appreciate all of the support and feedback from everyone.  It has 
made a very frustrating situation a little easier.

I finally think (fingers crossed) that I got it to work on my local host 
machine.

Here's what I did:
- I went to the mysql site here: 
http://dev.mysql.com/downloads/connector/odbc/3.51.html
- Instead of using the Windowsx64 downloads link I used the Windows download 
link and selected the MSI installer.  I downloaded the file.
- I then went to C:\Windows\SysWOW64 directory and found the odbcad32 
application.  (You can not see any of this from the control panel)
- I opened the application and went to the System DSN tab and clicked on 
Add.
- In the list I saw the ODBC 3.51 driver for MySQL and configured the 
connection.
- I am in the process of testing everything out, but it appears at first 
glance that it has worked successfully.

Thank you so much for everyone's feedback and advice.  This will save me a 
couple of headaches.

I also wanted to answer some additional questions that were asked from 
everyone.

I am using ASP.net files (ASPX)

I use a VB language.

One thing that I have thought about is that the need for the ODBC driver is 
on my home PC (development machine) and not the host.  When my aspx files 
are published on the host they work fine because the host obviously has the 
3.51 drivers.  However, on the development machine I could not get them to 
run from a local host perspective because I did not have the 3.51 driver 
installed (Hopefully I do now).  My old development machine was running a 32 
bit version of Windows XP, my new machine is using a 64 bit version of 
Windows Vista.  If I wasn't able to get it to work I think I might be able 
to do some work arounds.

I don't see the driver in this directory here:
C:\Windows\system32\myodbc5.dll

Once again, thank you so much for all of the help.

I will send everyone a confirmation to let you know if everything appears 
correct.

Thank you,

Ryan




--------------------------------------------------
From: "Jerry Schwartz" <jerry@stripped>
Sent: Wednesday, October 14, 2009 9:36 AM
To: "'Ryan Hunter (PersonalFA)'" <rhunter@stripped>; "'Lawson 
Cronlund'" <lawson@stripped>
Cc: <myodbc@stripped>
Subject: RE: ODBC download problems

> Did you say what your client application is? Perl, PHP, and others have 
> native
> access methods that don't require ODBC.
>
> Regards,
>
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: [phone]
>
> www.the-infoshop.com
>
>
>>-----Original Message-----
>>From: Ryan Hunter (PersonalFA) [mailto:rhunter@stripped]
>>Sent: Wednesday, October 14, 2009 8:30 AM
>>To: Lawson Cronlund
>>Cc: myodbc@stripped
>>Subject: Re: ODBC download problems
>>
>>Lawson,
>>
>>I appreciate the reply.
>>
>>Since it doesn't seem like I am going to get the ODBC driver working, 
>>could
>>you please give me some advice on how I can use an OCX for direct 
>>connection
>>to the database?
>>
>>I am not even sure what an OCX is.
>>
>>Thank you for all the help.
>>
>>Ryan
>>
>>--------------------------------------------------
>>From: "Lawson Cronlund" <lawson@stripped>
>>Sent: Tuesday, October 13, 2009 11:23 PM
>>To: "'Ryan Hunter (PersonalFA)'" <rhunter@stripped>
>>Cc: <myodbc@stripped>
>>Subject: RE: ODBC download problems
>>
>>> Ryan,
>>>
>>> My recollections are getting a little bit clearer.
>>>
>>> I was never able to get the 3.51 ODBC driver working.  I had the same
>>> problem that you describe (install and no driver in the ODBC list). 
>>> There
>>> was a solution to that which involved some registry manipulation if I
>>> recall
>>> correctly.  However even after that the ODBC driver didn't seem to 
>>> operate
>>> properly.  I was puzzled because other people seemed to get it working 
>>> but
>>> there were a lot of problem reports at that time.
>>>
>>> As I said, I gave up and used an OCX for direct connection to the
>>> database.
>>>
>>> However, there is a later version of the ODBC driver with both 32 and 64
>>> bit
>>> drivers for windows.  Here's the URL for the 64 bit driver:
>>>
>>> http://dev.mysql.com/downloads/connector/odbc/5.1.html#winx64
>>>
>>> I don't know if there are compatibility issues between the 5.1 version 
>>> and
>>> whatever MySQL version you're running.
>>>
>>> Hope this helps,
>>>
>>>
>>>
>>> Lawson Cronlund
>>> lawson@stripped
>>> [phone] (voice)
>>> [phone] (fax)
>>>
>>> -----Original Message-----
>>> From: Ryan Hunter (PersonalFA) [mailto:rhunter@stripped]
>>> Sent: Tuesday, October 13, 2009 8:30 PM
>>> To: Lawson Cronlund
>>> Cc: myodbc@stripped
>>> Subject: Re: ODBC download problems
>>>
>>> Lawson,
>>>
>>> I appreciate the help.
>>>
>>> I had the driver installed on my old PC is there anything I can do to
>>> transfer it and all the necessary files and registry over to my new pc?
>>>
>>> Do you have any other ideas?
>>>
>>> I don't know how else to connect to the mySQL database that I have on my
>>> web
>>>
>>> host.  It looks like the only MySQL ODBC driver they offer is the 3.51
>>> version.
>>>
>>> I would appreciate any help you could offer.
>>>
>>> Thank you,
>>>
>>> Ryan
>>>
>>> --------------------------------------------------
>>> From: "Lawson Cronlund" <lawson@stripped>
>>> Sent: Tuesday, October 13, 2009 1:22 PM
>>> To: "'Ryan Hunter (PersonalFA)'" <rhunter@stripped>
>>> Subject: RE: ODBC download problems
>>>
>>>> Ryan,
>>>>
>>>> Sorry about the typo (63 vs. 64).  I guess that wasn't your problem.  I
>>>> went
>>>> through a lot of trouble to discover that Vista only presented the 64 
>>>> bit
>>>> ODBC drivers and thought it might have been the trouble.  The
>>>> odbcad32.exe
>>>> program display the list of 32 bit ODBC drivers.
>>>>
>>>> I recall of the ODBC drivers where they didn't show up in the ODBC list
>>>> until some magic incantation was done.  I can't remember the steps
>>>> involved
>>>> in getting the driver to show up but it was when I was using one of the
>>>> 3.51
>>>> versions.  I eventually gave up and used a connector that I could 
>>>> compile
>>>> into my program to get the MySQL data.
>>>>
>>>> Sorry I can't help.  Good luck.
>>>>
>>>> Regards,
>>>>
>>>>
>>>>
>>>> Lawson Cronlund
>>>> lawson@stripped
>>>> [phone] (voice)
>>>> [phone] (fax)
>>>>
>>>> -----Original Message-----
>>>> From: Ryan Hunter (PersonalFA) [mailto:rhunter@stripped]
>>>> Sent: Monday, October 12, 2009 6:37 PM
>>>> To: Lawson Cronlund
>>>> Subject: Re: ODBC download problems
>>>>
>>>> Lawson,
>>>>
>>>> I appreciate the feedback.  I checked to see if I could find the 
>>>> drivers
>>>> in
>>>> the directory you referenced, and I had a SysWOW64 directory not 63.  I
>>>> did
>>>> see a file called odbcad32 but am unfamiliar with what to do once I get
>>>> there.  It appears to open up the ODBC administrator but don't see
>>>> anything
>>>> for MySQL ODBC driver 3.51 etc.  Maybe I am just missing something.  I
>>>> apologize again, but am not that tech savy when it comes to some of 
>>>> this
>>>> stuff.
>>>>
>>>> I really appreciate any help you can give to me.
>>>>
>>>> Thank you,
>>>>
>>>> Ryan Hunter
>>>> [phone]
>>>> rhunter@stripped
>>>>
>>>> --------------------------------------------------
>>>> From: "Lawson Cronlund" <lawson@stripped>
>>>> Sent: Friday, October 09, 2009 9:07 PM
>>>> To: "'Ryan Hunter (PersonalFA)'" <rhunter@stripped>
>>>> Subject: RE: ODBC download problems
>>>>
>>>>> Ryan,
>>>>>
>>>>> I've had a problem with ODBC in Vista64.  Vista64 seems to show only
> 
>>>>> the
>>>>> 64
>>>>> bit ODBC drivers in the control panel.
>>>>>
>>>>> I've had to go to:
>>>>>
>>>>>      C:\Windows\SysWOW63\odbcad32.exe
>>>>>
>>>>> to see the 32 bit ODBC drivers.
>>>>>
>>>>> Since the only install I saw in your email was for the 32 bit driver
>>>>> this
>>>>> might be the problem I've experienced.
>>>>>
>>>>> I don't know if this is the problem you're having but I hope it
> helps.
>>>>>
>>>>> Regards,
>>>>>
>>>>>
>>>>>
>>>>> Lawson Cronlund
>>>>> lawson@stripped
>>>>> [phone] (voice)
>>>>> [phone] (fax)
>>>>>
>>>>> -----Original Message-----
>>>>> From: Ryan Hunter (PersonalFA) [mailto:rhunter@stripped]
>>>>> Sent: Thursday, October 08, 2009 7:53 PM
>>>>> To: myodbc@stripped
>>>>> Subject: ODBC download problems
>>>>>
>>>>> Maybe you can help me out.  I am having trouble using the MySQL ODBC
>>>>> Driver
>>>>> 3.51.
>>>>>
>>>>> I am using Windows Vista 64 bit home premium.
>>>>>
>>>>> I went to your website last night to download the odbc and
> downloaded
>>>>> the
>>>>> mysql-connector-odbc-noinstall-3.51.27-winx64 drivers and tried to
>>>>> install
>>>>> them.  When I unzip the files and click on the install.bat file a 
>>>>> window
>>>>> pops up for less than 1 second and then disappears.  I still can not
> 
>>>>> see
>>>>> the
>>>>>
>>>>> odbc drivers anywhere on my pc.
>>>>>
>>>>> I went to the forums to try to get help and was directed to this
> page:
>>>>> http://mysql.oss.eznetsols.org/Downloads/Connector-ODBC/3.51/
>>>>>
>>>>> I clicked on this download and ran the wizard which seemed to work 
>>>>> fine
>>>>> mysql-connector-odbc-3.51.27-win32.msi
>>>>>
>>>>> However, after I ran the wizard I didn't see any new programs or the
>>>>> drivers
>>>>>
>>>>> still.
>>>>>
>>>>> I apologize, but I am not that experienced with MySQL or it's 
>>>>> products.
>>>>>
>>>>> Bottom line is that I am trying to install the MySQL ODBC 3.51 driver
> 
>>>>> on
>>>>> my
>>>>> home pc but am not having any luck doing so.
>>>>>
>>>>> I would appreciate any help that you can give to me.
>>>>>
>>>>> Thank you,
>>>>>
>>>>> Ryan
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>--
>>MySQL ODBC Mailing List
>>For list archives: http://lists.mysql.com/myodbc
>>To unsubscribe:    http://lists.mysql.com/myodbc?unsub=1
>
>
>
>
>