Connect to the NF Database with JDBC

dietmarruef
dietmarruef Member Posts: 48
edited 2001-07-27 in Navision Financials
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.

Comments

  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    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
    dietmarruef Member Posts: 48
    It is not possible to connect with the standard JDBC Driver from
    Sun the NF Database?
  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    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

Categories