topic Re: Sequelink JDBC Driver - Filemaker Pro 7 in Talend Studio

Sequelink JDBC Driver - Filemaker Pro 7

Anonymous — Sat, 16 Nov 2024 14:28:10 GMT

Hello,
I need some help on the following :
I need to connect to a Filemaker Pro 7 database.
I succeded using Sequelink ODBC driver.
Now I need to use the Sequelink JDBC driver, but I can't figure how to configure it.
I added the drivers in my classpath : Set CLASSPATH=%CLASSPATH%;C:\Program Files\Java\jdbc_fmp\driver\lib/sljc.jar
I tried with a Database Connection but I can't find my driver in the DB type and if I try to force the Sequelink driver I get the folowing error : No suitable driver found for jdbc:sequelink://localhost:2399;databaseName=ArticlePDV
I tried with a tJDBCInput but I get the following error : Database connection is failed in Built-In mode.
Must specify port after ':' in connection string

See screen copies.
Thanks in advence for your help,
Olivier.

Re: Sequelink JDBC Driver - Filemaker Pro 7

Anonymous — Thu, 31 Jan 2008 06:47:36 GMT

Hi
Which version of TOS did you use?

I tried with a Database Connection but I can't find my driver in the DB type and if I try to force the Sequelink driver I get the folowing error : No suitable driver found for jdbc:sequelink://localhost:2399;databaseName=ArticlePDV

There is not a DB type for Filemaker Pro 7 database, so, it can't be successful in this way.
Best regards

shong

Re: Sequelink JDBC Driver - Filemaker Pro 7

Anonymous — Thu, 31 Jan 2008 07:49:53 GMT

Hello,
TOS version is 2.2.3.r7292.
Best regards,
Olivier.

Re: Sequelink JDBC Driver - Filemaker Pro 7

_AnonymousUser — Wed, 09 Apr 2008 10:27:56 GMT

where Can I find slje.jar??

Re: Sequelink JDBC Driver - Filemaker Pro 7

_AnonymousUser — Mon, 09 Nov 2009 11:59:20 GMT

Hi
Which version of TOS did you use?

I tried with a Database Connection but I can't find my driver in the DB type and if I try to force the Sequelink driver I get the folowing error : No suitable driver found for jdbc:sequelink://localhost:2399;databaseName=ArticlePDV

There is not a DB type for Filemaker Pro 7 database, so, it can't be successful in this way.
Best regards

shong

I've fiexed this problem with using serverDataSource instead of databaseName.
With "jdbc:sequelink://localhost:2399;serverDataSource=BUILDAQ_DATA" it works fine.