Questions tagged [unixodbc]
35 questions
15
votes
4 answers
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 odbcinst.ini.
Superficially it is pretty obvious -…
![](../../users/profiles/236770.webp)
Leonid
- 151
- 1
- 1
- 7
6
votes
3 answers
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 to find some questions I could ask that guy..
I…
![](../../users/profiles/49694.webp)
Chris
- 597
- 1
- 6
- 18
5
votes
2 answers
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 installed the Oracle InstantClient 11.2 and the…
user58852
3
votes
1 answer
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 up the unixodbc driver from apt-get and if I…
![](../../users/profiles/99708.webp)
drivard
- 407
- 1
- 6
- 17
2
votes
1 answer
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 ODBC driver (yum install…
![](../../users/profiles/335869.webp)
Agop
- 121
- 1
- 6
2
votes
1 answer
[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=;DATABASE=;' username password -v
as root on my Linux CentOS 6.7.
The following bcp command works, so the driver should be…
![](../../users/profiles/251721.webp)
Marco Marsala
- 471
- 3
- 7
- 14
2
votes
1 answer
“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:
[server1]
host = 192.168.100.147
port =…
user281736
2
votes
1 answer
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.
![](../../users/profiles/7741.webp)
Jean Jordaan
- 277
- 2
- 11
1
vote
1 answer
ODBC Driver for IBM iSeries AS400 version V7R1
I am trying to connect to IBM iSeries using pyodbc, a Python interface for ODBC, on Linux Red Hat (Intel 64bit arch).
The following is what I have done:
Installed gcc-c++ (needed to compile pyodbc), unixODBC, unixODBC-devel
Installed…
![](../../users/profiles/411472.webp)
Fabio
- 121
- 5
1
vote
1 answer
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 driver. But I need two different driver managers…
![](../../users/profiles/508267.webp)
Sam
- 11
- 1
1
vote
1 answer
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 PHP 7.0
Needed unixODBC: 2.3.1
sudo yum info…
![](../../users/profiles/216151.webp)
Sean256
- 161
- 1
- 5
1
vote
1 answer
"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 webbrowser:
(variables are set and right)
![](../../users/profiles/319399.webp)
user3665396
- 21
- 4
1
vote
2 answers
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 installation.
I had managed to install the required…
![](../../users/profiles/89906.webp)
Memochipan
- 327
- 1
- 2
- 11
1
vote
0 answers
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 individual files rather than work on one monolithic…
![](../../users/profiles/54481.webp)
Jordan Reiter
- 1,260
- 4
- 17
- 38
1
vote
2 answers
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][MySQL][ODBC 3.51 Driver]Lost connection to MySQL…
![](../../users/profiles/58013.webp)
Scott
- 133
- 5