I've only been half-following this but Vista 64 bit does not work immediately with MySQL
ODBC data sources. You have to do this to get it to work:
http://bugs.mysql.com/bug.php?id=25259
Regards,
John Doolan, MCTS (Windows Applications)
Software Development Manager
Certified PRINCE2 Practitioner
e-mail: john.doolan@stripped
Minerva Computer Services, Orchard House, Mutton Lane, Potters Bar, Hertfordshire, EN6
3AX.
www.minervacomputers.com Registered in Great Britain. Company No. 1803671
-----Original Message-----
From: Ryan Hunter (PersonalFA) [mailto:rhunter@stripped]
Sent: 14 October 2009 13:30
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
> +1(480)308-0641 (voice)
> +1(602)996-0376 (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
>> +1(480)308-0641 (voice)
>> +1(602)996-0376 (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
>> (205) 586-5790
>> 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
>>> +1(480)308-0641 (voice)
>>> +1(602)996-0376 (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