FirebirdSQL/1/3

=== 連線指令: ===
# localhost：路徑名 + 資料庫名稱d:\data\test.gdb
# TCP: 伺服器名稱:路徑ServerName:d:\data\test.gdbLinuxServer:/usr/data/test.gdb
# NetBEUI: \\伺服器名稱\路徑\\ServerName\d:\data\test.gdb
# SPX: 伺服器名稱@路徑ServerName@FilePath 
註:也可以使用 伺服器名稱:資料庫名稱,但是要在 aliases.conf 中作設定.

=== 示範連線: ===
#Open("DSN=mcsAddress;")
#Open("DSN=mcsAddress;UID=MCSSITE;PWD=mcssite;")
#Open("DSN=mcsAddress;UID=MCSSITE;PWD=mcssite;DBNAME=172.17.2.10:/usr/local/efldata/mcsAddress.fdb;")
#Open("DRIVER=Firebird/InterBase(r) driver;DBNAME=172.17.2.10:/usr/local/efldata/mcsAddress.fdb;")
#Open("DRIVER=Firebird/InterBase(r) driver;UID=MCSSITE;PWD=mcssite;DBNAME=172.17.2.10:/usr/local/efldata/mcsAddress.fdb;")
#Open("DRIVER={Firebird/InterBase(r)driver};UID=SYSDBA;PWD=masterkey;DBNAME=doru/3050:myDB;ROLE=;DIALECT=3;")

Is allowed to use ISC_PASSWORD and ISC_USER from environment (autoexec.bat Win32)

where :
*doru is the name of the server
*myDB is the alias name of "someDB" in [alias.conf] file

in VFP:
<pre>
h = SQLSTRINGCONNECT("DRIVER={Firebird/InterBase(r) 
driver};UID=SYSDBA;PWD=masterkey;DBNAME=doru/3050:myDB;")
</pre>

=== Firebird-odbc-devel:  ===
*http://www.firebirdsql.org/index.php?op=lists#fb-odbc-devel