CODEWITHSUNDEEP
phpdatabaseodbcfirebird
Sebastian
Sebastian

Reputation: 87

Unable to connect to data source: library 'gds32.dll' failed to load - Firebird Connection PHP odbc_connect

I am trying to connect to a Firebird database using PHP. This is the simple code that I use to connect to it.

$user = "******";
$password = "******";
$ODBCConnection = odbc_connect("DRIVER={Firebird/InterBase(r) driver};Database=******;Server=******;Port=******", $user, $password);

I have installed the ODBC driver for Firebird from this webpage https://www.firebirdsql.org/en/odbc-driver/. I've managed to add the correct (I believe) string to the DRIVER inside the ODBC Conection, but now I encounter this error:

Warning: odbc_connect(): SQL error: [ODBC Firebird Driver]Unable to connect to data source: library 'gds32.dll' failed to load, SQL state 08004 in SQLConnect

I am running an Apache server using XAMPP on localhost. Everything I wrote is in the index.php file, just trying to connect to the database.

Any help would be greatly appreciated.

Upvotes: 1

Views: 12192

Answers (1)

Mark Rotteveel
Mark Rotteveel

Reputation: 109260

This error occurs when you do not have the Firebird client library (fbclient.dll, or gds32.dll which is tried as a fallback) installed on your system (or you have it installed, but it has the wrong bitness).

To install the Firebird client library, use a Firebird server installer of the right bitness* (eg Firebird 3 Windows 64-bit from https://www.firebirdsql.org/en/firebird-3-0/), and install the Client components.

That said, if you're using PHP, it might make sense to use the Firebird PHP driver instead (though this will still need fbclient.dll to be installed).

*: right bitness: If you use a 32-bit PHP, you need the 32-bit client library, if 64-bit, then the 64-bit client library.

Upvotes: 4

Related Questions