Joined: 17 Jul 2007
|Posted: Wed Jul 18, 2007 10:17 am Post subject: getConnection problem
|I'm new to this and inevitably have run straight into a problem.
I've created a database and defined a table but as yet the table is empty.
I'm planning on writing a macro to populate this table but I keep getting an error from the getConnection.
the code is
sDBURL = "file:///C:\Documents and Settings\Russ\My Documents\New Database.odb"
oBaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oDB = oBaseContext.getByName(sDBURL)
oCon = oDB.getConnection("", "")
The getConnection gives the following error
BASIC runtime error.
An exception occurred
Message: No storage property was set..
I didn't see anything in the instructions about that.
Anyone any ideas?