Skip to Content
0

ODBC Data Services for FireBird DB

Apr 21, 2017 at 01:25 PM

168

avatar image
Former Member

Hello there!

Is it possible to connect to FireBird through ODBC ? My odbc.ini and ds_odbc.ini below. but error is:

ODBC call <SQLConnect> to connect database <FB_DS> failed with error: <ODBC call <SQLConnect> for data source <FB_DS> failed: <[DataDirect][ODBC lib] Specified driver could not be loaded>. Notify Customer Support.>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.

Also tried to change ds_odbc with FB driver - no luck too..

odbc.ini:

[ODBC Data Sources] DB2 Wire Protocol=DataDirect 7.1 DB2 Wire Protocol Informix Wire Protocol=DataDirect 7.1 Informix Wire Protocol Oracle Wire Protocol=DataDirect 7.1 Oracle Wire Protocol Sybase Wire Protocol=DataDirect 7.1 Sybase Wire Protocol Teradata=DataDirect 7.1 Teradata SQL Server Wire Protocol=DataDirect 7.1 SQL Server Wire Protocol MySQL Wire Protocol=DataDirect 7.1 MySQL Wire Protocol PostgreSQL Wire Protocol=DataDirect 7.1 PostgreSQL Wire Protocol Greenplum Wire Protocol=DataDirect 7.1 Greenplum Wire Protocol Salesforce=DataDirect 7.1 Salesforce Sybase IQ Wire Protocol=DataDirect 7.1 Sybase IQ Wire Protocol Progress OpenEdge Wire Protocol=DataDirect 7.1 Progress OpenEdge Wire Protocol Apache Hive Wire Protocol=DataDirect 7.1 Apache Hive Wire Protocol FB_DS = Firebird/InterBase(r) driver

[FB_DS] Driver=/home/biadmin/BI41/dataservices/DataDirect/odbc/lib/libOdbcFb.so Description=Firebird/InterBase(r) driverHostName=10.24.0.25

ds_odbc.ini

[FB_DS] Driver=/home/biadmin/BI41/dataservices/DataDirect/odbc/lib/libodbc.so OdbcConformanceLevel= LazyLoading= ODBC64SqlHandleSize=64 ODBC6SqlLenSize=64 RebrandedLib=TRUE DSN= Protocol=9.1 Port=5432 Database=mydb1 SERVER=10.24.0.25 Servername=10.24.0.25 HostName=10.24.0.25

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers