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
0 answers

Data truncated with sqlQuery in R with unixodbc from PostgreSQL

I'm storing data as very long character strings in a text field in PostgreSQL, but I'm hitting a limit when I retrieve the data. The table is as follows: CREATE TABLE test ( a integer, b text ) I insert data using R and RODBC with unixodbc…
MiG62
  • 198
  • 4
  • 10
0
votes
1 answer

Loading Data to HDFS with unixODBC/isql

I have a script on a Linux server (Cloudera) that uses unixODBC/isql to pull data from a Netezza server. It generates a text file on the local filesystem and then pushes it to HDFS. export ODBCHOME=; export ODBCINI=; export LIBPATH=; export…
Danzo
  • 553
  • 3
  • 13
  • 26
0
votes
3 answers

Connecting Redland to Virtuoso through Virtuoso's ODBC/iODBC on MacOS X Environment

In order to install Virtuoso on my MacOS X environment, i used the brew port, that is: brew install virtuoso By doing so, it automatically installed some ODBC/iODBC drivers, that could not be overwritte by any other unixodbc setup. In particular if…
jackb
  • 695
  • 8
  • 26
0
votes
1 answer

How do I connect to Azure using unixODBC and FreeTDS?

I'm on CentOS and I can log into my database using the following: TDSVER=7.2 tsql -H example.database.windows.net -U myname -D MyDataBase -p 1433 Then I put in my password and I can log in A-OK. Unfortunately isql/osql seem to have much more…
Wayne Werner
  • 49,299
  • 29
  • 200
  • 290
0
votes
1 answer

QSqlQuery returns "???" for none English string

When running the code below the result is 'אבגדה' in Windows and '?????' on Linux, seems that the qry.value(0) (a QVarient type) using a defult coding. In Linux I'm using free.dts and odbc.ini in the driver level How to set QSqlQuery so that the…
Noam M
  • 3,156
  • 5
  • 26
  • 41
0
votes
0 answers

how to compile unixODBC in zabbix

I am trying Database monitor in zabbix following the official document odbc_checks I have installed unixODBC and unixODBC drivers(mysql and oracle) yum -y install unixODBC unixODBC-devel yum install mysql-connector-odbc rpm -ivh…
Chaoping Xie
  • 13
  • 1
  • 6
0
votes
2 answers

Error during insert with parameter(s) over 30 characters

Issue Performing an insert using prepared statements with PDO and an ODBC driver gives the following error when at least one of the parameters is over 30 characters: SQLSTATE[HY010]: Function sequence error: 0 [unixODBC][Driver Manager]Function…
Stewart Smith
  • 1,396
  • 13
  • 28
0
votes
1 answer

Connection to MS SQL server with RODBC from mac osx 10.11

I have downloaded and configured freeTDS and unixODBC as proof I have connected with tsql and isql. When I download RODBC from RStudio and try and connect with mssql server I get the following error [RODBC] ERROR: state IM002, code 1606386064,…
Bryan
  • 9
  • 1
0
votes
0 answers

PHP 5.6 ODBC returns a special character array for string values from database?

array result from odbc Im accessing the intersystem cache database via unix odbc and displaying the details in the website (PHP). Recently I have upgraded the PHP to 5.6 version. Im getting nondisplayable characters (�) for only strings but the…
NAVIN NEO
  • 1
  • 2
0
votes
1 answer

PDO Fetch assoc iSeries AS400 unixodbc only returns first letter of column

When using the PDO ASSOC statement I am only getting first letter of the column instead of the full one. Any ideas ? More information below : Small code block to fetch_assoc via PHP : $pdo = new PDO("xxx",…
David
  • 840
  • 6
  • 17
  • 37
0
votes
0 answers

28000 210 {[unixODBC]Failed to send the authentication packet; Could not flush socket buffer." -->DB error

While connecting the DB, I am facing the below issue 28000 210 {[unixODBC]Failed to send the authentication packet; Could not flush socket buffer. Can you please help me to resolve this?
Rinku Zubair
  • 1
0
votes
0 answers

pyodbc connection with Advantage ODBC Driver (Linux)

I am trying to connect to an existing Sybase Advantage Database Server via the ODBC driver on a LOCAL instance. I currently have unixodbc, unixodbc-dev, and unixodbc-bin installed. When I attempt the following: import pyodbc str='DRIVER={Advantage…
Philippe Hebert
  • 1,616
  • 2
  • 24
  • 51
0
votes
1 answer

FreeTDS MSSQL nvarchar(max) issue

I'm pulling out data from an MSSQL server via PDO on a Unix system. Having tried the Easysoft ODBC Driver, which works as intended (but expensive!) I'm just trying out FreeTDS before we commit to buying a license. Trying to pull out data from the…
spirie
  • 21
  • 5
0
votes
1 answer

Environment variables in Zabbix's host

I want to have a graph from queries to Oracle. I can connect to remote Oracle with isql and sqlplus. But in Zabbix host has an error: Cannot connect to ODBC DSN:[SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no…
Lassi Autio
  • 1,147
  • 1
  • 13
  • 35
0
votes
0 answers

SQLSTATE[08S01] SQLDriverConnect: 20009 [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist

First of all I know there are many questions posted for the same issue. I have tried every thing but couldn't get it to work. I am trying to connect to SQL Server using PHP. I've configured FreeTDS and unixODBC correctly. I tried tsql, isql and…
Muzammil Versiani
  • 181
  • 2
  • 12
1 2 3
…
41 42