How to connect to a Navision Server
843854Nov 8 2004 — edited Nov 8 2004Hi,
I don't have any experience with MS Navision. Now I have to query from my application, which is installed on a Linux server, a Navision Database on a Windows Server. The Navision administrator has given me the ODBC Connection String
ODBC;DSN=XXXXXX;CSF=Yes;SName=XXXXXX;NType=TCP;CS=30000;OPT=Text;IT=All Except DOT;QT=300;QTYesNo=Yes;RO=Yes;CC=Yes;BE=Yes;CD=No;ML=2055;RD=No;UID=XXXXXX;PWD=XXXXXX;CN=HIN SCHARF;SERVER=N;
I tried to use the JDBC-ODBC bridge with it "jdbc:odbc:XXXXXX..." or "jdbc:odbc;DSN=..." but it did not work (in the first case I got a NullPointerException, in the second a No suitable driver Exception).
I also tried with the MS SQLServer drivers (url : jdbc:microsoft:sqlserver://[SName];...) but it did not work.
Which driver should I use? How is the connection string like?
Thanks a lot for your help.
Patrick