Hi all, Im 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 Im 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]