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
11
votes
2 answers

Go/Golang sql.DB reuse in functions

sql.Open() returns a variable of type *sql.DB I have a function that calls 10 other functions that all need to make database calls Is it more correct/efficient to: Send the *sql.DB pointer to every function, or Create a new *sql.DB object in each…
Allison A
  • 5,575
  • 6
  • 28
  • 32
11
votes
1 answer

How to set a DB connection timeout for a python/pyodbc/unixODBC/MS ODBC Driver 11 for SQL Server/Linux stack?

I've been unable to find a documented way to set a timeout for the initial connection that actually works. I'm not asking about a "query timeout", but rather a timeout on an initial connection attempt in the case that the DB server is completely…
mikenerone
  • 1,937
  • 3
  • 15
  • 19
10
votes
4 answers

unixODBC giving error while running isql [Vertica]

Hi I have configured the DSN settings for vertica in Ubuntu 10.10 32 bit version machine. The settings are all fine and I have cross checked them. Here is my odbc.ini file: [VerticaDSN] Description = VerticaDSN ODBC driver Driver =…
Arun Shyam
  • 559
  • 2
  • 8
  • 20
10
votes
2 answers

Difference between FreeTDS and unixodbc?

I'm trying to work out how these two pieces of the jigsaw interact and fit together when connecting to an MS-SQL server on linux. As I understand it, FreeTDS is protocol (i.e. a set of rules) for talking to MS-SQL and it is the thing that actually…
fpghost
  • 2,834
  • 4
  • 32
  • 61
10
votes
2 answers

FREETDS and UNIXODBC character converting

ive got an error to fix. its: [FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted when i use turkish characters to insert i get this error. my question is how can i disable that…
Ali Demirci
  • 5,302
  • 7
  • 39
  • 66
10
votes
1 answer

Having Troubles with UnixODBC, FreeTDS, and PyODBC

I am having great difficulty getting all three of these to work together in harmony. I guess I'll list all the various configurations, along with the test code to see if a pair of fresh eyes can realize my stupidity. I'm running 12.04 Ubuntu Server…
Anthony Tantillo
  • 300
  • 1
  • 3
  • 12
9
votes
2 answers

ODBC Driver 17 for SQL Server on apple M1

I am trying to get ODBC Driver 17 for SQL Server to work but somehow it doesn't on my brand new apple M1. Apparently I got unixodbc installed and also the driver, but starting them doesn't work. Looks like the odbc driver is not yet ready for the…
nico525
  • 137
  • 1
  • 8
9
votes
5 answers

Connecting to MS SQL Server using python on linux with 'Windows Credentials'

Is there any way to connect to an MS SQL Server database with python on linux using Windows Domain Credentials? I can connect perfectly fine from my windows machine using Windows Credentials, but attempting to do the same from a linux python with…
Samer Atiani
  • 695
  • 1
  • 6
  • 8
9
votes
3 answers

Connecting to SQL Server named instance from Linux using pyodbc

I'm currently trying to connect to a SQL Server (that I don't have visibility into, but have credentials for) using PyODBC. The code that I have works on my Windows desktop, but does not work when moved onto my RedHat Linux machine. I need it on…
sdberts
  • 85
  • 1
  • 1
  • 3
9
votes
3 answers

Installation failed trying to install MySQL ODBC connector on macOS High Sierra

I'm trying to install this mysql odbc connector on my macOS High Sierra machine, but I get this error: I tried installing it using installer in the hopes of getting information about what went wrong: ➜ ~ sudo installer -pkg…
L42
  • 3,052
  • 4
  • 28
  • 49
9
votes
2 answers

Pyodbc installation error on Ubuntu 16.04 with Sql Server installed

I am trying to test my scripts for data migration from mssql-server to oracle server. For this, I have to install pyodbc python package for Ubuntu, it has the dependency of unixodbc. When I try to install unixodbc-dev using: sudo apt-get install…
Shubham Namdeo
  • 1,845
  • 2
  • 24
  • 40
9
votes
2 answers

Installing ruby-odbc gem on mac os x 10.9 in RVM

I'm trying to get the ruby-odbc gem installed on a Mac OS X 10.9 under ruby-1.9.3-p547 for use with a rails 2.3.12 application which connects to a SAP system over ODBC. Environment Mac OS X 10.9 (Mavericks) RVM with ruby 1.9.3 and other rubies…
Grant Sayer
  • 2,330
  • 1
  • 23
  • 34
8
votes
4 answers

FreeTDS - Unable to connect: Adaptive Server is unavailable or does not exist

CENTOS 6.5 x86_64 WHM 11.42.1 unixODBC 2.2.14 freetds v0.91 I'm trying to connect to remote MSSQL server without success - also tried connecting with different tds versions (4.2, 7.0, 7.1, 8.0) but all give the same result. Using the same…
user247497
  • 81
  • 1
  • 1
  • 2
8
votes
3 answers

odbc unable to connect to MSSQL data source on OS X Lion

odbc isql was unable to connect to data source: $ isql SMS_GTWY username password -v returns: [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source [01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name. [ISQL]ERROR:…
ohho
  • 50,879
  • 75
  • 256
  • 383
8
votes
3 answers

Microsoft ODBC driver for Linux vs FreeTDS?

I am investigating the possibilities to connect to a MSSQL database from a RHEL6 application server. I have found two ways: FreeTDS Microsoft SQL Server ODBC Driver for Linux + unixODBC Does anyone have experience in using either of these setups?…
Krumelur
  • 31,081
  • 7
  • 77
  • 119
1
2
3
…
41 42