|
Hi guys,
I'm having trouble importing data from Access or
SQLServer.
It says the SQL statement is wrong.
The code is:
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =
DriverManager.getConnection("jdbc:odbc:SandeeppSm30");
Statement stmt = con.createStatement();
Class.forName
("org.enhydra.instantdb.jdbc.idbDriver");
Connection con2 =
DriverManager.getConnection("jdbc:idb:sample.prp");
Statement stmt2 =
con2.createStatement();
// stmt2.execute("IMPORT jproduct
FROM 'jdbc:odbc:SandeeppSm30' USING 'SELECT * FROM jproduct' BUFFER
2048");
stmt.execute("IMPORT
jproduct FROM 'jdbc:odbc:SandeeppSm30'");
I tried both of the last statements.
Both don't work for me :-0.
Could someone please tell me what I'm doing
wrong?
cheers,
Kam.
| 
