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
84
votes
7 answers

Apt-get is broken after install Google Cloud SDK on Ubuntu 18.04 LTS

I was installing the Google Cloud SDK on my Ubuntu VM using the following commands # Add the Cloud SDK distribution URI as a package source echo "deb [signed-by=/usr/share/keyrings/cloud.google.gpg] http://packages.cloud.google.com/apt cloud-sdk…
Vinay Joseph
  • 5,515
  • 10
  • 54
  • 94
59
votes
10 answers

"Adaptive Server is unavailable or does not exist" error connecting to SQL Server from PHP

I'm attempting to connect to a SQL Server 2005 DB from my Mac using unixODBC and FreeTDS as I have outlined here. However, when I try to connect in to a different DB using the same setup, I get: Connection Failed:[FreeTDS][SQL Server]Unable to…
wonder95
  • 3,825
  • 8
  • 45
  • 74
49
votes
6 answers

Pyodbc - "Data source name not found, and no default driver specified"

I have trouble getting pyodbc work. I have unixodbc , unixodbc-dev, odbc-postgresql, pyodbc packages installed on my Linux Mint 14. I am losing hope to find solution on my own, any help appreciated. See details below: Running: >>> import pyodbc >>>…
user1841829
36
votes
2 answers

What are the functional differences between iODBC and unixODBC?

There are two major Open Source platform independent implementation of the ODBC. It is iODBC and unixODBC. Considering Unix as ODBC user platform and feature-wise, what are the real practical differences between these two implementations?
mloskot
  • 37,086
  • 11
  • 109
  • 136
27
votes
3 answers

[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/easysoft/oracle/InstantClient112/lib/libsqora.so' : file not found

I am trying to acces oracle from linux server. I am using unixODBC. When i try to acces oracle using isql and i get error that driver manager can't open libsqora.so.12.1. odbc.ini [NAME] Application Attributes = T Attributes = W …
user3521305
  • 391
  • 1
  • 4
  • 6
27
votes
1 answer

sql.h header file missing though unixODBC is installed

I am on an up-to-date Ubuntu 12.04 system. I have unixodbc (v2.2.14 from ubuntu repos), MySQL and its relevant drivers installed. Also connected to a valid DSN. Verified by issuing isql DBName UName passwd. I am trying to compile a C application…
Richard
  • 528
  • 1
  • 5
  • 15
26
votes
8 answers

PyODBC : can't open the driver even if it exists

I'm new to the linux world and I want to query a Microsoft SQL Server from Python. I used it on Windows and it was perfectly fine but in Linux it's quite painful. After some hours, I finally succeed to install the Microsoft ODBC driver on Linux Mint…
Joseph Yourine
  • 1,301
  • 1
  • 8
  • 18
25
votes
3 answers

How to install freetds in Linux?

I am trying to connect to MSSQL server from Ubuntu. I have installed freetds like suggested here. However, when I try to configure /etc/odbc.ini and enter a driver path I have no driver at location /usr/local/freetds/lib/libtdsodbc.so. Can someone…
Hrvoje T
  • 3,365
  • 4
  • 28
  • 41
21
votes
3 answers

Install ODBC driver in Alpine Linux Docker Container

I currently have the following Dockerfile to create my Docker image. FROM python:3.6.6-alpine3.8 # Add dependencies for Python packages pandas, numpy and pyodbc RUN apk add --no-cache curl gcc g++ unixodbc-dev RUN ln -s /usr/include/locale.h…
Alexis.Rolland
  • 5,724
  • 6
  • 50
  • 77
17
votes
4 answers

RODBC not recognizing my odbc settings

I'm running R 2.15.2 on a Red Hat Linux 6 server. My goal is to connect to a MS SQL Server Database on another machine via RODBC. I did my research and downloaded and installed the linux version of the MS SQL ODBC driver from the microsoft support…
vergilcw
  • 2,093
  • 4
  • 16
  • 20
16
votes
3 answers

pyodbc/FreeTDS/unixODBC on Debian Linux: issues with TDS Version

I'm having a bit of trouble successfully using pyodbc on Debian Lenny (5.0.7). Specifically, I appear to be having trouble fetching NVARCHAR values (not a SQL Server expert, so go easy on me :) ). Most traditional queries work OK. For instance, a…
tcdyl
  • 325
  • 2
  • 13
13
votes
1 answer

Ruby connecting to SQL Server

I'm having troubles connecting Ruby to Microsoft SQL Server. I'm running Mac OS X, but the target environment is Ubuntu Linux. Here's what I've tried: Install unixODBC Install FreeTDS used the options --with-unixodbc=/usr/local/etc…
Ben Scheirman
  • 40,531
  • 21
  • 102
  • 137
12
votes
2 answers

Connect MySQL 3.23 with pyodbc 3.07

I'm trying to connect to an old MySQL 3.23 server from an Ubuntu 16 client with UnixODBC and pyodbc 3.07. I've tried three (3) versions of MySQL Connector/ODBC and two (2) from MariaDB: MySQL-ODBC 5.3.9 Supports only the new mysql authentication…
jhinghaus
  • 770
  • 10
  • 27
11
votes
9 answers

Using Azure SQL Services from a Mac?

Azure SQL Services looks pretty cool, and I'd like to use it as a hosted database. I set myself up with a starter web edition database, and after clicking through a million and five EULAs, I got to a console and created a database. It gave me a…
Erik Paulson
  • 111
  • 1
  • 1
  • 3
11
votes
4 answers

How to fix the [unixODBC][Driver Manager]Data source name not found, and no default driver specified (ODBC::Error)

/local/rvm/gems/ruby-1.9.2-p320/gems/activerecord-sqlserver-adapter-3.2.12/lib/active_record/connection_adapters/sqlserver_adapter.rb:455:in `initialize': IM002 (0) [unixODBC][Driver Manager]Data source name not found, and no default driver…
Clone
  • 919
  • 4
  • 11
  • 22
1
2 3
…
41 42