I just tested this with the letters in the path, and it worked..
It's strange that the Dabo folder has been created, but
DaboPreferences.db can't be created..
I remember having problems with "not able to open database" earlier, but
that was because of an old pysqlite and has not been a problem in a long
time.


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ed Leafe
Sent: 16. august 2007 14:22
To: Dabo Users list
Subject: Re: [dabo-users] Something not accepting extended ascii?SqlLite
perhaps?

On Aug 16, 2007, at 5:10 AM, Simen Haugen wrote:

> I have a problem with a computer that has extended ascii in the path
> name to the preferences. I cannot think there is any other problem, as
> it's working on a lot of different computers, and this is the only  
> one I
> know that doesn't have regular ascii in the path name.
>
> The Dabo catalog has been created, but no DaboPreferences.db has been
> created.
>
> Traceback (most recent call last):
>   File "dptools.py", line 353, in ?
>   File "dabo\dApp.pyo", line 166, in __init__
>   File "dabo\dObject.pyo", line 41, in __init__
>   File "dabo\dApp.pyo", line 467, in _initProperties
>   File "dabo\dObject.pyo", line 148, in _initProperties
>   File "dptools.py", line 84, in initProperties
>   File "dabo\dApp.pyo", line 742, in _setBasePrefKey
>   File "dabo\dObject.pyo", line 266, in _setBasePrefKey
>   File "dabo\dObject.pyo", line 340, in _getPreferenceManager
>   File "dabo\dPref.pyo", line 68, in __init__
>   File "dabo\db\dConnection.pyo", line 31, in __init__
>   File "dabo\db\dConnection.pyo", line 73, in _openConnection
>   File "dabo\db\dConnectInfo.pyo", line 98, in getConnection
>   File "dabo\db\dbSQLite.pyo", line 53, in getConnection
>   File "dabo\db\dbSQLite.pyo", line 46, in __init__
> pysqlite2.dbapi2.OperationalError: unable to open database file

        The part of dPref that is trying to connect looks like:

prefdir = utils.getUserAppDataDirectory(appName)
self._cxn = dabo.db.dConnection(connectInfo={"dbType": "SQLite",
                "database": os.path.join(prefdir,
"DaboPreferences.db")})

        So given the error, the problem could be one of two things:
SQLite  
can't handle a path with bytes > 127, or the user doesn't have the  
right to create the database file in that directory. I just tried  
creating a non-English named directory under OS X, and I was able to  
create an SQLite database in it through Dabo. So given that, and the  
fact that the error was not a typical "Unicode decode error" message,  
is it possible that it is a privileges issue?


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com




[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]

Reply via email to