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

Connecting to MS SQL server from Mac OS 10.7 through python

I'm on Mac OS 10.7.5 . I want to connect to an MS SQL db from python2.7. To connect, I've installed and configured FreeTDS and unixodbc. After these, I've installed pyodbc 3.0.10 library through pip. In the previous versions, pyodbc on Mac…
Ozgur Akcali
  • 5,264
  • 2
  • 31
  • 49
0
votes
1 answer

JDBC-to-ODBC Bridge for Cassandra on Ubuntu

I want to create JDBC-to-ODBC Bridge on Ubuntu, and then want to access in Java. I installed unixODBC and Cassandra ODBC driver and set DSN in odbc.ini file and Driver in odbcinst.ini file and as well as also export both file and and…
Mahendra Singh
  • 28
  • 3
0
votes
1 answer

How to get the driver version using ODBC API without connecting to the database?

We have code to connect to various databases and we get the driver version after connecting using the SQLGetInfo() call with the parameter SQL_DRIVER_VER. However, we want the driver version in other cases too, e.g., before connecting, and in case…
user2237963
  • 103
  • 7
0
votes
2 answers

ODBC with FreeTDS PHP Not working via HTTP

I have got FreeTDS, unixODBC and ODBC enabled on PHP. It all seems to work great. I could connect via iSQL command line. For some reason PHP is not able to work when accessed via HTTP. For example. via command line if I run php index.php (where…
Shoogle
  • 206
  • 1
  • 13
0
votes
2 answers

Upgraded activerecord-sqlserver-adapter from 2.2.22 to 2.3.8 and now getting an ODBC error

I have been using MSSQL 2005 with Rails for quite a while now, and decided to bump my gems up on one of my projects and ran into a problem. I moved from 2.2.22 to 2.3.8 (latest as of writing) and all of a sudden I got this: ODBC::Error: S1090 (0)…
stuartc
  • 2,244
  • 2
  • 24
  • 31
0
votes
1 answer

Is it possible to use Netezza ODBC driver on Ubuntu?

The Netezza ODBC Drivers are officially supported on SUSE and RedHat. I'm trying to get the driver to work on Ubuntu 14.04. I've been testing the connection via: sudo isql -v NZSQL Which initially returned: [unixODBC]Error occurred while loading…
NAD
  • 615
  • 1
  • 7
  • 20
0
votes
1 answer

Large select query hangs using Python and unixODBC connecting to SQL Server

We have to run a number of large select queries against SQL Server from CentOS 6 boxes. On two servers, when using a pretty bland select statement, the rate of data returned from SQL Server starts fast before slowing down and receiving bursts of…
Jjensen.mike
  • 55
  • 1
  • 1
  • 5
0
votes
1 answer

Asterisk CDR reports to MSSQL

I am supposed to be implementing a backend Microsoft SQL connection from our Asterisk SIP server for CDR reports. Disclosure: I am a rookie with Asterisk, I am unfamiliar how it was originally setup, and I have limited experience in a Linux(CentOS)…
ShaneC
  • 27
  • 1
  • 8
0
votes
1 answer

pyodbc.connect to FreeTDS connection requires explicit PORT=1433;

I have a python script running on python 2.7 in CentOS 2.6 that connects to a Sql erver database: pyodbc.connect("DRIVER=FreeTDS;SERVER=someServer;DATABASE=someDb;UID=myUser;PWD=superSecret;CHARSET=UTF8;TDS_Version=7.2") That call will fail with…
Justin Dearing
  • 14,270
  • 22
  • 88
  • 161
0
votes
0 answers

SQL UPDATE does not affect any row via django-pyodbc

I have django-pyodbc installed for Python 2.7 (Ubuntu 14.04, unixODBC, FreeTDS) and I am attempting to update a SQL Server database that I created as a test. Everything works well except one particular UPDATE statement that does not affect any row.…
Patrick
  • 2,577
  • 6
  • 30
  • 53
0
votes
0 answers

How to access unix odbc in apache server

I am using ubuntu server 14 .I already installed freetds,unixodbc and pyodbc,if I run python program in my home folder means I can access mssql database ,same coding not working in apache server ,php file also can't connect access to database .So…
Nandha Kumar
  • 413
  • 8
  • 18
0
votes
1 answer

(Libre Office / Base Database) always tries to connect ODBC using iODBC, not unixODBC on Mac OSX 10.10

I am using Libre Office Version: 4.3.4.1 on my Mac OSX 10.10 Yosemite. In Base Database, I would like to connect MS-SQL server using unixODBC DSN. But it seems the Libre Office tries to connect via iODBC, not unixODBC. (I never installed iODBC on my…
user1350338
  • 97
  • 2
  • 6
0
votes
1 answer

Getting error while connecting to database with freetds and odbc connection

Database settings DATABASES= { 'default': { 'ENGINE': 'sql_server.pyodbc', #'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), #'ENGINE': 'django.db.backends.sqlite3', 'NAME': 's', 'USER': 'test', 'PASSWORD': 'test', …
the-run
  • 977
  • 1
  • 10
  • 21
0
votes
1 answer

isql exception unixODBC data source name not found

I am trying to connect my php application with SQL server in my Linux box. I installed unixODBC successfully and made required changes in odbc.ini and odbcinst.ini file. When I run command.
sqlcmd -S DSN -U USERNAME -P Password I am able…
Shrikant
  • 21
  • 4
0
votes
0 answers

Select number between 0 and 1 MDB

I am using mdbtools to connect to a mdb-file and retrieve some data from a table in the mdbfile. In the table there is a field which contains values like 0.17, 0.25, 0.17, 0.50, 0.75 I see these numbers when looking at the db with MDB Explorer on…
lshas
  • 1,691
  • 1
  • 19
  • 39
1 2 3
…
41 42