Torque and MS Access via odbc

["bca72@bca72.it" <bc...@bca72.it>]

Hi all, I’m having troubles using torque to connect to a
MS Access database via jdbcodbc driver. I managed to create
the java classes for this db, using the command 
    ant –f build-access.xml
The problems arise qhen I use either
    ant –f build-access.xml create-db
or 
    ant –f build-access.xml insert-sql

Looks like I’m not writing properly the properties file
but I really tried all I could think of!!!!!
I set up the odbc data source in control panel so that the
database SAIAUTF (on localhost) is defined.

With this configuration 
torque.database.createUrl = jdbc:odbc:
torque.database.buildUrl = jdbc:odbc:
torque.database.url = jdbc:odbc:SAIAUTF
torque.database.driver = sun.jdbc.odbc.JdbcOdbcDriver
or this 
torque.database.createUrl = jdbc:odbc:/127.0.0.1
torque.database.buildUrl = jdbc:odbc:/127.0.0.1
torque.database.url = jdbc:odbc:/127.0.0.1/SAIAUTF
torque.database.driver = sun.jdbc.odbc.JdbcOdbcDriver

I get this message
insert-sql:
[torque-sql-exec] Our new url -> jdbc:odbc:
BUILD FAILED
C:\Software\torque-gen-3.2\build-AP5SAIA-Access-torque.xml:328:
java.sql.SQLException: [Microsoft][Driver Manager ODBC] Nome
origine dati non trovato e driver predefinito non
specificato. (that means data source name not found and
predefined driver not specified.... or something similar :P
)



With this configuration 
torque.database.createUrl = jdbc:odbc
torque.database.buildUrl = jdbc:odbc
torque.database.url = jdbc:odbc:SAIAUTF
torque.database.driver = sun.jdbc.odbc.JdbcOdbcDriver

I get this message
insert-sql:
[torque-sql-exec] Our new url -> jdbc:odbc
BUILD FAILED
C:\Software\torque-gen-3.2\build-AP5SAIA-Access-torque.xml:328:
java.sql.SQLException: No suitable Driver for jdbc:odbc

Please, I really need help on this.

Bye, Enrico.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org