Issue 126717 - connection to data source" vakantiepret" could not be established,error in script file.....
Summary: connection to data source" vakantiepret" could not be established,error in sc...
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.1.1
Hardware: All Windows 10
: P5 (lowest) Blocker (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-12-01 21:30 UTC by Hugo Verhulst
Modified: 2017-05-20 09:36 UTC (History)
2 users (show)

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


Attachments
error discription (23.86 KB, image/jpeg)
2015-12-01 21:30 UTC, Hugo Verhulst
no flags Details
this heppens wen I select the table icon. (61.33 KB, image/png)
2015-12-03 11:16 UTC, Hugo Verhulst
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Hugo Verhulst 2015-12-01 21:30:16 UTC
Created attachment 85189 [details]
error discription

if i try to open a table,form, report or query from my dbase i get next maessage:

The connection to the data source"testvakantie"could not be established.

error in script file line:13 Unexpected token),requires AS in statement [CREATE VIEW"finaal2015"(SUM(SYSTEM_SUBQUERY,"wloon"))]


How do i solve this problem? I have no backupfile. 
How do i edit the scriptfile?
The data is important for me.
Comment 1 oooforum (fr) 2015-12-02 09:41:56 UTC
Your bug report is being closed as NOT_AN_ISSUE due to a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided):

a) Provide details of your system including your operating system and the latest version of AOO that you have confirmed the bug to be present

b) Provide a step-by-step procedure to reproduce (the simpler will be the better)

c) Provide any test case(s) which will help us confirm the problem (like a sample document)

d) Provide screenshots of the problem if you think it might help

Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue.
Comment 2 Hugo Verhulst 2015-12-03 00:02:48 UTC
2 SYSTEMS

A)Asus X73S- Intelcore i7-2630QM-2,0GHz--Memory 8 GB--HDD 500GB+500GB
WIN 10 home 		Apache OpenOffice 4.1.1

B)Dell Inspiron 530S-Intelcore2 DUO CPU-2.33GHz--Memory 2 GB--HDD300GB
WIN 10 home 		Apache OpenOffice 4.1.2

Notice: The program has bin working in the past for several years en with several oo versions.

latest step-by-step procedure before crashing:

open the database: OK
select query: OK
copy query: OK
past query(and rename): OK
edit renamed  query :OK
create view from query: seems OK
select "tables" label (attempt to see the view) CRASH
error look at attachment 85189 [details]

step-by-step procedure now:
open the database: OK
selecting  labels "query", "form", "report" : OK
select label  "tables": CRASH
select named query,form or report: OK
open named query,form or report: CRASH
edit named query,form or report: CRASH
Comment 3 oooforum (fr) 2015-12-03 08:49:54 UTC
(In reply to oooforum from comment #1)
> c) Provide any test case(s) which will help us confirm the problem (like a
> sample document)
Where is this ODB?
Comment 4 Hugo Verhulst 2015-12-03 11:16:49 UTC
Created attachment 85190 [details]
this heppens wen I select the table icon.
Comment 5 Hugo Verhulst 2015-12-03 11:29:28 UTC
This ODB is stored on a USB stick 1 GB.(providing a save backup medium.)
In the past it worked accurate.
The USB stick is plugged in on the Dell PC.
On the ASSUS portable I work over the home network.
Comment 6 oooforum (fr) 2015-12-03 13:31:44 UTC
How do you think we can reproduce your problem without your ODB?
Comment 7 Hugo Verhulst 2015-12-03 14:36:10 UTC
Is it possible to block my odb for the forum?
There is a lot of private information on it.
Comment 8 oooforum (fr) 2015-12-03 16:29:15 UTC
(In reply to Hugo Verhulst from comment #7)
> Is it possible to block my odb for the forum?
> There is a lot of private information on it.
No, Bugzilla is public.


(In reply to Hugo Verhulst from comment #5)
> This ODB is stored on a USB stick 1 GB.
Do not work direct to USB stick but only on the computer hard drive and transfer the completed file when finished, and observe the correct USB removal protocols.
Read this:
https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=47464

Frequently such corruption is caused by this media.
For me, this is not an AOO issue but hardware or end-user bad handling.
Comment 9 Hugo Verhulst 2015-12-03 21:45:24 UTC
I think I have to accept I've lost my data.
Thank you for your cooperation.
Comment 10 mroe 2015-12-04 06:08:24 UTC
(In reply to Hugo Verhulst from comment #9)
> I think I have to accept I've lost my data.
> Thank you for your cooperati

Copy your file to at a harddisk. Rename the copied file to <filename>.odb.zip.
Open this zip-file with an archive manager; Windows should can open it directly.
If you can open it, the file itself seems OK. But maybe you can extract and save your data from it.