SequelLink Doesn't Show up as a Data Source

[Aaron Edwards]

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

[laker_42]

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

[Walter B]

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?

[laker_42]

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

[Walter B]

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.

[laker_42]

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

[sorinz]

Uninstall and install again and will be there.