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

Can't connect to SQL Server using isql on Mac OS X

I have installed freetds using Homebrew. My configuration is as follows: odbcinst -j: unixODBC 2.3.1 DRIVERS............: /usr/local/Cellar/unixodbc/2.3.1/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/Cellar/unixodbc/2.3.1/etc/odbc.ini FILE DATA…
Mark Richman
  • 28,948
  • 25
  • 99
  • 159
0
votes
1 answer

CakePHP and connecting to MS Access db using Unixodbc

I'm trying to use an Acces (MDB) database from a CakePHP app. On a Windows machine this works fine. On a Linux machine using Unixodbc this doesn't work at all. The error is as follows: Warning (2): odbc_connect() [function.odbc-connect]: SQL error:…
Bram
  • 110
  • 9
0
votes
0 answers

Call to undefined function odbc_connect()

This is my first time using the php function odbc_connect(), I mostly work with php/mysql. The issue I am having is the function does not work. I have been reading up on the issue and the only resolution I can come up with is that either through…
powpow12
  • 587
  • 8
  • 13
0
votes
2 answers

UnixODBC driver support in OSX?

I'm working on a Rails application which I've set up locally on my OSX Machine. However, the app, which typically runs on a Linux box, connects to a proprietary database via unixODBC. The database manufacturer only provides drivers for Linux and…
henry
  • 1,716
  • 3
  • 15
  • 27
0
votes
3 answers

How to get the values of oracle database parameters from a unix development server?

How to get the fallowing details from the unix development server? The below parameter values should be provided in the .dbc file and it should be mapped to the ETL Server . dbms:
db_version:
db_home:
db_name:
db_nodes:…
Srihari
  • 2,509
  • 5
  • 30
  • 34
0
votes
1 answer

Importing .dylib or .la files into iOS project

After reading this awesome post by Tristan, where he compiled FreeTDS for use in iOS, I attempted to compile UnixODBC for use in iOS. I was able to get it to compile, which is great. However, when I compiled FreeTDS, I had a .a file that I was able…
Rob
  • 1,025
  • 2
  • 10
  • 27
0
votes
1 answer

UnixODBC Multiple data-sources not working

I use unixODBC to connect to mssql databases via odbc. The problem is that regardless how many data sources I add in odbc.ini, it always uses the first database in the list.. odbcinst.ini [ODBC] Trace = Yes TraceFile =…
user1934017
  • 3
  • 2
0
votes
3 answers

BASH sh scriptin

I want to start BASH shell scripting but my computer run on Windows 7 (64 bit). Is there a way to download UNIX without having to change my operating system. How do I go abobut downloading UNIX. Thanks
Chris Olszewski
  • 153
  • 2
  • 8
0
votes
2 answers

How do I specify a database name with a hyphen in unixODBC?

I have a SQL Server database named pm-eng that I need to connect to from a linux box. I've setup unixODBC and configured my odbc.ini as follows: [pm_production] Driver = FreeTDS Server = mssql.server Database = pm-eng When I test with iSQL,…
Scott Stevenson
  • 90
  • 8
0
votes
3 answers

Simplest way to access a DB2 database on iSeries from a Linux (ubuntu) machine?

I would like to run an SQL query on an iSeries (...or "System i" or "AS/400"...) machine as part of a Nagios check, but haven't found a suitable way of interfacing the database yet. IBM suggests using the ODBC driver of System i Access for Linux…
Anders Lindahl
  • 41,582
  • 9
  • 89
  • 93
0
votes
1 answer

eclipse odbc Could not find symbol in index

When I try to click ODBC functions (like, SQLExecDirectW, SQLBindCol and so on), I get the below message. I am currently using Eclipse on Ubuntu. Example: Could not find symbol 'SQLExecDirectW' in index. Can you please let me know how do I…
Pintu
  • 369
  • 2
  • 6
  • 18
0
votes
1 answer

Can root privileges broke the SQLDriverConnect (working as normal user)?

I am getting a strange behaviour by Oracle ODBC driver under linux (unixODBC). I have a program connecting to a database that, when called by an unprivileged user, works as expected while if called with root privileges (tested with both sudo and su)…
a1an
  • 3,526
  • 5
  • 37
  • 57
0
votes
1 answer

pyodbc: .mdb connection error on ubuntu

I am trying to access a .mdb file which located on my system. My Code look slike this : import csv import pyodbc MDB = '/home/filebug/client/my.mdb' DRV = '{Microsoft Access Driver (*.mdb)}' PWD = 'mypassword' conn =…
ifixthat
  • 6,137
  • 5
  • 25
  • 42
0
votes
4 answers

Why unixODBC SQLTables is always returning an SQLRowCount of 4294967295?

With the following code I always got that value on Oracle databases SQLHSTMT hStmt = SQL_NULL_HANDLE; SQLRETURN sret; SQLLEN rowCount = 0; const SQLHDBC conn = this->getConnection(); if (conn == NULL) { ret =…
a1an
  • 3,526
  • 5
  • 37
  • 57
-1
votes
0 answers

Cannot import PYODBC on MacBook PRO

when i try to run this: import pyodbc i get this output: Traceback (most recent call last): File "/...projects/roof/testDF.py", line 1, in import pyodbc ImportError:…
Fernando Trujillo
  • 23
  • 5
1 2 3
…
41
42