DatabaseLink behaviour change in 6.0
- To: mathgroup at smc.vnet.net
- Subject: [mg81312] DatabaseLink behaviour change in 6.0
- From: Yves Klett <yves.klett at googlemail.com>
- Date: Wed, 19 Sep 2007 05:21:51 -0400 (EDT)
Dear group, I have some databaselink code (together with an ms access db)that worked fine in 5.2, but does not in 6.0.0 Connecting works as previously: conn = OpenSQLConnection[JDBC["odbc", "FW_Test"]] Other jdbc connection types like "Microsoft Access(ODBC)" result in errors like: JDBC::error: [Microsoft][ODBC Microsoft Access Driver]Allgemeiner Fehler Registrierungsschlüssel 'Temporary (volatile) Jet DSN for process 0x1118 Thread 0x1614 DBC 0x172135a4 Jet' kann nicht geöffnet werden. >> I get a connection as before, but the SQL queries will not accept Integer or Real arguments as before. In 5.2, the following query worked: SQLSelect[conn, "tbl_gdata", SQLColumn["Geo_ID"] < 186] Now, in 6.0, I get JDBC::error: ""[Microsoft][ODBC Microsoft Access Driver]Optionales Feature wurde nicht implementiert" (in English something like: "Optional feature not implemented", my environment is German) The following query with a string as argument works: SQLSelect[conn, "tbl_gdata", SQLColumn["Geo_ID"] < "186"] The same occurs wit SQLInsert. In 5.2, I can SQLInsert different types of arguments into my .mdb, while in 6.0 only strings are accepted. Curiously, reading *from* the db works just fine, with numbers, strings etc., only writing works only with string. I noticed that the java environment in 6.0 changed from 1.4 to 2.0, so perhaps there is some catch there. This of course is not a desirable state of affairs (because I just switched all the infrastructure to 6.0 and would prefer not to have to go back there), so I hope some of you in the know will be able to help me. Any input is appreciated. Regards, Yves