Connect to the NF Database with JDBC

dietmarruef

Hello

It try to connect a Navision Database with the JDBC:ODBC Bridge.
But it doesn´t work. When I try to Connect a Error Occured:
"SQL Error: java.sql.SQLException: The result set type is not supported. 0 null".
Do anyone know the answer for this problem?
Or known somebody something about a Navision Financials JDBC Driver from Navision or from a third provider.
Please Help me.

John_Tegelaar

Use the JDBC-ODBC Bridge from Easysoft (www.easysoft.com), which does a good job. Don't forget to get the latest version of the Navision ODBC driver, though. Version before 2.6 are known to be unstable and buggy and lack functions.

John

dietmarruef

It is not possible to connect with the standard JDBC Driver from
Sun the NF Database?

John_Tegelaar

It's not impossible, but the Easysoft JOB (JDBC-ODBC Bridge) is superior by far. For example, EJOB is multi-threaded, Sun is single. This means for EJOB that you can have multiple users simultaneously, using only a single connection to the database. Check out the features on the Easysoft website.

John