Stack Overflow
Stack Overflow

Questions tagged [unixodbc]

unixODBC is an open source project that implements the ODBC API on non windows platforms.

ODBC is an open specification for providing application developers with a predictable API with which to access data sources.

The ODBC API was outlined by X/Open and ISO, and it is available on all major platforms. Microsoft platforms include many enhancements to this specification.

unixODBC is an open source project that implements the ODBC API (including all the enhancements made by Microsoft) on non windows platforms.

630 questions
0
votes
1 answer

Reading MS Access database on Debian using FreeTDS

I tried to read ms access data base over the network using this code - cnxn = pyodbc.connect('DRIVER={FreeTDS};DBQ=\\http:\\10.0.0.2\NetworkSharedFolder\Misure.mdb;') cursor = cnxn.cursor() cursor.execute('SELECT Id,Data, Ora, Esito, Res_Esito,…
Inderpal Singh
  • 270
  • 2
  • 8
  • 24
0
votes
1 answer

how do you enable all users access to odbc driver in linux

I have setup an odbc connection in linux that connects to MSSQL server: This is the location and permission of .ini and inst files: -rw-r--r-- 1 root root 169 Aug 7 17:00 odbc.ini -rw-r--r-- 1 root root 188 Aug 7 16:40 odbcinst.ini This…
user1471980
  • 10,127
  • 48
  • 136
  • 235
0
votes
4 answers

unixodbc can't write the trace file

My unixodbc can connect to PostgreSQL,but the unixodbc always write the wrong trace file. I set the trace file in /tmp/odbc.log but unixodbc always write it in /tmp/sql.log. Where are wrong in my setting? ---odbcinst -j--- unixODBC…
user3655478
  • 1
  • 1
  • 2
0
votes
1 answer

Building log4cxx with unixodbc

I have been trying to build log4cxx with unixodbc (I can connect to the database using console), but when trying to build log4cxx --with-ODBC, the ./configure always results in configure: error: unixODBC not found ! I have tried setting my…
Raaka
  • 304
  • 1
  • 3
  • 15
0
votes
1 answer

unixODBC driver trace only shows tracing from pl/perl but not perl?

I added to odbcinst.ini the following: [ODBC] Trace = yes TraceFile = /777path/odbctrace.txt This produces the file indicated; however, it seems to be tracking only one particular connection out of the multiple connections there are:…
Kev
  • 15,899
  • 15
  • 79
  • 112
0
votes
1 answer

PHP warning odbc_connect() SQL Error

I just installed an iSeriesODBC-5.1.0-0.16.i386.rpm on my ubuntu linux 12.04 32bit OS. What im trying to do is connect to a DB2 AS400. When I run this code below:
user2720708
  • 455
  • 2
  • 8
  • 19
0
votes
1 answer

SQL_INTERVAL_STRUCT fraction value

I have been using the SQL_INTERVAL_STRUCT to fetch Interval data from an Informix database. I have discovered that the fractional part of the Interval is expected to be in microseconds (rather than milliseconds). Can anyone confirm if this is…
David Ritter
  • 110
  • 9
0
votes
0 answers

XA transaction not working with unixODBC on DB2

I am trying to get XA transactions work using unixODBC driver for DB2 database and WMQ Manager using C++. Default Auto Commit has been turned off Following are the configurations: UnixODBC => odbc.ini Driver = DB2_DRIVER Database = DBNAME uid =…
Hudson Diniz
  • 43
  • 1
  • 2
  • 4
0
votes
1 answer

Check_sql.pl DBD:ODBC Error - Nagios

New Issue: I am trying to run my check_sql command and am running into this problem ./odbcinst -j unixODBC 2.3.0 DRIVERS............: /usr/local/unixODBC/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/unixODBC/etc/odbc.ini FILE DATA SOURCES..:…
John Z
  • 464
  • 1
  • 6
  • 17
0
votes
0 answers

Cannot map an error code returned from unixodbc using PostgreSQL database

I am using PostgreSQL using unixodbc driver, and while trying to get connection, I get error. I am only printing the value of pfNativeError of SQLError, and I get a value of '26'. I have gone through the error codes returned by postgresql, as…
user3098199
  • 31
  • 1
  • 5
0
votes
1 answer

Error when connecting to database using unixODBC on IBM AIX

I am facing an error while connecting to database using unixODBC on IBM AIX 64bit DB2 client V9.7 is installed on the machine. Found on net that it can be due to library file:' libdb2o.so ' missing and in that case update to DB2 V9.7 Fix Pack3.…
Rohit Katiyar
  • 1
  • 2
0
votes
1 answer

Teradata 'Unable to get catalog string' error when using ODBC to connect

I am trying to reach a remote host that is running Teradata services via ODBC. The host that I am trying to connect from is 64-bit RHEL 6.x with the following Teradata software installed: bteq fastexp fastld jmsaxsmod mload mqaxsmod npaxsmod…
Jubbles
  • 4,450
  • 8
  • 35
  • 47
0
votes
1 answer

what is the optimal number of process that can be handled by unixODBC?

My application used to read data from different sections of large file and update the tables. Each section of the data is associated with a separate table. The update process can contains multiple insert, update and delete statements. I am trying…
Ullan
  • 905
  • 4
  • 15
  • 28
0
votes
1 answer

How to get odbc driver version? It is confusing?

We use psqlODBC driver through unixODBC driver to access postgres database. The unixODBC version is: # odbcinst --version unixODBC 2.2.14 So does this mean ODBC version is v2.0? But in psqlODBC code I see that default ODBC version set to v3.0 (i.e.…
pitnal
  • 551
  • 1
  • 5
  • 17
0
votes
0 answers

How to set up the ODBC environment in Linux

When unixODBC (odbc.ini and odbcinst.in) files are under /usr/local/etc/. My application works fine. I deleted the unixODBC files from /usr/local/etc/ and copied .odbc.ini and .odbcinst.ini files under home/$USER directory. I have done the…
Ullan
  • 905
  • 4
  • 15
  • 28
1 2 3
…
41 42