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
Request clarification before answering.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.