The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
84 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
13 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
146 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 ...
0
votes
0answers
70 views

unixODBC on CentOS 6.7 with PostgreSQL 9.3

I am attempting to connect to a PostgreSQL 9.3 database on a Debian machine, more specifically an Ubuntu 14.04 machine using unixODBC. I am able to connect via the psql command using the same user ...
0
votes
0answers
62 views

Installing unixODBC-devel package in Centos 5

I am trying to install a unixODBC-devel-2.2.11-10.el5.x86_64 and I already installed all of it's required library package from here, but still my installation process is getting interrupted because of ...
0
votes
1answer
225 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
58 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 ...
0
votes
0answers
501 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. ...
1
vote
1answer
1k 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
79 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 ...
1
vote
0answers
25 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 ...
6
votes
3answers
6k 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 ...
2
votes
0answers
3k 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
664 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
62 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
779 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....
1
vote
1answer
124 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
266 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 ...
0
votes
1answer
1k 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
764 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
861 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
841 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
513 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 ...
0
votes
1answer
590 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
3k 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 ...
3
votes
2answers
11k 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 ...