Issue 58220 - General error on opening existing spreadsheet file as database
Summary: General error on opening existing spreadsheet file as database
Status: CLOSED DUPLICATE of issue 59784
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
Keywords: oooqa
Depends on:
Reported: 2005-11-21 08:58 UTC by tuharsky
Modified: 2013-08-07 15:45 UTC (History)
3 users (show)

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

simpe spreadsheet (5.71 KB, application/vnd.sun.xml.calc)
2005-11-21 08:59 UTC, tuharsky
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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

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

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
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

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