Author: phd
Date: 2008-12-25 09:13:43 -0700 (Thu, 25 Dec 2008)
New Revision: 3752
Modified:
SQLObject/branches/0.9/docs/SQLObject.txt
Log:
Explain the problem with cross-platform Firebird DB URI string and how to work around the problem.
Modified: SQLObject/branches/0.9/docs/SQLObject.txt
===================================================================
--- SQLObject/branches/0.9/docs/SQLObject.txt 2008-12-25 15:57:42 UTC (rev 3751)
+++ SQLObject/branches/0.9/docs/SQLObject.txt 2008-12-25 16:13:43 UTC (rev 3752)
@@ -1740,6 +1740,29 @@
.. _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.
|
