Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [unixodbc]

37 questions
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…
Jordan Reiter
  • 1,290
  • 4
  • 20
  • 40
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…
Scott
  • 133
  • 5
1
vote
1 answer

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 progress\nProcess ID: 0\nSession ID: 0 Serial…
lilott8
  • 496
  • 5
  • 14
1
vote
0 answers

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. On Ubuntu we get segfaults when SQL statements…
MaKR
  • 111
  • 6
1
vote
1 answer

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 foo). Now I am trying to add another data source…
NP01
  • 185
  • 1
  • 2
  • 7
1
vote
1 answer

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-bit systems, but having an issue with applications…
quidpro
  • 11
  • 2
1
vote
0 answers

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 port = 5150 tds version = 8.0 ;client charset =…
Jordan Reiter
  • 1,290
  • 4
  • 20
  • 40
1
vote
0 answers

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 an odbc_connect, I get a response of type "odbc…
Brad Westness
  • 115
  • 4
1
vote
1 answer

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 pyodbc module, but whenever I try to connect I get…
Nick
  • 215
  • 5
  • 8
0
votes
1 answer

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 database via Apache (using PHP) no longer worked. I…
Wes
  • 111
  • 1
  • 8
0
votes
0 answers

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 is installed. (Research link: Installing ODBC…
Mrudang Vora
  • 61
  • 1
  • 1
  • 9
0
votes
0 answers

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 fine when I use it via Django Development server.…
Moinuddin Quadri
  • 101
  • 2
0
votes
1 answer

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 Linux is used. Refer following error message, for…
Pravin
  • 121
  • 2
0
votes
0 answers

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 server. Following command used: sqlcmd -D -U$DBUSER…
Pravin
  • 121
  • 2
0
votes
1 answer

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 are the relevant pieces of the bash script that is…
David
  • 13
  • 4
1
2
3