PHP 8.3 - Firebird ODBC Driver - Crash

[andrewassist]

I've setup the Drivers on our IIS box, changed the usual connection string we have to point at the new "Firebird ODBC Driver" and PHP just crashes

We are running FB 4.0.5 and have FBClient.dll from FB 4 , along with FB Odbc Driver 3.00.00.15

Event viewer shows:

Faulting application name: php-cgi.exe, version: 8.3.12.0, time stamp: 0x66f31faa
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x0000000000000000
Faulting process id: 0x374c
Faulting application start time: 0x01dba23b6226ee08
Faulting application path: C:\php-8.3.12-nts-Win32-vs16-x64\php-cgi.exe
Faulting module path: unknown
Report Id: 6fe72354-9099-49bd-adc2-d73c199a0006
Faulting package full name: 
Faulting package-relative application ID: 

Fault bucket 2244225369465395687, type 5
Event Name: BEX64
Response: Not available
Cab Id: 0

Problem signature:
P1: php-cgi.exe
P2: 8.3.12.0
P3: 66f31faa
P4: StackHash_ac46
P5: 0.0.0.0
P6: 00000000
P7: PCH_7A_FROM_ntdll+0x00000000000A0B24
P8: c0000005
P9: 0000000000000008_

DSN Line used is : "Driver={Firebird/Interbase(r) Driver};Server=FirePrime;Database=FirePrime:database.fdb"

Using PHP function Odbc_Connect

$DBH=odbc_connect($this->DB_FB_DSN,$this->DB_FB_USER,$this->DB_FB_PASS);

Any ideas?

Works fine with odbc 2.00.05.156 driver.

[irodushka]

Hi @andrewassist

First of all - "Driver={Firebird/Interbase(r) Driver}" forces the use of 2.0.5 FB ODBC driver, not 3.0. You should specify "Driver={Firebird ODBC Driver}" to use 3.0 driver.

I suppose this connection string is correct for ODBC 3.0:
"DRIVER=Firebird ODBC Driver;DBNAME=FirePrime:database.fdb;UID=SYSDBA;PWD=masterkey;" (use your credentials if you need to)
and this one - for ODBC 2.0.5:
"DRIVER=Firebird/InterBase(r) driver;DBNAME=FirePrime:database.fdb;UID=SYSDBA;PWD=masterkey;"

Just for me, both of these strings work fine.

However, this option also works ok:
"Driver={Firebird ODBC Driver};Database=localhost:C:\\Program Files\\Firebird\\Firebird_4_0\\examples\\empbuild\\employee.fdb;User=SYSDBA;Password=masterkey;"

I'm not sure if you should specify the full path to your db (like FirePrime:c:\\somefolder\\database.fdb) but that's your configuration and I hope it's ok)

And the last piece of advice - I recommend you create a DSN (a system one probably, if you're going to use it by ISS), check it's ok using the Windows ODBC admin tool, and then simplify your connection sting to just "DSN=<YourDSNName>;". That's much safer than specifying the entire connection string in PHP code.

Regards