unixODBC JDBC MDBTOOLS conflicts

----- Messaggio inoltrato -----
Da: Antonello Parente <[email protected]>
A: [email protected]
Inviato: Martedì 8 maggio 2007, 23:53:41
Oggetto: 

Hi,
I'm not able to connect jdbc:odbc bridge to unixODBC data source.
I have a .mdb database linked to unixODBC by linmdbodbc.

I try the connection using isql <data_source_name> and it works fine.

When i try to connect by my java application it does'nt work:

if I write:
con = DriverManager.getConnection("jdbc:odbc:<data_source_name>");

it throws an sql exception:

The result set type is not supported.

If I write

con = DriverManager.getConnection("jdbc:odbc:Driver{<Driver_Name>};DBQ=<database_filename>");

it throws an sql exception

[unixODBC][Driver Manager]Data source name not found, and not default driver specified.

Please Help me

Antonello Parente



		 L'email della prossima generazione? Puoi averla con la  nuova Yahoo! Mail





      ___________________________________ 
L'email della prossima generazione? Puoi averla con la nuova Yahoo! Mail: http://it.docs.yahoo.com/nowyoucan.html

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/

_______________________________________________
mdbtools-dev mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev