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

Configuring a connection timeout when connecting to a MS SQL Server database from a lua script using FreeTDS and unixODBC

I have a lua script, running on a RHEL7 host, which has been written to connect to a MS SQL Server database (using FreeTDS / unixODBC) and retrieve a value. The script generally works OK, however, if the target server is offline/unavailable, it will…
verticallygifted
  • 63
  • 2
  • 8
0
votes
1 answer

Unable to resolve ORA-12154: TNS:could not resolve the connect identifier specified

I am not able to solve this error I am getting only from the Web Browser. I am trying to connect to a remote Oracle DB using PDO_ODBC in PHP. I think all is well configured, because when I try to connect using sqlplus or isql all is OK! When I try…
Flavio Spugna
  • 93
  • 8
0
votes
2 answers

Why does one ODBC connection work and the second doesn't?

I am using ODBC and FreeTDS on Ubuntu 14.04. We now have three servers that may be running the database at any one time (only one at a time). I tried adding the second server to my freetds.conf and odbc.ini files, but it will never connect, even…
Dan Ringhiser
  • 156
  • 10
0
votes
1 answer

My application doesn't seem to understand PostgreSQL datestytle settings

I have a PostgreSQL database with datestyle set to "german,dmy" and it works fine on psql. However, when my application tries to retrieve dates from this database (using unixODBC driver) these dates "arrive" in "iso" style... Could it be caused by…
Paulo Andre Dias
  • 13
  • 2
0
votes
0 answers

Use PHP to get varchar(max) from MSSQL via ODBC

I am trying to fecth a varchar(max) column from a MSSQL server in PHP (on linux) using ODBC but I don't quite get the expected result. The code: $sqlTest="select convert(text,Contents) as Script from…
bipsen
  • 5
  • 4
0
votes
1 answer

How are RPMs in RHEL Package named?

I see that the RPM packages are named as below , but then I am confused about how a RPM released with new patch named ? For e.g RPM packages typically have file names like foo-1.0-1.i386.rpm. The file name includes the package name (foo),…
Invictus
  • 4,028
  • 10
  • 50
  • 80
0
votes
1 answer

SAP HANA Studio's Remote Source has stopped working

My Hive's remote source in SAP HANA Studio Has stopped working. The image below shows it: The error that shows is the following: SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Driver Manager]Data source name…
Joan Sánchez Escudero
  • 9
  • 6
0
votes
1 answer

Error IM002 with isql but odbc.ini and odbcinst.ini exist

I'm currently installing a virtuoso server on my Mac OS X. However I got an error when I run the isql command: isql -v 1111 dba dba [IM002][unixODBC][Driver Manager]Data source name not found, and no defaul driver specified [ISQL]ERROR: Could…
Cyril
  • 485
  • 4
  • 15
0
votes
1 answer

Monitor Oracle DB with Zabbix

I install and configure Oracle instant client and unixODBC. When login with root, can connect to db by sqlplus or isql. root@zabbix:~# sqlplus ***/***@*** SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 7 13:56:42 2017 Copyright (c) 1982, 2014,…
DaddyRatel
  • 729
  • 3
  • 13
  • 30
0
votes
0 answers

pyodbc cannot find unixodbc library when using Anaconda Python

I want to use Anaconda Python 3.6 to do data analysis. And I use unixodbc to connect to database. When I use Anaconda Python I got pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib…
williamz
  • 23
  • 5
0
votes
1 answer

How to connect to Firebird using ODBC on Ubuntu

I want to import some data from a non-local database to RStudio. I've searched and I found that I could use RODBC library at RStudio, like: channel <- odbcDriverConnect('driver={SQL Server}; server= servername; database=dbname;…
Ítalo Medeiros
  • 1
  • 3
0
votes
1 answer

when use isql,i got this: [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified

when i type fllow command: isql dsnOracle -v i got : [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect my config file: [root@localhost lib]# cat…
i love jack
  • 119
  • 3
  • 9
0
votes
1 answer

Is Microsoft ODBC Driver 11 for SQL Server on Linux compatible with SQL Server 2014

I am trying to use Microsoft ODBC Driver 11 for SQL Server to connect with a SQ: Server instance running SQL Server 2014. I am getting the following error message when attempting to connect: ERROR SQLDriverConnect(): failed: [HYT00]…
BigDataKid
  • 1,199
  • 6
  • 10
0
votes
1 answer

MSSQL nvarchar(max) on opensuse-webserver

I am currently creating a webform on an opensuse-webserver that includes a textarea in which it you can add pictures by using copy and paste. We did this by using a DIV and giving it the "contenteditable="True" value. This results in a very long…
PascalW
  • 1
  • 1
0
votes
1 answer

Connect to MSSQL database with arm linux board using unixODBC and FreeTDS problems

I am having problems to query a remote MSSQL database from my arm linux board. I compiled unixODBX and FreeTDS, copied all files to the arm board with the same path as in the Ubuntu machine where they where compiled. I also compiled everything for…
GrandJonas
  • 1
  • 2
1 2 3
…
41 42