Firebird embedded and JBuilderx java applicatiomn

I am very close to getting Firebird embedded working with JBuilder
the DataModule wizard can see data
the setconnection throws no exceptions
But when I try to open a table in my program it throws a
com.borland.dx.dataset.DataSetException


If I try this:

durl = "jdbc:firebirdsql:embedded:c:\\a\\emFirebird\\T21";
dDriver = "org.firebirdsql.jdbc.FBDriver";


try {
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor( durl,
dUname, dpass, false, dDriver));

I get NO exceptions on the setConnection
[why?]
but when I try to open a QueryDataSet
I get this:
=============================================
See com.borland.dx.dataset.DataSetException error code: BASE+66

com.borland.dx.dataset.DataSetException: Resource Exception. I/O error for file CreateFile
(open) ""
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) ""
Error while trying to open file
null

at com.borland.dx.dataset.DataSetException.a(Unknown Source)

at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)

at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)

erc etc
at java.awt.Container.addImpl(Container.java:658)

at java.awt.Container.add(Container.java:518)

at t21.Frame1.jbInit(Frame1.java:1043)

at t21.Frame1.<init>(Frame1.java:265)

at t21.Application1.<init>(Application1.java:72)

at t21.Application1.main(Application1.java:194)

Chained exception:

org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error for file CreateFile
(open) ""
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) ""
Error while trying to open file
null

at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:112)

at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

...
etc etc
=============================================

Note: I am NOT trying to open a "file" I am trying to open a QueryDataSet

=============================================
=============================================
If I try durl = "jdbc:firebirdsql:C:\\a\\emFirebird\\T21";
[ie omit the "embedded"]
I get this:
======================================================
com.borland.dx.dataset.DataSetException: Resource Exception. Unable to complete network
request to host "C".
Reason: Unable to complete network request to host "C".
=============================================
=============================================

If I change the url to a location which does NOT contain T21.fdb (my database)
I get:
================================================
com.borland.dx.dataset.DataSetException: Resource Exception. I/O error for file CreateFile
(open) ""
Error while trying to open file
null
==========================================
Why does setconnection throw no exception when teh url points to a non-existant directory?

cheers
C T Skinner

ps could Firebird please host a proper newsgroup?
Lists via email seems so 1980's


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com