Issue 58220

Summary: General error on opening existing spreadsheet file as database
Product: Base Reporter: tuharsky <tuharsky>
Component: codeAssignee: Frank Schönheit <frank.schoenheit>
Status: CLOSED DUPLICATE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P4 CC: issues, josef.latt, lars_o_hansen
Version: OOo 2.0Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
simpe spreadsheet none

Description tuharsky 2005-11-21 08:58:50 UTC 
Create some database file, for example Spreadsheet file.
Now go New - Database (or start sbase), choose Open Existing, click on Open...
button to browse filesystem, and select the file.

General error.

The database program opens, of course complains for non-existent connection to
db source. If You click on More, You can look at error log and we read

"SQL Status: S1000

The connection to the external data source could not be established. An unknown
error occurred. The driver is probably defective."

Since this causes crash in basic functionality, I give it P2.
Comment 1 tuharsky 2005-11-21 08:59:29 UTC 
Created attachment 31657 [details]
simpe spreadsheet
Comment 2 tuharsky 2005-11-21 09:00:50 UTC 
My colegue feels that this bug was introduced lately in 2.0 developement -he
feels like some beta version hasn't had such problem. Although I repeated this
error on m130 and m128.
Comment 3 lars 2005-11-21 18:46:13 UTC 
Confirmed on Windows XP SP2 with OOo 2.0.0:

start sbase, choose Open Existing, click on Open..., browse filesystem and 
select the file attached: General error occurs on loading
Comment 4 marc.neumann 2005-11-22 13:16:23 UTC 
hi,

this is because the sxc file is no database, it's a spreadsheet. Spreadsheet
files can't be open as a database.

close as INVALID.

Bye Marc
Comment 5 marc.neumann 2005-11-22 13:17:57 UTC 
P.S.: May be you want to write am enhancement, to open all kinds of document
with the database wizard.
Comment 6 tuharsky 2005-11-23 07:43:21 UTC 
The program shouldn't end up with "General error".

If the spreadsheet is not supported, program should

1, state it clearly ("Not a valid DATABASE file" or so)
2, or even don't allow opening the spreadsheet file type either.

"General error" means nothing but plain scare for ordinary user. He dosen't
know, what's wrong and feels like "program generally dosen't function".
Comment 7 tuharsky 2005-11-23 07:55:30 UTC 
Mark, I have reported the enhancement (Issue 58324) as You suggested.

Please implement the correct warning message until the support was added.

Bye, Peter
Comment 8 jolatt 2005-11-23 16:12:31 UTC 
Hi,

the described defect doesn't occur, if you choose 'connection to a existing 
database' instead of 'open a existing database'. You must then select the type 
in the dropdownlist.

Selecting 'open a existing database' affects IMO only OOo-Database.
Comment 9 marc.neumann 2005-11-24 08:26:49 UTC 
msc -> fs: Please add a warning about the invalid file type.
Comment 10 Frank Schönheit 2005-11-24 09:11:03 UTC 
accepting
Comment 11 ocke.janssen 2009-03-20 13:43:53 UTC 
When now opening a file which isn't a db file. The same happen if you choose
File->Open

*** This issue has been marked as a duplicate of 59784 ***
Comment 12 ocke.janssen 2009-03-20 13:44:21 UTC 
Closing issue.