Issue 74123 - Could not establish connection with data source
Summary: Could not establish connection with data source
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.4
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2007-02-02 12:35 UTC by coqkii
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Crashed database (1.03 MB, application/vnd.sun.xml.base)
2007-02-22 12:44 UTC, coqkii 		no flags Details
fixed bugdoc file (68.32 KB, application/vnd.sun.xml.base)
2007-02-22 13:24 UTC, marc.neumann 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description coqkii 2007-02-02 12:35:57 UTC 
Hi all,

I got a little fatal error running the small database I am implementing for my
company.
It consists only of five different tables with their relationships. 
After working hard to design the base, I started using it and writing data into
the tables. 

But I can not do that anymore and it looks like I neither can gain access to the
data. 
I describe the errors:

When opening the document I get the message:

     GENERAL ERROR

Once in, it comes up that all the forms, queries and reports have disappeared.

Further more, when I click the button TABLES I get summary message:

      COULD NOT ESTABLISH CONNECTION WITH DATA SOURCE

Clicking OPTIONS it says:

      SQL STATE: HY000
         COULD NOT ESTABLISH CONNECTION WITH THE EXTERNAL DATA SOURCE. UNKOWN
ERROR. IT IS POSSIBLE THAT THE DRIVERS ARE DEFECTIVE.

      A CONNECTION FOR THE FOLLOWING URL WAS REQUESTED: JDBC

Does anyone have any tips to solve this problem? Can I get back my data?

Thanks and good day,

Oscar.

----

ATLANTIS (WATER MANAGEMENT FOR LIFE)
www.atlantiscorp.com.au
Comment 1 marc.neumann 2007-02-22 09:50:45 UTC 
Hi,

can you please add the defect database file to this issue.
So we can look into the problem.

Bye Marc
Comment 2 coqkii 2007-02-22 12:44:03 UTC 
Created attachment 43267 [details]
Crashed database
Comment 3 coqkii 2007-02-22 12:46:08 UTC 
Hi Marc,

thanks for your message.

I have attached the base file.

Bye, 
Oscar.
Comment 4 marc.neumann 2007-02-22 13:22:34 UTC 
Hi Oscar,

As far as I can see this file itself is broken. I can't uncompress it with the
unzip command. 
However with 7zip I could uncompress the file and pack it again. Then it works
also in OOo.
I have attached the fixed file to this issue.

Can you have a look at the fixed file?

Can we then close this issue ?

Bye Marc
Comment 5 marc.neumann 2007-02-22 13:24:08 UTC 
Created attachment 43270 [details]
fixed bugdoc file
Comment 6 coqkii 2007-02-22 16:29:25 UTC 
Hi again Marc,

Thanks a lot for your help! It seems to work properly now. 
I would also appreciate if you could briefly explain me why did you have to
uncompress it and then pack it again, how do you pack it? And which was the
source of the error? May it happen again, could I solve it in the same manner?

I proceed then to close the issue. 

Thank you one more time.

yours,
Oscar.
Comment 7 marc.neumann 2007-02-23 08:11:15 UTC 
Hi Oscar,

> why did you have to uncompress it and then pack it again, how do you pack it?

The odb file as any other OOo document file is a zip packed file. You can unpack
it with every zip unpacker. I unpack the file because with the unpack files I
can try to restore the data.

> And which was the source of the error?
I don't know. This would be the interesting part, if you can remember when and
how this error occur.

> May it happen again, could I solve it in the same manner?
Yes. If you unpack the file you have some directories. The database dir contains
the pure table data. The others contains the form, report, etc.

Bye Marc
Comment 8 christoph.lukasiak 2007-04-03 11:07:59 UTC 
close issue