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

Thanks for help, Peter.
The statement SET DEFAULT_USERNAME uname DEFAULT_PASSWORD pword works
fine.  
Jürgen
Peter Hearty wrote:
> 
> Juergen
> 
> I think the syntax should be:
> 
> SET DEFAULT_USERNAME uname DEFAULT_PASSWORD pword
> 
> If that still gives problems then try setting the properties:
> 
> tablename%username=value
> tablename$password=value
> 
> Regards
> 
> Pete
> 
> --
> 
> Peter Hearty                         peter.hearty@lutris.com
> Lutris Technologies (UK)        http://www.lutris.com
> ----- Original Message -----
> From: "Juergen Roeder" <juergen-roeder@t-online.de>
> To: <instantdb@enhydra.org>
> Sent: Friday, September 08, 2000 9:56 AM
> Subject: InstantDB: Import Data from JDBC Data Sources Problem
> 
> Dear Peter!
> I'm trying to import data from a Informix SQL Server table into InstantDB
> (3.20 beta 2) using the IMPORT-Statement shown on the InstantDB import.htm
> web site.
> Running the IMPORT-Statement brings up the error message under (A).
> If i try to set the deafult username and password, the error message under
> (B) comes up.
> What's going wrong?
> Thanks for help in advance! (juergen-roeder@t-online.de)
> Juergen Roeder
> 
> ============================================================================
> ===============================================
> (A)
> ============================================================================
> ===============================================
> Import.main() sql_drop_table = DROP TABLE stt
> Import.main() sql_import_from_file = IMPORT stt FROM 'stt.txt' USING
> 'stt_schema.txt' BUFFER 2048
> Import.main() sql_import_from_jdbc = IMPORT stt FROM URL
> 'jdbc:informix-sqli://192.168.168.3:1528/jdata:INFORMIXSERVER=dbs730_rm300'
> USING 'SELECT * FROM stt' BUFFER 2048
> Import.main() sql_select = SELECT * FROM stt
> Import.main() idbURL = jdbc:idb:d:\de\plus\base\properties\stt.prp
> Enhydra InstantDB - Version 3.20 beta 2
> The Initial Developer of the Original Code is Lutris Technologies Inc.
> Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
> Inc.
> All Rights Reserved.
> main DROP TABLE stt
> Import.main() sql_drop_table       rc = -1
> main IMPORT stt FROM URL
> 'jdbc:informix-sqli://192.168.168.3:1528/jdata:INFORMIXSERVER=dbs730_rm300'
> USING 'SELECT * FROM stt' BUFFER 2048
> main java.sql.SQLException: Incorrect password or user
> com.informix.asf.IfxASFRemoteException:  is not known on the database
> server.
> java.sql.SQLException: Incorrect password or user
> com.informix.asf.IfxASFRemoteException:  is not known on the database
> server.
>  at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
>  at org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java,
> Compiled Code)
>  at
> org.enhydra.instantdb.jdbc.idbStatement.executeUpdate(idbStatement.java:103)
> Database stt is shutting down...
> Database stt shutdown complete.
>  at Import.main(Import.java:134)
> ============================================================================
> ==================================
> (B)
> ============================================================================
> ================================================
> Import.main() sql_drop_table       = DROP TABLE stt
> Import.main() sql_import_from_file = IMPORT stt FROM 'stt.txt' USING
> 'stt_schema.txt' BUFFER 2048
> Import.main() sql_import_from_jdbc = IMPORT stt FROM URL
> 'jdbc:informix-sqli://192.168.168.3:1528/jdata:INFORMIXSERVER=dbs730_rm300'
> USING 'SELECT * FROM stt' BUFFER 2048
> Import.main() sql_select           = SELECT * FROM stt
> Import.main() idbURL               =
> jdbc:idb:d:\de\plus\base\properties\stt.prp
> Enhydra InstantDB - Version 3.20 beta 2
> The Initial Developer of the Original Code is Lutris Technologies Inc.
> Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
> Inc.
> All Rights Reserved.
> main SET DEFAULT_USERNAME ******
> Import.main() sql_set_default_username rc = -1
> main SET DEFAULT_PASSWORD *******
> main SET DEFAULT_PASSWORD *******
>  Don't understand SQL after: "SET"
>  Expected: "DATE" found: "DEFAULT_PASSWORD"
> java.sql.SQLException: SET DEFAULT_PASSWORD *******
>  Don't understand SQL after: "SET"
>  Expected: "DATE" found: "DEFAULT_PASSWORD"
>  at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:215)
>  at org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java,
> Compiled Code)
>  at
> org.enhydra.instantdb.jdbc.idbStatement.executeUpdate(idbStatement.java:103)
> Database stt is shutting down...
> Database stt shutdown complete.
>  at Import.main(Import.java:126)
> 
> -----------------------------------------------------------------------------
> 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.

-- 
Juergen Roeder
IT-Consultant
Stettinerstrasse 8
D-61348 Bad Homburg v.d.H.
Fon   +49 6172 969948
Fax   +49 6172 969913
Mobil +49 173 3162452
---------------------------------------
Natl. eMail: juergen-roeder@t-online.de
Intl. eMail: juergen_roeder@hotmail.com
---------------------------------------

begin:vcard 
n:Roeder;Juergen
tel;cell:+49 173 3162452
tel;fax:+49 6172 31864
tel;home:+49 6172 31864
tel;work:+49 69 9566 8623
x-mozilla-html:FALSE
adr:;;Stettinerstrasse 8;Bad Homburg v.d.H.;Hessen;61348;Germany
version:2.1
email;internet:juergen-roeder@t-online.de
title:IT-Consultant
fn:Juergen Roeder
end:vcard