Thread: [SQL-CVS] r3754 - SQLObject/trunk/docs
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: <sub...@co...> - 2008-12-25 16:17:44
|
Author: phd Date: 2008-12-25 09:17:41 -0700 (Thu, 25 Dec 2008) New Revision: 3754 Modified: SQLObject/trunk/docs/SQLObject.txt Log: Merged revisions 3751:3752 from 0.9 branch: Fixed a heading. Explain the problem with cross-platform Firebird DB URI string and how to work around the problem. Modified: SQLObject/trunk/docs/SQLObject.txt =================================================================== --- SQLObject/trunk/docs/SQLObject.txt 2008-12-25 16:16:59 UTC (rev 3753) +++ SQLObject/trunk/docs/SQLObject.txt 2008-12-25 16:17:41 UTC (rev 3754) @@ -1763,14 +1763,37 @@ .. _kinterbasdb: http://kinterbasdb.sourceforge.net/ +There could be a problem if one tries to connect to a server running on w32 +from a program running on Unix; the problem is how to specify the database +so that SQLObject correctly parses it. Vertical bar is replaces by +a semicolon only on a w32. On Unix a vertical bar is a pretty normal +character and must not be processed. + +The most correct way to fix the problem is to connect to the DB using +a database name, not a file name. In the Firebird a DBA can set an alias +instead of database name in the aliases.conf file + +Example from `Firebird 2.0 Administrators Manual`_:: + + # fbdb1 is on a Windows server: + fbdb1 = c:\Firebird\sample\Employee.fdb + +.. _`Firebird 2.0 Administrators Manual`: http://www.janus-software.com/fbmanual/manual.php?book=admin&topic=4 + +Now a program can connect to firebird://host:port/fbdb1. + +One can edit aliases.conf whilst the server is running. There is no need to +stop and restart the server in order for new aliases.conf entries to be +recognised. + If you are using indexes and get an error like *key size exceeds implementation restriction for index*, see `this page`_ to understand the restrictions on your indexing. .. _this page: http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm -SybaseConnection ----------------- +Sybase +------ `SybaseConnection` takes the arguments `host`, `db`, `user`, and `password`. It also takes the extra boolean argument `locking` (default |