"No SDBC driver found for the given URL" error

quinncollard · Newbie Joined: 14 Jun 2012 Posts: 2

So I have a database that was created in OpenOffice and edited just a few days ago with no problem. But now when I try to open the table in it I get this error:

"The connection to the data source [file name] could not be established. The connection to the external data source could not be established. No SDBC driver found for the given URL."

When I go to Edit -> Database the "Connection type" menu is greyed out and won't even let me select it. Any help? I've seen a few other threads of people having this error but haven't seen anything to solve it. Thanks.

Sliderule · Posted: Fri Jun 15, 2012 9:55 am Post subject:

quinncollard:

Do you know, which database back-end you are using?

Is it the OpenOffice default, where on the Status Bar, at the bottom, it would say:

Embedded database - HSQL database engine
Other database back-end, such as, MySQL, Access, H2, HSQL JDBC, PostGRE, SQLLite, other?

If, it was the first one above, or, you are not sure, I might be able to help, but, first I need to know the above answer, if you know. If you are not sure, we can assume your database back-end is the first one.

Sliderule

quinncollard · Newbie Joined: 14 Jun 2012 Posts: 2

Yes it says "Embedded database - HSQL database engine" at the bottom.

Sliderule · Posted: Fri Jun 15, 2012 10:31 am Post subject:

OK, I am sending you a PM ( Private Mail ).

Sliderule

Ewald · OOo Advocate Joined: 16 Dec 2005 Posts: 392

I had the same error message today, also using the HSQL database engine.
I am using standalone forms and try to open them from a switchboard. It used to work before.

So did the private mail help? If so, could I have one too?

Sliderule · Posted: Tue Jul 31, 2012 11:57 am Post subject:

Ewald:

I am sending you a PM ( Private Message ).

Sliderule

gyan · Newbie Joined: 31 Aug 2012 Posts: 2

Hi Sliderule

recently i am having the same error message " No SDBC driver was found for the given URL" on my windows 7 home premium. Please help me. using the HSQL database engine.

Sliderule · Posted: Sat Sep 01, 2012 11:01 am Post subject:

gyan:

I am sending you a PM ( Private Message).

Sliderule

gyan · Newbie Joined: 31 Aug 2012 Posts: 2

Hi Sliderule
Thanks for quick response. Soon after the post i realized about my backup copy, which i always save manually at the end of every day. My backup copy is working fine. So the original copy seems corrupted. i am moving on with the backup copy.
Thanks again for you help. Very Happy