Zur Navigation | Zum Inhalt
Version 6.3 Released
See the changelog for details of this new release.
FVCML0208 10
Welcome, Guest
Please Login or Register.    Lost Password?

Problems accesing database
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Problems accesing database
#5
Problems accesing database 3 Months, 1 Week ago Karma: 0
Hello.
I've installed the program, but i can't register it to lite mode.
It shows me the message "SQLSTATE[HY000][14] unable to open database file".

My system is Win XP SP2 (Spanish).

It tries to open the database on

DSN:sqlite:C:/Documents and Settings/xxxxx/Datos de programa/RocketDMS/rocketDMS_license.db

The file is there, but the program seems having problems opening it.

Thanks.
Fieda
Fresh Boarder
Posts: 4
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6
Re:Problems accesing database 3 Months, 1 Week ago Karma: 0
Hi , Thanks for the query.

You can contact me mike@rocketdms.co.nz or skype id magpie5005 as well. Use the communication method that is easiest for you.

I am assuming that you have downloaded and installed the latest version.

Two things we can do to start with.

1. Please send me the debug info by doing this:

Start->Programs->Pikaia->rocketDMS->Support->Email Trace to Support

2. This database file should be under your personal user profile on Windows. Here is how RocketDMS decides where files should be:

RocketDMS uses the windows registry to locate your local profile and my documents location as per the Microsoft documentation:

support.microsoft.com/kb/310746

"The path to the My Documents folder is stored in the following registry key, where path is the complete path to your storage location:HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders"


This registry entry may, in turn, include a reference to the environment variable %USERPROFILE%.

There are no assumptions or paths hard-coded in RocketDMS. It is, in fact, written to be cross-platform and hardcoding paths like 'C:\Documents and Settings....' is going to be very broken when running on OSX and Linux. When running on MS Windows we use the techniques as published by Microsoft to locate the 'My Documents' folder.

Please stay in touch and we WILL get you going.

Regards
Mike
http://claimid.com/pikaia
Admin
Posts: 4
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#7
Re:Problems accesing database 2 Months, 2 Weeks ago Karma: 0
Hi,

Thanks for the information that you emailed to me.

One of 2 things is happening. Either the RocketDMS program is unable to 'find' the AppData folder from the registry or the program is unable to create or write files there.

Can you please have a look at theses two things:

1. Make absolutely certain that you have the registry entries as outlined here: http://support.microsoft.com/kb/310746

2. Ensure that your user account can write to the folder :
C:/Documents and Settings/fantasy/Datos de programa/RocketDMS/

Please let me know how you get on.

Thanks
Mike
http://claimid.com/pikaia
Admin
Posts: 4
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#8
Re:Problems accesing database 2 Months, 1 Week ago Karma: 0
Hello.
I've tried it also with "Administrator" account, and even wrote a little file to

C:\Documents and Settings\fantasy\Datos de programa\RocketDMS\

It works OK. Well, the slashes are back-slashes, but i think it's OK to use "/" instead of "\" in PHP to access Windows folders.

I've checked the microsoft support link, and my system seems to be right.
I've gone to command line, and "echoed" some values, only to double-check those values.

APPDATA : C:\Documents and Settings\fantasy\Datos de programa
USERPROFILE: C:\Documents and Settings\fantasy
HOMEPATH: \Documents and Settings\fantasy

I've also tries on another computer, and the only change is the username (of course).

Thanks!.
Fieda
Fresh Boarder
Posts: 4
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#9
Re:Problems accesing database 2 Months ago Karma: 0
Hi,

We have had a long look into this but having no Spanish XP systems to look at directly it is difficult.

We can only make an educated guess at what the issue may be on your systems but it may be something to do with foreign language characters in the path names.

With this in mind we have compiled a version that uses the windows SFN (short file names) exclusively. Can I ask you to download this and let me know the result.

pikaia.co.nz/downloads/rocketDMS-setup-6-2-54.exe

Regards
Mike
http://claimid.com/pikaia
Admin
Posts: 4
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#10
Re:Problems accesing database 1 Month, 4 Weeks ago Karma: 0
Hello.
Same problem with this version. I will test it in another computer.

I've trace the disk access and i've see something strange.
The process rdms_config tries to find a file called
"c:\documents and settings\xxx\Configuración local\temp\config.ipc".
It doesn't exists, so tries to create, but in

"c:\documents and settings\xxx\Configuracin local\temp\config.ipc".

Note the "Configurain" instead "Configuración".

Others accesses to that folder to "CreateFile" are good.
Don't know if this helps.

Thanks.
Fieda
Fresh Boarder
Posts: 4
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12