DSNless Database Connections

[Michael42]

Hello, how can I create JDBC:ODBC connection without requiring a DSN being configured on every client system?

This is what I do now. "Support" is my local system's ODBC DSN name.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"
Connection oConnection = DriverManager.getConnection("jdbcdbc:Support"

My target environment is an Applet where the DSN would not be configured. Maybe I am missing something being new to Java???

Thanks!

Michael

 

[ezl]

Hi...

I recently encountered this issue myself...

The way I circumvented it was to make database connections from the server only (I set up the dsn, etc. on the server). I then wrote a component (again, on the server)that accepts TCP/IP connections from the various clients. So all the clients have to do is pass their data via TCP/IP and the component on the server handles the database connections.

DISCLOSURE: I, too, am new to Java, so I don't know if this is the preferred way to do it, or just a stupid hack because I don't know any better!

Good Luck!