OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Strange error: "User not found"

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
FrankVdb
General User
General User


Joined: 16 Sep 2006
Posts: 9

PostPosted: Tue Sep 19, 2006 11:21 am    Post subject: Strange error: "User not found" Reply with quote

When creating a new database in Base through the wizard, I get a strange error when opening the db and trying to create tables. It says "User not found".

In my target directory four files are created with the extensions
.odb
.script
.properties, and
.data
so I assume everything is in place.

Could this error somehow be linked to the hsqldb database engine? I guess this engine is installed automatically with OpenOffice? If so, where? I cannot find it under Program Files/OpenOffice org 2.0.

Sorry for my rookie questions but I'm just discovering OpenOffice and I'm trying to make it work for making invoices...

Thank you in advance for any input, I'm stuck.

Kind regards from Belgium,
Frank
Back to top
View user's profile Send private message
bvdbos
OOo Enthusiast
OOo Enthusiast


Joined: 23 Nov 2003
Posts: 153
Location: Asten Netherlands

PostPosted: Tue Sep 19, 2006 11:38 am    Post subject: Reply with quote

These files shouldn't be in a directory but zipped inside an odb-file. Looks like you unzipped the odt to seperate files and directorys.
_________________
gr

Bas
Back to top
View user's profile Send private message Visit poster's website
FrankVdb
General User
General User


Joined: 16 Sep 2006
Posts: 9

PostPosted: Tue Sep 19, 2006 11:48 am    Post subject: Reply with quote

Actually, I did'nt zip anything. OO created those files in the directory I specified through the wizard...
Back to top
View user's profile Send private message
sawtooth
Newbie
Newbie


Joined: 17 Sep 2006
Posts: 3

PostPosted: Tue Sep 19, 2006 12:30 pm    Post subject: Reply with quote

What bvdbos is trying to say is that the directories listed should be inside of an ".ODB" file which is actually just a ZIP file containing that stuff. Could you let us know exactly which version of OO.o you're using and maybe the steps you're taking to see if others can repeat it?
Back to top
View user's profile Send private message
FrankVdb
General User
General User


Joined: 16 Sep 2006
Posts: 9

PostPosted: Wed Sep 20, 2006 9:19 am    Post subject: Reply with quote

- through Quickstarter: open database
- create new database
- yes, register database for me
- ticked: open database for editing & create tables

As soon as I click on "Finish", Base opens with the error 'Could not connect to database'. After that, when clicking on "Tables", I get the same error with the additional statement "User not found:". Nothing is mentioned after the colon.

In the directory that is supposed to contain one db file, I find four files (with the extensions mentioned in my original post).

Thanks.
Back to top
View user's profile Send private message
bvdbos
OOo Enthusiast
OOo Enthusiast


Joined: 23 Nov 2003
Posts: 153
Location: Asten Netherlands

PostPosted: Wed Sep 20, 2006 9:27 am    Post subject: Reply with quote

can you put all files in a zip and rename this to an odb? Wondering if the files and directory's in itself are ok...
_________________
gr

Bas
Back to top
View user's profile Send private message Visit poster's website
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Wed Sep 20, 2006 9:36 am    Post subject: Reply with quote

This sounds like an error that someone brought to the Users_AT_dba.openoffice.org mailing list. As I recall the problem eneded up being mutliple hsqldb.jar files...I think.

You might want to go to the main OOo web site, go to the dbaccess project page and then mailing list. Do a search in the users mailing list. I belive you will find the answer there.

Drew
Back to top
View user's profile Send private message Send e-mail Visit poster's website
FrankVdb
General User
General User


Joined: 16 Sep 2006
Posts: 9

PostPosted: Wed Sep 20, 2006 10:44 am    Post subject: Reply with quote

bvdbos wrote:
can you put all files in a zip and rename this to an odb? Wondering if the files and directory's in itself are ok...


I tried your suggestion but when opening the .odb file, I get the error
"The connection to the data source "kantoor" cannot be established.
The connection to the external data source could not be established. An unknown error occurred. The driver is probably defective."
Back to top
View user's profile Send private message
FrankVdb
General User
General User


Joined: 16 Sep 2006
Posts: 9

PostPosted: Wed Sep 20, 2006 11:08 am    Post subject: Reply with quote

DrewJensen wrote:
This sounds like an error that someone brought to the Users_AT_dba.openoffice.org mailing list. As I recall the problem eneded up being mutliple hsqldb.jar files...I think. You might want to go to the main OOo web site, go to the dbaccess project page and then mailing list. Do a search in the users mailing list. I belive you will find the answer there.
Drew


Yes, I found that too while googling around.
The suggestion seems to be to remove "the oldest hsqldb.jar" file. I found the hsqldb directory in C:\Program Files\Java\jre1.5.0\classes\org\hsqldb. Can't see any duplicates though...
I downloaded the newest hsqldb version (1.8.0) from sourceforge.
Could my Java installation be outdated?
Btw, on the troubled PC I'm running WinXP with OO 2.0.
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Wed Sep 20, 2006 11:49 am    Post subject: Reply with quote

hmm..well, OOo uses, or should use the hsqldb.jar file located in

<OOoInstallDirectory>\program\classes

So, on my XP box this is at
c:\Program Files\OpenOffice.og 2.0\program\classes\hsqldb.jar

I think you need to be sure that this file is the one being used and the not the one in the JRE installation directory.

As for using the latest one from the HSQLDB site, I have done this and have had no real problem with it. I just copied the jar file into the OOo location after renaming the one from the OOo distro.

HTH

Drew
Back to top
View user's profile Send private message Send e-mail Visit poster's website
FrankVdb
General User
General User


Joined: 16 Sep 2006
Posts: 9

PostPosted: Sat Sep 23, 2006 12:43 pm    Post subject: Reply with quote

The file hsqldb.jar is in the OO directory you mention so I'm wondering what is going wrong...

Anyway, I found out that it's easier to combine Writer and Calc for making an invoicing system. Also, I have a workstation still running W2K and it's running Base without any apparent problem. If I need Base, I'll use that machine.

Thanks guys for your help, really appreciate it.
Back to top
View user's profile Send private message
metteke
Newbie
Newbie


Joined: 21 Mar 2011
Posts: 1

PostPosted: Mon Mar 21, 2011 3:00 am    Post subject: Reply with quote

Same here with new 3.3 install on OSX (latest updates on Java and OSX).

Also in Belgium, incredible.
Not much info around about this problem.
I will check the Java-stuff this evening, but Mac OSX is diffrent I think.

Anything else I should check? Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group