RE: ODBC download problems

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: [email protected] 

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:[email protected]] 
Sent: 14 October 2009 13:30
To: Lawson Cronlund
Cc: [email protected]
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" <[email protected]>
Sent: Tuesday, October 13, 2009 11:23 PM
To: "'Ryan Hunter (PersonalFA)'" <[email protected]>
Cc: <[email protected]>
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
> [email protected]
> +1(480)308-0641 (voice)
> +1(602)996-0376 (fax)
>
> -----Original Message-----
> From: Ryan Hunter (PersonalFA) [mailto:[email protected]]
> Sent: Tuesday, October 13, 2009 8:30 PM
> To: Lawson Cronlund
> Cc: [email protected]
> 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" <[email protected]>
> Sent: Tuesday, October 13, 2009 1:22 PM
> To: "'Ryan Hunter (PersonalFA)'" <[email protected]>
> 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
>> [email protected]
>> +1(480)308-0641 (voice)
>> +1(602)996-0376 (fax)
>>
>> -----Original Message-----
>> From: Ryan Hunter (PersonalFA) [mailto:[email protected]]
>> 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
>> [email protected]
>>
>> --------------------------------------------------
>> From: "Lawson Cronlund" <[email protected]>
>> Sent: Friday, October 09, 2009 9:07 PM
>> To: "'Ryan Hunter (PersonalFA)'" <[email protected]>
>> 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
>>> [email protected]
>>> +1(480)308-0641 (voice)
>>> +1(602)996-0376 (fax)
>>>
>>> -----Original Message-----
>>> From: Ryan Hunter (PersonalFA) [mailto:[email protected]]
>>> Sent: Thursday, October 08, 2009 7:53 PM
>>> To: [email protected]
>>> 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/[email protected]



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]