Questions tagged [unixodbc]

unixODBC is an open source project that implements the ODBC API on non windows platforms.

ODBC is an open specification for providing application developers with a predictable API with which to access data sources.

The ODBC API was outlined by X/Open and ISO, and it is available on all major platforms. Microsoft platforms include many enhancements to this specification.

unixODBC is an open source project that implements the ODBC API (including all the enhancements made by Microsoft) on non windows platforms.

630 questions
8
votes
2 answers

unixodbc driver manager cannot open specified library on install

I'm using ArchLinux and I am trying to install OpenEdge progress drivers so I can access it via PHP. I've installed the unixodbc package and the drivers, but when I test the connection via isql or PHP, I get the same error... # isql -3…
TheFrack
  • 2,823
  • 7
  • 28
  • 47
7
votes
2 answers

[Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1'

When I run $ python manage.py inspectdb --database=mssql_database I have the following error django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1' : file not…
xralf
  • 3,312
  • 45
  • 129
  • 200
7
votes
1 answer

Connect to SQL Server using SQLAlchemy

I'm trying to connect to a SQL Server Express database using SQLALchemy and pyodbc, but I'm continuously getting the error: (pyodbc.Error) ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified…
daveoncode
  • 18,900
  • 15
  • 104
  • 159
7
votes
1 answer

sql server function native parameter bind error

I'm using the following software stack on Ubuntu 10.04 Lucid LTS to connect to a database: python 2.6.5 (ubuntu package) pyodbc git trunk commit eb545758079a743b2e809e2e219c8848bc6256b2 unixodbc 2.2.11 (ubuntu package) freetds 0.82 (ubuntu…
nosklo
  • 217,122
  • 57
  • 293
  • 297
7
votes
1 answer

how connect to vertica using pyodbc

I've read the iODBC documentation regarding the odbc.ini, and the Vertica documentation. I also saw a question with the same error, but can't get the connection string to work as suggested in the previous question's answer. What I currently…
Kermit
  • 33,827
  • 13
  • 85
  • 121
7
votes
2 answers

One of the SELECT fails using unixOdbc - SQLSTATE[24000]: Invalid cursor state

I am running Ubuntu 13.10 with FreeTDS and ODBC (package: php5-odbc) installed. I use tds version = 8.0, but also tried tds version = 7.2. I am using PDO and this is my DSN: $dsn = sprintf('odbc:Driver=FreeTDS;Server=%s;Port=1433;Database=%s',…
Tom Raganowicz
  • 2,169
  • 5
  • 27
  • 41
6
votes
3 answers

R odbc::odbcListDrivers() does not list dirver in /opt/homebrew/etc/odbcinst.ini

I am trying to connect to a Microsoft SQL Server database from R studio. I installed the unixODBC driver manager using homebrew: brew install unixodbc I then tried to install the freetds driver as recommended on…
gconte
  • 73
  • 6
6
votes
5 answers

Connect to MS Access remote .mdb file from php on linux

I have been digging internet for couple days, reading very old information, that leads to very old and nonexisting sites, still, I understood, what is needed to achieve my goal. We have a file.mdb on server running WindowsXP, so I need to add it to…
Deele
  • 3,728
  • 2
  • 33
  • 51
6
votes
2 answers

ODBC Sql Server 17 driver on Mac OS X

In order to execute this python code [that works on Ubuntu 18] on a MAC, import pyodbc as odbc sql_conn_irs = odbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=xxx.xxx.xxx.xxx;DATABASE=irs;UID=xxxxx;PWD=xxxxxxxx;') I installed SQL…
Ivan
  • 7,448
  • 14
  • 69
  • 134
6
votes
1 answer

unixODBC C++ documentation...?

I cannot find any. All I found is this: http://libodbcxx.sourceforge.net/ but this is not the right documentation for me. I got a UnixODBC library for C++, and cannot find any docs I have this in the headers: /*! * \file * * \author Peter Harvey…
Kiril Kirov
  • 37,467
  • 22
  • 115
  • 187
6
votes
2 answers

Install unixODBC >= 2.3.1 on Linux Redhat/CentOS for msodbcsql17

I try to install msodbcsql17 on AWS EC2 with CentOS/RedHat (Linux). These are the steps, I have followed, from Microsoft (LINK): sudo su #Download appropriate package for the OS version #Choose only ONE of the following, corresponding to your OS…
Sean Stayns
  • 4,082
  • 5
  • 25
  • 35
6
votes
3 answers

Using unixODBC in a multithreaded, concurrent setting

I'm going to ask and answer this question because it took me forever to figure out and I wish the answer had been here to begin with. The problem: One long-running unixODBC query blocks all others from the same application. The question: How does…
sclv
  • 38,665
  • 7
  • 99
  • 204
6
votes
3 answers

Using typed bound parameters with PHP PDO-ODBC, unixODBC and FreeTDS

I'm using the following setup to access a MS-SQL database from a PHP application RedHat Enterprise Linux 5 PHP 5.2.14 with PDO and PDO_ODBC unixODBC 2.2.11 FreeTDS 0.82.1.dev.20100810 Unparametrized queries work fine. The only issue is being…
Pierre Buyle
  • 4,883
  • 2
  • 32
  • 31
6
votes
3 answers

Unicode SQLDriverConnectW(): [unixODBC][Driver Manager]Data source name not found, and no default driver specified

The following is a complete ODBC program. All it does is attempt to open a connection to a SQLite database using a fully qualified connection string. The issue I'm having is that when Unicode is enabled (use SQLDriverConnectW() instead of…
user27930
  • 399
  • 1
  • 4
  • 14
6
votes
3 answers

Asterisk unable to connect to database using odbc connector

I am pretty new to Asterisk and this is my first attempt to connect to database (MySQL). But I keep getting this error [unixODBC][Driver Manager]Data source name not found, and no default driver specified. Here is my…
Paullo
  • 2,038
  • 4
  • 25
  • 50
1 2
3
41 42