Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [unixodbc]

The tag has no usage guidance.

1
vote
1answer
23 views

Connect ODBC throught another VM?

I have a big issue in my company. I am trying to migrate a web application from Windows to Linux; everything works fine, except the ODBC connection. We have 3 databases, each one of them provide a ...
0
votes
1answer
12 views

unixODBC in Apache broken after enabling Kerberos on Centos7

Had unixODBC working very well. Decided that we wanted to implement Kerberos authentication to lock down different sites in Apache to certain user groups. Once this got enabled, connecting to the ...
0
votes
0answers
70 views

Amazon Linux ODBC driver not working

I've installed the ODBC driver and the sqlsrv regular and PDO PHP extension versions on my Amazon Linux machine. When I execute the following command, I get a confirmation that the driver is installed....
1
vote
1answer
525 views

How to update unixODBC via yum on EB awsLinux

In summary I need to update unixODBC on the Elastic Beanstalk PHP instances, preferably using yum as it's quite easy to manage via .ebextensions. AWS Linux: 64bit Amazon Linux 2017.03 v2.4.2 running ...
0
votes
0answers
719 views

Next steps after installation of MSSQL ODBC 13.1 on Amazon EC2 Linux

Was able to install the Microsoft ODBC driver 13.1 and mssql-tools on Amazon Linux after quite research. It automatically installed unixODBC-2.3.4 as dependency but not sure what is the path where it ...
0
votes
0answers
235 views

Nginx + Pyodbc (UnixODBC) + Gunicorn + Django : [unixODBC][Driver Manager]Can't open lib

I am getting: [01000] [unixODBC][Driver Manager]Can't open lib '/usr/local/nz/lib64/libnzodbc.so' : file not found (0) (SQLDriverConnect)" error while creating connection using PyODBC. This works ...
0
votes
1answer
233 views

How to avoid information message of sqlcmd?

I'm writing script to connect database & execute store procedures, which works fine. But sqlcmd prints extra information message/ invalid characters to command line. Sqlcmd version 13.0.0000.0 ...
0
votes
0answers
331 views

Using 'bcp' sql server connection failed, Unable to invoke odbc.ini dns

I'm new to MS SQL server, doing tryouts to connect to MS-SQL Server through Linux system. For this I had installed odbc driver & configured odbc.ini. By using sqlcmd, I'm able to connect to SQL ...
0
votes
1answer
2k views

Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8

I have been attempting to get "Microsoft ODBC Driver 13 for SQL Server" running in Ubuntu for two days now, and I am out of ideas / have exhausted Google. My test machine is a vagrant VM, and these ...
0
votes
0answers
74 views

Conflicting libodbc.so for Teradata and Hive on solaris

We seem to have a situation where the ODBC drivers for solaris of Teradata (v 14.10 from Teradata) and the Simba Hive ODBC (v 2.0.3) are requiring different versions of the shared objects: libodbc.so ...
2
votes
1answer
979 views

IBM's iSeries ODBC driver not sending any traffic when invoked via isql or otherwise, getting [08S01][unixODBC] and [ISQL]ERROR: Could not SQLConnect

Note: I've replaced IP addresses, database names, and server users with examples. That shouldn't affect anything. The Setup I've installed unixODBC (yum install unixODBC) and IBM's official iSeries ...
1
vote
1answer
940 views

“Unable to connect to data source” Debian unixODBC FreeTDS; PHP CLI works, apache/web doesn't

Envoironment: webserver: Debian8 with Apache, PHP, unixODBC, FreeTDS (current versions installed with apt-get last week) dataserver: Windows Server 2008 with MS SQL Server 2008 Opening this in ...
1
vote
2answers
340 views

Where to set bash settings for the user “mysql”

Please excuse me if the question is misleading. I'm trying to understand the way the environment settings work for the user "mysql". I'm following this guide to connect an Oracle DB from a MariaDB ...
2
votes
1answer
3k views

[S1090][unixODBC][Driver Manager]Invalid string or buffer length

I'm getting the error above when issuing isql 'odbc:Driver={ODBC Driver 11 for SQL Server};SERVER=<redacted>;DATABASE=<redacted>;' username password -v as root on my Linux CentOS 6.7. ...
2
votes
1answer
6k views

“Unknown host machine name.” on FreeBSD + unixODBC + FreeTDS

I got some issues connecting to a Microsoft SQL Server 2012 from my FreeBSD 10.1 server. I installed FreeTDS and unixODBC via ports. I compiled FreeTDS with unixODBC support. This ist my freetds.conf:...
0
votes
1answer
124 views

FreeTDS - sudo uses different protocol version

After a while of fiddling with FreeTDS I got my connection to MSSQL from Sphinx up and running as DSN-less connection. After running indexer index Everything works as expected. But, after running ...
1
vote
0answers
26 views

Is it possible to create something along the lines of an odbc.d directory?

Many servers such as nginx, Apache httpd, as well as other services and tools like yum, supervisord, cron, etc allow you to place configuration files in a directory and add, remove, and change ...
10
votes
4answers
17k views

Looking for good documentation of odbc.ini and odbcinst.ini files on Linux

I saw partial information, old information, but nothing as good as the actual sample files with brief comments that I have locally. I need to understand the exact relationship between odbc.ini and ...
4
votes
3answers
7k views

Connecting to MSSQL server using sqlcmd and odbc driver on RHEL 6 fails

I spent the last hour trying to connect to a mssql server using sqlcmd through odbc driver. I was talking to the db guy but he doesn't seem to have a clue what is going on.. Maybe you can help me out ...
0
votes
1answer
1k views

How to compile FreeTDS on FreeBSD10.0-64 in a right way

When i try compile freetds-stable from source (today is a 0.91 version) with: ./configure --with-iodbc=/usr/local --with-tdsver=7.2 --disable-libiconv make make install i didn't find the libtdsodbc....
1
vote
2answers
78 views

Diagnosing sporadic MySQL fault

I have some C++ applications that access our MySQL database via unixODBC on Ubuntu 10.04. Once every few weeks for the last several weeks, I've seen this error appear in our error logs: [unixODBC][...
0
votes
1answer
1k views

Pervasive and unixODBC on Ubuntu Server 12.x x64

I'm trying to setup pervasive client to access a windows server. Extracted Pervasive.SQL-Client-Core-11.30-061.000.x86_64.tar.gz to /usr/local/ I installed unixodbc (x64) I ran ./clientpostinstall.sh ...
1
vote
1answer
186 views

Oracle SQLConnect: 1033 via UnixODBC

Here is the full error: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in ...
1
vote
0answers
356 views

LAMP using ODBC to DB2

I have connected an openSUSE LAMP and an Ubuntu LAMP server to DB2 using ODBC. The openSUSE system we're using for a development environment, and the final deployment is to be on the Ubuntu system. ...
3
votes
1answer
2k views

Debian build the freeradius package with unixodbc support

Here is what I am trying to achieve, we want to install freeradius using a Microsoft SQL backend. I read on the internet that we need to achieve this goal using the unixodbc driver. I am able to set ...
1
vote
1answer
2k views

Automatically reconnect to ODBC sources?

I am using Asterisk 1.8.10.1 and a MySQL database connected via ODBC to store CDRs. When my MySQL database isn't available when Asterisk starts or has an outage while Asterisk is running, I would ...
1
vote
1answer
1k views

Adding data sources for unixODBC/isql on Mac OSX Lion

I have installed unixODBC from source and mysql-odbc connector from .dmg installer on Mac OSX Lion. This was done a while ago, and at that time I successfully installed a data source (let's call it ...
1
vote
1answer
1k views

MySQL ODBC Connector & unixODBC Issue - Garbled connections

Having a heck of a time trying to isolate an issue on a new server install: I've installed MySQL, unixODBC and the MySQL Connector for ODBC, setup odbc.ini and odbcinst.ini as I have on my other 32-...
1
vote
0answers
999 views

Connecting to a specific database using FreeTDS

I have my freetds.conf set up thusly. Notice that I specifically have set up the database as myawesomedb: [EXAMPLE_CONF] driver = /usr/lib64/libtdsodbc.so host = example.org database = myawesomedb ...
1
vote
0answers
647 views

Oracle Instant Client DSN via unixODBC

I've got the Oracle Instant Client installed on a SuSE webserver and I'm attempting to connect to an Oracle Database with PHP via unixODBC. The connection seems to be working properly, after issuing ...
2
votes
1answer
2k views

Is there any way to use ~/odbcinst.ini instead of /etc/odbcinst.ini?

Looking at http://www.unixodbc.org/odbcinst.html it looks like this is a compile-type option only.
1
vote
1answer
4k views

Connecting to MS SQL Server from Ubuntu Server

Using Ubuntu 10.04 LTS, I'm trying to connect to an MS SQL Server we have on another box from within a Python script. What are the steps I need to follow to do so? Right now, I'm trying to use the ...
5
votes
2answers
19k views

Using unixODBC to connect to Oracle server

I am trying to configure our web server (RHEL 5.4 x86) to connect to an Oracle database using unixODBC. I have installed unixODBC-2.2.11-7.1.1, which yum tells me is the latest version. I have also ...