This project is read-only.

How to connect to an existing database

Aug 18, 2008 at 10:13 AM
first of all thank you for your excellent work !

I want to connect to an existing database and mody it with my C# application. I can connect to the database, but I can't access the tables. Each time I try a SELECT command it returns me the S0002 : Table not found. I'm sure that the table exists. I tried to execute the "SHOW TABLES" command but the Result object contains only one element "TABLE" in its Names collection.

Can anybody help me ?
Nov 26, 2008 at 4:57 PM
By default newly created tables are persisted to disk only when a CHECKPOINT operation occurs.
if you are using the low level SharpHSql classes (Database) make sure you execute a CHECKPOINT command before your application finish.
I'm running the "ProviderTest" project and everything seems to be working as expected.
Let me know if you have any other problem.
Nov 26, 2008 at 5:12 PM
Hello andresv,
thank you for your answer. In fact the database was not created by SharpHSQL, it was created by an application written in Java. I think this the reason because SharpHSQL can not open the database.

I found a workaround by using a commercial JDBC-ODBC Bridge.

But let me know if you think that SharpHSQL is able to open a database created with another application.