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

Return IDs of inserted values PDO to MSSQL using ODBC

I need to get an array of id's of the subscribers added to the database within this function: function insert_test($pdo, $fullname, $email) { if ($SQL = $pdo->prepare("INSERT INTO subscribers ([dateAdded],[dateUpdated],[fullname],[email],[isActive])…
LewisJWright
  • 362
  • 1
  • 2
  • 14
0
votes
1 answer

How to make C application with unixodbc on Ubuntu

I just want to run a test program using ODBC calls on Ubuntu but can't find any information on what includes to use or how to link. Is there a sample makefile? I've used ODBC on Windows with no problem. Also unixodbc documentation refers to…
user2980139
  • 65
  • 1
  • 7
0
votes
2 answers

Unable to insert unicode characters through freetds unixODBC in MS SQL 2008

I have a c++ application built on RHEL 5 that connects to MS SQL 2008 through freeTDS and unixODBC situated on a windows machine. This is the query the application sends to the database. INSERT INTO mytable (SAMPLE) VALUES(N'乕乭乺丕') Um@D@Iz is…
D3XT3R
  • 181
  • 2
  • 15
0
votes
1 answer

Add php odbc extension on Mac OS with unixODBC

I compiled the odbc extension for PHP with unixODBC on my mac. But on phpinfo, it shows like below: Which should be: Does anyone can help with it? PHP version: 7.0.2
CunruiLi
  • 483
  • 1
  • 6
  • 16
0
votes
1 answer

unixODBC and DB2 ODBC connection issue on Ubuntu

I went through the tutorial on unixODBC.org website for DB2 connections and I can't successfully get the connection to succeed with isql. Think I’m getting stuck on the configuration of odbc.ini vs odbcinst.ini and vs db2cli.ini I installed the…
mkweick
  • 25
  • 6
0
votes
3 answers

Can't create a database link for CMS WebGUI

I've updated the whole scenario (last one was a conflict between i686 and x64 libraries) Now I have an VPS with a fresh CentOS 6.6 32 bit with unixODBC, FreeTDS and WebGUI installed I can connect perfectly with SQL Server 2008 through isql and perl…
Flacid_Snake
  • 391
  • 2
  • 5
  • 16
0
votes
1 answer

unixODBC works but Apache will not connect

I am trying to setup apache to connect to a Microsoft SQL server for authentication. This is not ideal but this legacy system has the credentials in MSSQL and that can not change. I have unixODBC setup and working **odbcinst.ini** [SQL Server Native…
ci_ms
  • 65
  • 1
  • 8
0
votes
1 answer

yum install php5-sybase. "No Package Available"

I try to connect mssql in centos, so I need odbc freetds,unixodbc I have all I need to install dblib at last, I type "yum install php5-sysbase" command in terminal and here is the response: how can I install php5-sybase ?
user4005632
0
votes
1 answer

Should I use a seperate ODBC environment for multiple connections?

I need to open connection to system DB and then internally open connection for tenant DB. Currently i have implemented having different environment handle for each connection. Connecting to system DB, retCode = SQLAllocConnect(sqlEnvHandle ,…
PU.
  • 148
  • 9
0
votes
1 answer

Shiny Server cannot use RODBC to connect to DB2 but RStudio can in a Docker Container

I am working on deploying a shiny application in a Docker container onto Bluemix. I am using the rocker/shiny Docker image (https://hub.docker.com/r/rocker/shiny/) as my initial starting point. I have installed unixODBC-dev, RODBC, ibm data server…
Randy
  • 1
  • 2
0
votes
0 answers

Ubuntu 14.04 Codeigniter ODBC Connection to Sybase SQL Anywhere 9

I create an application with CodeIgniter2.3 Framework and it need to connect to Sybase SQL Anywhere 9 on Windows Server. I have already create ODBC in the Windows Server so the web application can use it. When the I put the web application on Apache…
0
votes
1 answer

Problem with MySQL driver for unixODBC on Debian Lenny

On OpenSuse 11.2, I successfully compiled, linked, and ran the following code which installs a data source for a MySQL database with unixODBC: #include #include #include #include /* Add a data source for…
alex_msk
  • 1
  • 2
0
votes
1 answer

Connecting to MonetDB using ODBC

I have tried using unixODBC (version 2.3.2) and the MonetDB ODBC client (version 11.21.5) on both Mac OS X 10.9 and Debian 8, but cannot connect through ODBC using isql on client machines to a MonetDB server running on Debian 8, although it works…
Endre
  • 690
  • 8
  • 15
0
votes
0 answers

How to configure Oracle odbc connection on RHEL 5.?

Can anyone please help me in configuring Oracle ODBC drivers on RHEL? I have gone through some websites, but I am unable to sort it out. Please give some elaborated answers, I am bit new to LINUX. For now I have installed unixODBC and freeTDS on my…
Santhosh
  • 21
  • 1
  • 8
0
votes
1 answer

FreeTDS not respecting freetds.conf and odbc.ini

I have a problem, FreeTDS keep connecting using version 4.2 even if I set to 8.0 in these settings I CAN connect using tsql, and when I use tsql it show me it is using 7.1 (alias from 8.0), but my apache2 application keep using 4.2 Where can it be…
TLPNull
  • 475
  • 4
  • 12