MyODBC 3.51-11-2 driver does not show in windows

Hi,

This seems like an eternal problem that will never be
solved, but here it is again. I tried all the
suggestions in the mailing lists about modifying the
registry and none of them work. I tried installing
MyOdbc 5 too, but I got the same problem.

I'm running Windows XP Professional Version 2002
Service Pack 1

I tried running the myodbcinst.exe program and this is
what I got:

C:\WINDOWS\system32>myodbcinst -q -d
SQL Server
Microsoft Access Driver (*.mdb)
Microsoft Text Driver (*.txt; *.csv)
Microsoft Excel Driver (*.xls)
Microsoft dBase Driver (*.dbf)
Microsoft Paradox Driver (*.db )
Microsoft Visual FoxPro Driver
Microsoft FoxPro VFP Driver (*.dbf)
Microsoft dBase VFP Driver (*.dbf)
Microsoft Access-Treiber (*.mdb)
Microsoft Text-Treiber (*.txt; *.csv)
Microsoft Excel-Treiber (*.xls)
Microsoft dBase-Treiber (*.dbf)
Microsoft Paradox-Treiber (*.db )
Microsoft Visual FoxPro-Treiber
Driver do Microsoft Access (*.mdb)
Driver da Microsoft para arquivos texto (*.txt; *.csv)
Driver do Microsoft Excel(*.xls)
Driver do Microsoft dBase (*.dbf)
Driver do Microsoft Paradox (*.db )
Driver para o Microsoft Visual FoxPro
Microsoft ODBC for Oracle
Oracle ODBC Driver

--> No driver here, this is the usual problem.

C:\WINDOWS\system32>myodbcinst -q -d -n"MySQL ODBC
3.51 Driver"
Name............: MySQL ODBC 3.51 Driver
DRIVER..........: C:\WINDOWS\System32\myodbc3.dll
SETUP...........: C:\WINDOWS\System32\myodbc3S.dll

--> ohhh, but it finds something...

C:\WINDOWS\system32>myodbcinst -a -d -t"MySQL ODBC
3.51 Driver;DRIVER=c:\\window
s\\system32\\myodbc3.dll;SETUP=c:\\windows\\system32\\myodbc 3S.dll"

[.\myodbcinst.c][611][INFO] Driver registered. Usage
count is 2. Location "C:\WINDOWS\System32\"

---> and it says it's registered already. Well, it
is... but what the hell?

This is really frustrating. Anybody has an update for
this problem? It has to be the installer. I don't see
any other reason.

Thanks,
Alexis





Programming Tutorial:
In Python: To do this, do this
In Perl: To do this, do this or this or this or this...
In C: To do this, do this, but be careful
In C++: To do this, do this, but don't do this, be careful of this, watch out for this, and whatever you do, don't do this




______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC 3.51-11-2 driver does not show in windows

Alexis,

On recent MS Windows platforms (ie yours) the ODBC system information is
stored in two different places - in ini files and in the registry. So
for drivers;

1) the windows\system32\odbcinst.ini
2) the registery

Calls such as SQLGetPrivateProfileString/SQLWritePrivateProfileString
are supposed to hide this from us (both of which are used by myodbc) but
never the less - changes introduced to the location and the format of
this information is a problem which is only made worse by the steady
trickle of changes for supporting 64bit drivers.

fyi; we are using XP Pro SP2 for myodbc development

So the problem could be the installer but it could also be the way the
system information is read/written.

I recommend that you try to back out all of the myodbc stuff and try the
install again.

Alexis H. Rivera-Rios wrote:

>Hi,
>
>This seems like an eternal problem that will never be
>solved, but here it is again. I tried all the
>suggestions in the mailing lists about modifying the
>registry and none of them work. I tried installing
>MyOdbc 5 too, but I got the same problem.
>
>I'm running Windows XP Professional Version 2002
>Service Pack 1
>
>I tried running the myodbcinst.exe program and this is
>what I got:
>
>C:\WINDOWS\system32>myodbcinst -q -d
>SQL Server
>Microsoft Access Driver (*.mdb)
>Microsoft Text Driver (*.txt; *.csv)
>Microsoft Excel Driver (*.xls)
>Microsoft dBase Driver (*.dbf)
>Microsoft Paradox Driver (*.db )
>Microsoft Visual FoxPro Driver
>Microsoft FoxPro VFP Driver (*.dbf)
>Microsoft dBase VFP Driver (*.dbf)
>Microsoft Access-Treiber (*.mdb)
>Microsoft Text-Treiber (*.txt; *.csv)
>Microsoft Excel-Treiber (*.xls)
>Microsoft dBase-Treiber (*.dbf)
>Microsoft Paradox-Treiber (*.db )
>Microsoft Visual FoxPro-Treiber
>Driver do Microsoft Access (*.mdb)
>Driver da Microsoft para arquivos texto (*.txt; *.csv)
>Driver do Microsoft Excel(*.xls)
>Driver do Microsoft dBase (*.dbf)
>Driver do Microsoft Paradox (*.db )
>Driver para o Microsoft Visual FoxPro
>Microsoft ODBC for Oracle
>Oracle ODBC Driver
>
>--> No driver here, this is the usual problem.
>
>C:\WINDOWS\system32>myodbcinst -q -d -n"MySQL ODBC
>3.51 Driver"
>Name............: MySQL ODBC 3.51 Driver
>DRIVER..........: C:\WINDOWS\System32\myodbc3.dll
>SETUP...........: C:\WINDOWS\System32\myodbc3S.dll
>
>--> ohhh, but it finds something...
>
>C:\WINDOWS\system32>myodbcinst -a -d -t"MySQL ODBC
>3.51 Driver;DRIVER=c:\\window
>s\\system32\\myodbc3.dll;SETUP=c:\\windows\\system32\\myodb c3S.dll"
>
>[.\myodbcinst.c][611][INFO] Driver registered. Usage
>count is 2. Location "C:\WINDOWS\System32\"
>
>---> and it says it's registered already. Well, it
>is... but what the hell?
>
>This is really frustrating. Anybody has an update for
>this problem? It has to be the installer. I don't see
>any other reason.
>
>Thanks,
>Alexis
>
>
>
>
>
>Programming Tutorial:
>In Python: To do this, do this
>In Perl: To do this, do this or this or this or this...
>In C: To do this, do this, but be careful
>In C++: To do this, do this, but don't do this, be careful of this, watch out for this, and whatever you do, don't do this
>
>
>
>
>______________________________________________________
>Yahoo! for Good
>Donate to the Hurricane Katrina relief effort.
>http://store.yahoo.com/redcross-donate3/
>
>
>
>


--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org