Hi All,
I have a problem with my application... I am connected to a JDBC:ODBC MS-ACCESS Driver - No problem. In IDE when I run my application, all is allright and there is no error. But ...

my code (source JABACO Forum April 2009) :
Dim Con As java#sql#Connection
Dim Order As java#sql#Statement
Dim Data As ResultSet

'Load the JDBC-ODBC driver
Class.forName "sun.jdbc.odbc.JdbcOdbcDriver"

'Create connection to the database test
Set Con = java#sql#DriverManager.getConnection("jdbc:odbc:MyDB_Access")

'Create a statement and send the command to the database
Set Order = Con.createStatement
Set Data = Order.executeQuery("SELECT * FROM text;")

'Print the result
Do While Data.next()
java#lang#system.out.println(Data.getString("Name"))
Loop

'Close the connection
Con.close

But after compiling and try it in Windows 7,there is an error : CallByName 'getString' failed... (java.lang.Exception: CallByName 'getString' failed!) see screenshot attached

Could you, please, help me
Thanks

Hi Dani,
Thanks for your reply. Your bill don't work... I have re-install all JABACO, clean the registry for all entry. Now my app works fine.
I look for a lot of documentation and I regret that there are not more numerous examples...
But bravo to JABACO

I have test Real Studio but it is very hard to understand ...

Thanks