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
6
votes
1 answer

RODBC with MAC not working. Using unixODBC and Rstudio

I followed this guide http://eriqande.github.io/2014/12/19/setting-up-rodbc.html to get RODBC working with MAC and I am able to connect to the DB. Marcos-MacBook-Pro:~ MarcoB$ isql -v ODBC_SQLSS_R **** ****** …
Marco Blume
  • 97
  • 5
6
votes
3 answers

Python - Linux - Connecting to MS SQL with Windows Credentials - FreeTDS+UnixODBC + pyodbc or pymssql

There doesn't seem to be any great instructions for setting this up. Does anyone have any good instructions? I am a linux noob so be gentle. I did see another post that is similar, but no real answer. I have a couple of problems. FreeTDS…
Keith P
  • 2,150
  • 1
  • 18
  • 15
6
votes
0 answers

Connect to MS SQL database using freetds, unixodbc and python

I'm running Ubuntu 12.04 on a 32-bit computer, and I want to connect to my MS SQL database using freetds, unixodbc and python, but I'm getting an error: >>> import pyodbc >>> conn = pyodbc.connect('DSN=TS;UID=myusername;PWD=mypassword') Traceback…
Andrew
  • 1,000
  • 1
  • 17
  • 33
6
votes
3 answers

How do I configure pyodbc to correctly accept strings from SQL Server using freeTDS and unixODBC?

I can not get a valid string from an MSSQL server into python. I believe there is an encoding mismatch somewhere. I believe it is between the ODBC layer and python because I am able to get readable results in tsql and isql. What character encoding…
MatthewD
  • 309
  • 2
  • 8
6
votes
1 answer

unixODBC/Oracle: How do I specify all the datasource info in the connection string ONLY, and not in the odbc*.ini files

I want to connect to Oracle (11g) using unixODBC. I want the connection string ONLY to specify all the database/data-source information, and the ODBC INI files (/etc/odbc.ini and /etc/odbcinst.ini) to contain only generic driver info like where to…
e.dan
  • 7,275
  • 1
  • 26
  • 29
5
votes
2 answers

Connecting Redhat to SQL Server 2008 for Ruby on Rails

I'm trying to connect Redhat Linux to a Microsoft SQL Server 2008. I already had trouble setting it up on windows (my test machine) but now I need to deploy it on the Linux machine where it will be in production. So I've installed unixODBC and…
omarArroum
  • 255
  • 1
  • 8
  • 19
5
votes
0 answers

unixODBC Amazon Redshift issue (Can't open lib '/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so' : file not found)

I am trying to set up unixODBC to access Amazon Redshift and I keep getting this error, I have triple checked my setup but not sure what the issue is > isql -v mlaws [01000][unixODBC][Driver Manager]Can't open lib…
ppatel26
  • 183
  • 13
5
votes
1 answer

Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found - but file exists

I am trying to connect to an MSSQL server from a Jupyter notebook using pyodbc and unixODBC, under macOS 10.15.4. I have just upgraded OSX to Catalina and my previously working configuration has broken. I try to connect…
JohnM
  • 91
  • 1
  • 6
5
votes
1 answer

Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found

I am working in python. I am using Macbook for development and OS version is Catalina. I am trying to connect MSSQL Server with pyodbc. I installed SQL Drivers and its dependencies as well. But while connecting I am getting this error. Exception - …
karthik
  • 283
  • 2
  • 15
5
votes
2 answers

How to connect to SQL Server using FreeTDS ODBC

I am trying to connect to my company's SQL Server Databases via my MacBook and have followed the steps outlined here: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Mac-OSX but keep getting the following error when I get to…
ny_coder_dude
  • 71
  • 1
  • 2
  • 7
5
votes
0 answers

IM004 error when using unixodbc to connect to database (macos)

On my Mac I'm trying to connect to databases with unixodbc (v. 2.3.7 from Homebrew). odbcinst -j shows: DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..:…
Homer White
  • 733
  • 1
  • 5
  • 14
5
votes
2 answers

What is the correct value of ODBCDM_Home for unixodbc on ubuntu

I installed unixodbc and unixodbc-dev through apt-get. I then installed oracle instantclient (both the basic and the odbc drivers). Now I am trying to run odbc_update_ini.sh but none of the paths I have tried for the ODBCDM_Home argument seem to be…
semicolon
  • 2,530
  • 27
  • 37
5
votes
1 answer

Connecting to Microsoft SQL Server on ODBC using R in Ubuntu

I was able to get it completely working on Windows 7, but I have to move it to a Linux server. I'm running Ubuntu 16.04.1 LTS 64-bit in a VM right now for testing before I replicate the process on the server. I'm pretty sure the issue is somewhere…
user2990276
  • 307
  • 1
  • 2
  • 7
5
votes
0 answers

linux pyodbc freeTDS mssql server stopped working after some time

I have been successful in connecting to the sql server from and ubuntu machine using pyodbc/freeTDS The setup works fine, but for some time after which i am getting the following error [ERROR] (server)-('IM002', '[IM002] [unixODBC][Driver…
Syed Mohd Mohsin Akhtar
  • 451
  • 5
  • 20
5
votes
1 answer

Running npm install odbc in Sails app produces errors?

I am trying to install the node-odbc package (https://github.com/wankdanker/node-odbc) in my Sails app. As per the docs I have installed and configured unixobdc on the server but when I do npm install odbc --save in the app directory I get the…
Rambling-Monkey
  • 97
  • 6
1 2 3
…
41 42