windows版本
安装后:
管理者预设:名称:sysdba,密码:masterkey
firebird.conf
tcp/ip设置
RemoteServiceName = gds_db
RemoteServicePort = 3050
联机别名的方式:aliases.conf
Server_name:aliasname
BIN目录命令集
c:/../gsec -user sysdba -password masterkey
修改密码(长度8位): modify sysdba -pw ********
添加使用者:add user1 -pw ******
删除用户 delete user1
进入SQL控制台:isql -user sysdba -password masterkey
PHP连接 firebird
firebird php新闻组: http://tech.groups.yahoo.com/group/firebird-php/
gds32.dll(firebird server) copy to c:/windows/system32
php.ini
extension=php_pdo.dll
extension=php_interbase.dll
$strconnect
=
'
H:/bin/firebird/test.fdb
'
;
if ( ! ( $link = ibase_connect( $strconnect , ' sysdba ' , ' pass0000 ' , ' ISO8859_1 ' , 0 , 1 )))
die ( ' Could not connect: ' . ibase_errmsg());
$query = ibase_prepare( $link , ' insert into data (id) values (?) ' );
$newid = 3 ;
ibase_execute( $query , $newid );
$sql = " SELECT * FROM data " ;
$results = ibase_query( $link , $sql ) or die (ibase_errmsg());
while ( $row = ibase_fetch_assoc( $results )){
echo $row [ ' ID ' ] . ' <br> ' ;
}
ibase_free_result( $results );
ibase_close( $link );
if ( ! ( $link = ibase_connect( $strconnect , ' sysdba ' , ' pass0000 ' , ' ISO8859_1 ' , 0 , 1 )))
die ( ' Could not connect: ' . ibase_errmsg());
$query = ibase_prepare( $link , ' insert into data (id) values (?) ' );
$newid = 3 ;
ibase_execute( $query , $newid );
$sql = " SELECT * FROM data " ;
$results = ibase_query( $link , $sql ) or die (ibase_errmsg());
while ( $row = ibase_fetch_assoc( $results )){
echo $row [ ' ID ' ] . ' <br> ' ;
}
ibase_free_result( $results );
ibase_close( $link );
Delphi