Stack Overflow
Stack Overflow

Questions tagged [iodbc]

iODBC is an LGPL/BSD dual-licensed open source project that implements the ODBC API on non-Windows platforms.

iODBC is an LGPL/BSD dual-licensed open source project that implements the ODBC API on non-Windows platforms.

25 questions
36
votes
2 answers

What are the functional differences between iODBC and unixODBC?

There are two major Open Source platform independent implementation of the ODBC. It is iODBC and unixODBC. Considering Unix as ODBC user platform and feature-wise, what are the real practical differences between these two implementations?
mloskot
  • 37,086
  • 11
  • 109
  • 136
9
votes
1 answer

Connecting to MS SQL Server with iODBC on Mac

I'm trying to connect to a Microsoft SQL Server from my Mac development machine using iODBC. No matter what I do, I get the error message Unable to connect to data source from the FreeTDS driver. After consulting various manuals, blog posts, and…
josePhoenix
  • 538
  • 1
  • 5
  • 14
6
votes
2 answers

macOS Connector/MySQL ODBC driver could not be loaded in Excel for Mac 2016

I am working with Excel for Mac Version 16.18 on High Sierra 10.13.6. Installed Connector/ODBC 8.0.12 for macOS, tested the connection to my database with iODBC Data Source Administration (64-Bit) and worked: When I try connecting with Excel with…
M Garcia
  • 331
  • 3
  • 14
4
votes
1 answer

configuring iodbc to use FreeTDS for MS SQL Server under cygwin

I'm trying to use RODBC to make a connection to a SQL Server database from R under cygwin. I've installed libiobbc and libiodbc-devel, which I understand provide the driver manager that the RODBC package needs. I installed freetds, which I…
mac
  • 3,137
  • 1
  • 28
  • 42
3
votes
3 answers

unixodbc and freetds setup on OSX and Rails 2.3.x

I'm trying to set up unixodbc on OSX (10.7.3), but it looks like iODBC is on the way. My config/database.yml: development: adapter: sqlserver encoding: UTF8 mode: odbc username: user password: passwd dsn: MY_DSN ruby-obdc is installed…
Pedro Nascimento
  • 13,136
  • 4
  • 36
  • 64
2
votes
1 answer

MySQL ODBC 8.0 Unicode Driver Connection Error [H000]

I am unable to connect to MySQL ODBC 8.0 Unicode Driver with unixODBC as underlying driver running on Mac OS. I am using pyodbc package on python 3.6. Everything works when I use the ANSI driver but the Unicode Driver is not working. Here are the…
Amsal N
  • 201
  • 2
  • 10
2
votes
2 answers

Building OTP 18.3 on OS X 10.9 "ODBC library - header check failed"

So I'm trying to build Erlang/OTP 18.3 on OS X 10.9 Mavericks, and seem to be running into a problem where odbc libraries/headers aren't being found. The first time I tried running configure I got the…
Weston C
  • 3,642
  • 2
  • 25
  • 31
2
votes
0 answers

Connecting to MS SQL Server from MAC application with FreeTDS fails

I'm trying to connect to Microsoft SQL Server from my Mac application using iODBC and FreeTDS. No matter what I do, I get the error message Unable to connect to data source from the FreeTDS driver. i have consulted as many possible manuals, blog…
OzWin
  • 21
  • 2
2
votes
2 answers

Can't connect to HyperFileSQL using php with odbc

I have a database with HyperFileSQL and I want to access this database via php. If I use IODBC to connect with iodbc.ini, it works !!! But when I want to connect from php with odbc it doesn't I have this in return : SQLSTATE[0] SQLDriverConnect: 0…
nawfal
  • 21
  • 3
2
votes
2 answers

How does one determine if iODBC, unixODBC (or neither) are installed?

I'm on Ubuntu Linux and wondering how to detect what ODBC driver manager the system has, if any. Like Rakib's commentary, one very rough way I've used is to simply try and run isql (unixODBC) or iodbctest, because Ubuntu will report whether their…
Neil C. Obremski
  • 18,696
  • 24
  • 83
  • 112
1
vote
1 answer

MySQL ODBC Connection with SSL on Ubuntu

I'm trying to make and ODBC connection on my server that requires ssl. Here is my odbc.ini RemoteConn= MySQL Unicode [RemoteConn] Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so Description = RemoteConn Connection SERVER = the…
Kelveen
  • 90
  • 7
1
vote
1 answer

myodbc-installer lists data sources, but iodbctest shows no DSNs

I was following the instructions for registering a driver and data source given here: "Installing Connector/ODBC from a Binary Tarball Distribution" After realizing I had to use sudo when running myodbc-installer, I could successfully get the driver…
HostileFork says dont trust SE
  • 32,904
  • 11
  • 98
  • 167
1
vote
1 answer

how to install RODBC on macOS Sierra 10.12.4

In R 3.4.0, install.packages('RODBC', type='source') fails on macOS 10.12.4. I also downloaded RODBC_1.3-15.tar.gz from CRAN and tried, R CMD INSTALL RODBC_1.3-15.tar.gz In both cases, I got "ODBC headers sql.h and sqlext.h not found". A…
Spencer Graves
  • 91
  • 5
1
vote
1 answer

How to loaded odbc with the build-in apache and php5.5 on MacOsX (el Capitan)

I'm currently trying to run (i)odbc through the php extension. I have searched during these three last days and I have no clue how to config the build-in php5.5 of MacOsx to load the odbc extension. I got no problem to connect to odbc but just to…
Cyril
  • 485
  • 4
  • 15
1
vote
1 answer

FreeTDS configuration on MacOS without .so files

Can anyone point me to how to setup an ODBC connection to a MS SQL Server using FreeTDS? All of the posts and items I found on the web so far require the .so file which is no longer generated (or required) when installing FreeTDS according to its…
Andre Guerra
  • 1,117
  • 1
  • 9
  • 18
1
2