InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Kam

Do you have the exact error message that this produces:

IMPORT jproduct FROM 'jdbc:odbc:SandeeppSm30'
USING 'SELECT * FROM jproduct' BUFFER 2048

By the way, you don't need to open a Connection to SandeeppSm30. InstantDB
will do this during the import.

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "kam shan" <kamshan@hotmail.com>
To: <instantdb@enhydra.org>
Sent: Thursday, October 26, 2000 9:55 AM
Subject: InstantDB: Import from JDBC/ODBC source, problem!


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.


-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.