SequelLink Doesn't Show up as a Data Source

December 21, 200421 yr

Newbies

Hi,

I'm trying to share data from FM7 with an Access database. I installed SequelLink according to the FM help pages, but it doesn't show up as a datasource in the ODBC section of Administrative Tools. What am I doing wrong?

I'm on an XP machine, running the latest MDAC, fresh installation of FM7.

Thanks.

Aaron

4 weeks later...

January 13, 200521 yr

You need to delete an entry out of your registry. Here are the instructions:

DataDirect KnowledgeBase

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.

To correct the problem, simply right-click on "(Default)", select "Delete" from the drop-down menu and click "Yes" to confirm that you wish to delete this value.

Doing so should restore "(Default)" to its correct value, "(value not set)". After doing this, uninstall and resinstall your ODBC drivers and you should be able to see them in the ODBC Data Source Administrator.

HTH

John

January 14, 200521 yr

Not to put to fine a point on it, but, did you remember to turn on ODBC/JDBC in sharing in the FMP file you are using as a ODBC datasource?

January 18, 200520 yr

It should show up as a data source even if ODBC isn't turned on in a FMP file. That doesn't matter until you actually try to connect to the file via ODBC.

John

January 18, 200520 yr

Clarification, is the DataDirect drive not displayed in the list of ODBC driver, or can you not see the file you are trying to connect into? If you can select the driver, then you need to have the file on the server set up to allow xDBC connections before you can set up a datasource. Driver and datasource are two different issue with different solutions.

January 19, 200520 yr

I installed SequelLink according to the FM help pages, [color:"red"]but it doesn't show up as a datasource in the ODBC section of Administrative Tools.

John