Subject AW:[firebird-php] Database corruption
Author Wolfgang Naber
>> I got the parameters for the bde-component from the developer of the client-server application.
>> DB.Params.Clear;
>> DB.DriverName := 'INTRBASE';
>> DB.Params.Values['BATCH COUNT'] := '200';
>> DB.Params.Values['BLOB SIZE'] := '32';
>> DB.Params.Values['BLOBS TO CHACHE'] := '64';
>> DB.Params.Values['COMMIT RETRAIN'] := 'FALSE';
>> DB.Params.Values['ENABLE BCD'] := 'FALSE';
>> DB.Params.Values['ENABLE SCHEMA CACHE'] := 'FALSE';
>> DB.Params.Values['LANGDRIVER'] := 'DBWINUS0';
>> DB.Params.Values['MAX ROWS'] := '-1';
>> DB.Params.Values['OPEN MODE'] := 'READ/WRITE';
>> DB.Params.Values['SCHEMA CACHE SIZE'] := '8';
>> DB.Params.Values['SCHEMA CACHE TIME'] := '-1';
>> DB.Params.Values['SERVER NAME'] := ServerPfad;
>> DB.Params.Values['SQLPASSTHRU MODE'] := 'SHARED AUTOCOMMIT';
>> DB.Params.Values['USER NAME'] := User;
>> DB.Params.Values['WAIT ON LOCKS'] := 'FALSE';
>> DB.Params.Values['PASSWORD'] := Password;
>> DB.Params.Values['DRIVER FLAGS'] := '4096';
>> DB.LoginPrompt := False;
>> ...
>>
>> IB.Params.Clear;
>> IB.Params.Values['USER_NAME'] := User;
>> IB.Params.Values['PASSWORD'] := Password;
>> IB.Params.Values['LC_CTYPE'] := 'WIN1252';
>> IB.LoginPrompt := False;
>> IB.DataBaseName := ServerPfad;
>>

>What is the value of this constant (or variable)?
>ServerPfad

Tux:/usr/local/fbk/wawi.gdb (server name/full path); The programmer asked me, why I put localhost in the connection string, since in his opinion the absolut path should suffice.

>> And this is my connection string:
>>
>> $conn = &ADONewConnection('ibase');
>>$conn->charSet = 'WIN1252';
>> $conn->buffers = 2048;
>> $conn->dialect = 1;
>> $db_server = 'localhost:/usr/local/fbk/wawi.gdb';
>> $db_user = 'xyz';
>> $db_pass = 'xyz';
>> $db_database = '/usr/local/fbk/wawi.gdb';
>> $conn->Connect($db_server, $db_user, $db_pass);
>>