NODBC dsn in java anyone?

seb835

Hi,

I'm trying to connect to my NODBC DSN within a simple java applet. THe problem is that I dont know the syntax to make the connection string - can anyone help?

What im using at the moment is the following connection string (which doesnt work):

navURL    = "jdbc:odbc:Driver={Microsoft Navision Driver};" + "dsn='test_dsn'; uid='seb'; pwd='seb_pass'";

navCon   = DriverManager.getConnection(navURL);

This gives the following error at run-time:


Outer TRY failed java.sql.SQLException: [Simba][SimbaEngine ODBC Driver][DRM File Library]Invalid Session handle.


Please can anyone help? It would be very much appreciated.

Thank you
Seb

seb835

YO!

I found out how to do it y'all!

Use the following:

navCon   = DriverManager.getConnection("jdbc:odbc:my_dsn", "my_user", "my_pass");

Yes! I am a programming GOD! Woohooooooooooo!

</euphoric outburst>

Seb

Savatage

=D>