Open GoogleCodeExporter opened 8 years ago
Pls help...
$ isql -v ocs_cfg_db
[08004][unixODBC][ODBC Firebird Driver]File Database is not found
[ISQL]ERROR: Could not SQLConnect
$ odbcinst -q -s
[ocs_cfg_db]
$ odbcinst -q -d
[Firebird]
$ odbcinst -j
unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/danateq/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
odbc.ini
[ocs_cfg_db]
Description = Firebird
Driver = Firebird
Dbname = host/port:ocs_cfg_db
User = sysdba
Password = masterkey
Role =
CharacterSet =
ReadOnly = No
NoWait = No
odbcinst.ini
[Firebird]
Description=InterBase/Firebird ODBC Driver
Driver=/usr/lib64/libOdbcFb.so.2.1.0
Setup=/usr/lib64/libOdbcFb.so.2.1.0
FileUsage=1
CPTimeout=
CPReuse=
UsageCount=10
Original comment by wmsi...@gmail.com
on 25 Sep 2013 at 6:31
This took me almost a week to figure out I'll see if I can help.
/etc/freetds/freetds.conf
# Define a connection to the Microsoft SQL Server
[mssql]
host = XXXXXXXXXXXX - This is your server name.
port = 1433
tds version = 8.0
/etc/odbc.ini
# Define a connection to a Microsoft SQL server
# The Description can be whatever we want it to be.
# The Driver value must match what we have defined in /etc/odbcinst.ini
# The Database name must be the name of the database this connection will
connect to.
# The ServerName is the name we defined in /etc/freetds/freetds.conf
# The TDS_Version should match what we defined in /etc/freetds/freetds.conf
[mssql]
Description = MSSQL Server
Driver = freetds
Database = dbname #This is your Database name in MSSQL Server
Server = XXXXXXXXXXXX #This is your server name again
Port = 1433
TDS_Version = 8.0
/etc/odbcinst.ini
# Define where to find the driver for the Free TDS connections.
[freetds]
Description = MS SQL database access with Free TDS
Driver = /usr/lib/odbc/libtdsodbc.so
Setup = /usr/lib/odbc/libtdsS.so
UsageCount = 1
Make sure you're in the right location here.
Big thing that stands out is what's that Firebird driver? If you're using
MSSQL just use unixODBC and freeTDS newest versions for both will suffice.
Original comment by whoisea...@gmail.com
on 11 Nov 2013 at 4:38
Wonderful help.. my paths were mostly different, but finding the locations and
pointing to them worked fine. Thanks for your week of work!
Original comment by Henry.Co...@gmail.com
on 30 Jun 2014 at 7:24
Original issue reported on code.google.com by
mseme...@gmail.com
on 29 Jul 2013 at 11:42