Stack Overflow
Stack Overflow

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
4
votes
0 answers

Qt unixODBC FreeTDS

I want to establish ODBC connection between Linux client and MSSQL Server. I have installed unixODBC and FreeTDS, and tested isql and tsql both working fine and I am able to establish connection (this ensures proper connection establishment between…
Kanni1303
  • 73
  • 11
4
votes
1 answer

connecting to DB2 database:[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

odbc.ini: [DEFAULT] Driver = DB2 [abc] Driver = DB2 [dsn_test1] DESCRIPTION = Connection to DB2 Driver = db2 odbcinst.ini: [DB2] Description = DB2 Driver Driver =…
Anand
  • 621
  • 3
  • 9
  • 31
4
votes
1 answer

Pyodbc connection error but isql works

I've been round and round on this for hours. I can't connect to a database via pyodbc, but I can use both tsql and isql to connect. I'm now simply trying (which is probably wrong, but illustrates my point): import…
bryan
  • 1,031
  • 2
  • 17
  • 36
4
votes
2 answers

MySQL : C++ Connector vs ODBC

I'm planning to start a web based project and i'm planning on MySQL as Database back-end. My Server side programming language is C++. I have used unixodbc before. Since i'm starting on a new project, i wanted to check if its good to continue with…
Manikandaraj Srinivasan
  • 3,557
  • 5
  • 35
  • 62
4
votes
1 answer

How to Configure Microsoft® ODBC Driver 11 for SQL Server® on RedHat Linux with PHP

This is about how to install Microsoft® ODBC Driver 11 for SQL Server® on RedHat Linux with PHP
Sri
  • 496
  • 1
  • 5
  • 20
4
votes
1 answer

unixODBC + mdbTools + PHP

I need to connect a PHP script in a LAMP (Linux Ubuntu 12.10, Apache 2, MySQL 5, PHP 5.3) server to an Access MDB database (version 2003). 1. unixODBC and Driver installation The Ubuntu 12.10 comes with unixodbc 2.2.14 package…
Dimas
  • 331
  • 1
  • 5
  • 15
4
votes
4 answers

Failure to connect to SQl Server from Linux

I am trying to connect to SQL Server 2008 on CentOS 5.8. I am using unixODBC 2.3.0 and SQL Server ODBC Driver (www.microsoft.com/en-us/download/details.aspx?id=28160). When I try to test the connection by running: isql -v mydsn username password it…
kirylm
  • 101
  • 1
  • 1
  • 8
3
votes
3 answers

unixodbc and freetds setup on OSX and Rails 2.3.x

I'm trying to set up unixodbc on OSX (10.7.3), but it looks like iODBC is on the way. My config/database.yml: development: adapter: sqlserver encoding: UTF8 mode: odbc username: user password: passwd dsn: MY_DSN ruby-obdc is installed…
Pedro Nascimento
  • 13,136
  • 4
  • 36
  • 64
3
votes
2 answers

Microsoft SQL Server Statistics via ODBC

I have an instance of SQL Server that I am trying to benchmark. From the SQL Studio application I can type SET STATISTICS TIME ON and see outputted statistics after that. From C++ code, I can do something like SQLExecDirect(hstmt, "SET STATISTICS…
Steven Canfield
  • 7,312
  • 5
  • 35
  • 28
3
votes
0 answers

Read MS Access JET 4 database (.mdb) using python and unixODBC on Ubuntu 11.10: getting bad values

I'm having some problems trying to read a Microsoft Access database (JET 4 .mdb) using Python 2.7.2 (unixODBC 2.2.14, pyodbc 2.1.11 and the mdbtools driver) on Ubuntu 11.10 32-bit. Yes, I know it is horrible idea, but oddly enough it is the easiest…
rhkarls
  • 196
  • 3
  • 13
3
votes
3 answers

Using alternate unixODBC installation

I'm working in an environment that has unixODBC installed on a org-wide centrally mounted drive, but we (the actual developers) aren't allowed to install drivers or datasources in it. It's all backwards but I have to live with it. Right now I'm…
matrix10657
  • 503
  • 4
  • 10
3
votes
0 answers

Docker container ODBC connection to external Vertica database with Amazon lambda

I am trying to connect to Vertica DB from my Serverless ASP.NET Core API (with Amazon Lambda). To do this, I build a docker container to install the ODBC driver along with creating my lambda function. The docker image successfully is built and…
user2266688
  • 47
  • 3
3
votes
1 answer

[unixODBC][Driver Manager] Can't open lib '/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib' : file not found

I am trying to get a Cloudera Impala ODBC running on a brand new M1 Mac. To do so, I installed MS ODBC 18 via the official MS documentation and also followed the Cloudera ODBC Connector Install Guide. However, when trying to connect, I get following…
Norman
  • 785
  • 7
  • 27
3
votes
0 answers

Not able to install Microsoft ODBC driver in Docker

I am trying to build a Docker image with the Microsoft ODBC driver installed following this tutorial. This used to work for me, but not anymore. I receive this error message: E: Failed to fetch…
jfn
  • 2,486
  • 1
  • 13
  • 14
3
votes
0 answers

How to Access .mdb Data Source in PHP Linux?

I just installed unixODBC in order to access my .mdb data source on PHP.5.3 CentOS 6.10 using this commands: # yum install unixODBC In Windows i could simply uncomment extension=php_pdo_odbc.dll on php.ini and restart Httpd / Apache in order to…
Dont Bullying Me
  • 89
  • 1
  • 9
1 2 3
…
41 42