can't see ODBC driver

[stephenrappaport]

Hi - I've followed FM instructions for installing the ODBC driver for Windows. Following installation, I can't see the driver in the 'driver's tab, yet when I open registry it's there.

FM instructions say to install/reinstall and if that doesn't work to delete the 'default' entry in registry editor for the driver. Reinstallation changed nothing, and I'm unable to delete the 'default' line from the registry (though I can the value of the default option).

Your thoughts on how to make the driver visible are very welcome. Thanks for your time and assistance.

. Steve

[alelie]

You need to add your data source driver within Windows -

Go to the Start menu/Settings/Control Panel

Double click on Administrative tools

Double click on Data Sources (ODBC)

Add driver...

[jlze]

I was having the same issue and I found this article that is listed below on the datadirect website. Deleted the defaults and deleted drivers not needed and it worked.

=

After installing the Connect for ODBC drivers on a Windows platform, no listing appears for any of the drivers under the Drivers tab of the Microsoft ODBC Data Source Administrator.

A quick check of the registry listing at HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INI and HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers shows appropriate registry key entries for drivers which would indicate that the drivers were successfully installed.

Successive attempts to install/reinstall the drivers do not resolve the issue.

In the windows registry editor tool ( regedit.exe ), open the registry key

HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers

Look for an entry in this key whose name is

(Default)

The value of this entry should be

(value not set)

When experiencing the problem described above, the value is actually set to an empty string.

[Vuye Armand]

I had the same problem. I worked with ODBC in FM 6.0 yor years. As soon as FM 7 was launched I was trying to install the ODBC driver. It was my intention to do so on several computers. Interestingly I was able to do so on a single machine (after a single retry). But it did not work on all the other computers. In the months thereafter I read the suggestions about deleting the default key in the registry, the white paper on the FM website, everything. I tried it at least 100 times, registry .. uninstall .. reinstall. It does not work. It looks a matter of chance. On some computers (all except one in my experience) it will not work. The factor why is not identifiable.

[mcyrulik]

Another thing that worked for me when I had this problem: in the registry go to:

HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers

if there are two default values, delete them until you only have one that is labeled (value not set).

Open up Data Sources and it should show up.

[ave!]

There is a note about this problem in the official document named 'Installing FileMaker 7 ODBC and JDBC Client Drivers'.

http://www.filemaker.com/downloads/pdf/fm7_odbc_jdbc_install.pdf

--

If it doesn't work, try this.

It always worked fine for me.

1. With "regedit" program, export the key [HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers] to a file (e.g. odbc.reg).

2. Delete the key [HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers] in the registry. Then quit "regedit".

3. Open the exported file with "Notepad" program and delete the following line and save the file.

@=""

4. Import the file from "regedit".

--

I found it in the MySQL bug tracker.

http://bugs.mysql.com/bug.php?id=4303

Hope this helps.

Edited October 26, 2005 by Guest

[New_2_FM]

Cool... this works for me.

thanx.

Jackson