Questions tagged [unixodbc]
35 questions
1
vote
1 answer
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 from /usr/local/psql/etc
I linked…
![](../../users/profiles/37917.webp)
Sirber
- 308
- 5
- 18
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…
![](../../users/profiles/15576.webp)
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…
![](../../users/profiles/165821.webp)
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…
![](../../users/profiles/53396.webp)
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…
![](../../users/profiles/111132.webp)
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 =…
![](../../users/profiles/54481.webp)
Jordan Reiter
- 1,260
- 4
- 17
- 38
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…
![](../../users/profiles/57989.webp)
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…
![](../../users/profiles/2551.webp)
Nick
- 205
- 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…
![](../../users/profiles/204292.webp)
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…
![](../../users/profiles/405368.webp)
Mrudang Vora
- 41
- 1
- 8
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.…
![](../../users/profiles/341767.webp)
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…
![](../../users/profiles/210577.webp)
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…
![](../../users/profiles/210577.webp)
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…
![](../../users/profiles/157599.webp)
David
- 13
- 4
0
votes
0 answers
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 and libodbcinst.so.
Individually each driver…
![](../../users/profiles/293416.webp)
user55570
- 448
- 6
- 17