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

How to connect to windows SQL Server from Ubuntu

For the past two days I have been trying to connect to a remote windows SQL server with no apparent success. I am trying to connect with python using the pyodbc package. I have tried following all the blog posts out there for that matter without…
LetsPlayYahtzee
  • 7,161
  • 12
  • 41
  • 65
5
votes
3 answers

RODBC Cannot allocate memory

Simple R script library(RODBC) odbChannel <- odbcConnect(dsn = "CTPRD03", uid = "BD_RPT_RO", pwd = "****") df.test <- sqlQuery(channel = odbChannel, query = "select * from DUAL;") df.test close(odbChannel) Produces the following…
klaasb01
  • 101
  • 1
  • 7
5
votes
1 answer

Configuration of pdo_odbc require files in /usr/local/ but there are no files

I'm trying to setup pdo_odbc on my online server. I use putty, and I have some basic knowledge in Linux commands. At a start, on my online server, I did not have PDO installed. I found the way to install it, and it works. Then I have to install…
Strahinja Krstic
  • 63
  • 2
  • 5
5
votes
3 answers

Unable to connect to remote mysql server using unixodbc, libmyodbc

I'm a little green at this, and I hope the issue I'm having is a simple one...edit: new information at bottom I need to make a connection to a remote mysql (Amazon RDS) database. After following a few tutorials, I have unixodbc and libmyodbc…
Pez
  • 1,251
  • 16
  • 32
4
votes
1 answer

Getting Error: TCP Provider: Error code 0x2746 while trying to install and use pyodbc on Ubuntu 20.04 for the first time

I wanted to remotely connect to a sql-server database on my network in python. So I the installed pyodbc following the steps given on this page. It instructs to first "Install the Microsoft ODBC Drivers for SQL-Server" by following these…
Siddhant Bane
  • 93
  • 3
  • 8
4
votes
2 answers

Rstudio via docker cannot read /etc/.odbc.ini, only ~/.odbc.ini

When I build and then run a Docker container which runs rstudio on Ubuntu, the odbc connection does not work when I add the odbc.ini file during the build. However, if I leave out the odbc.ini file from the build and instead add it myself from…
Doug Fir
  • 19,971
  • 47
  • 169
  • 299
4
votes
1 answer

Can't connect to snowflake via unixODBC. Error: [S1000][unixODBC][Snowflake][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function

I've installed/configured the drivers per the instructions here: https://docs.snowflake.net/manuals/user-guide/odbc-linux.html#installing-and-configuring-the-odbc-driver-for-linux Getting the error: [S1000][unixODBC][Snowflake][ODBC] (11560) Unable…
justzach
  • 129
  • 1
  • 6
4
votes
0 answers

How to install Unix ODBC drivers to a unix docker instance?

I'm trying to connect my .net core application, hosted on a unix docker container to an external Vertica database. It works fine when it's a windows client because there are Vertica Drivers for Windows. But there isn't a unix driver for Vertica…
Brian
  • 1,845
  • 1
  • 22
  • 37
4
votes
2 answers

Uninstall older unixODBC completely and install 2.3.2 unixODBC in redhat 6.3

I am trying to install msodbcsql v13 in redhat 6.3. It shows dependency error for unixODBC(64 bit) >= 2.3.1 needs to be installed before installing msodbcsql. I tried running below command, odbcinst -j It shows unixODBC 2.3.2 is installed. Also i…
Nithyanandhan M
  • 1,524
  • 1
  • 16
  • 26
4
votes
1 answer

PDOException: SQLSTATE 01002 Adaptive Server connection failed (severity 9)

I have been following some answers over stackoverflow. My odbc. ini (located in /etc/odbc.ini) [MSSQL] Description = MS SQL Server Driver = /usr/local/lib/libtdsodbc.so Server = host.of.the.server UID = myusername PWD = mypassword ReadOnly = No Port…
Vahn Marty Cagalawan
  • 579
  • 2
  • 7
  • 23
4
votes
1 answer

connect to FileMaker Server with pyodbc

I have a FileMaker db running on FileMaker Server 14 on a Mac Mini and I'm trying to get at it with pyodbc. It's not going well. First, what works: telnet 192.169.19.3 2399 ssh Name@192.169.19.3 tsql -H FM-Server -p 2399 -U Name -P pwd One weird…
brnco
  • 83
  • 6
4
votes
2 answers

Update LD_LIBRARY_PATH system wide for ODBC connection via PHP7.0-FPM

I am trying to connect to NetSuite over ODBC from an Ubuntu Linux machine. I've got everything setup. It works via the shell, and PHP command line. But when I try and make this connection via a web request to PHP, it fails with this error: Warning:…
Nathan
  • 2,941
  • 6
  • 49
  • 80
4
votes
1 answer

Getting error messages while connecting to snowflake database though ODBC

I am using Ubuntu, I am trying to connect php to snowflake using ODBC driver, I have added driver information in /etc/odbcinst.ini. Here is the driver information, that I am using [ODBC…
Dipu R
  • 545
  • 1
  • 5
  • 22
4
votes
1 answer

unixODBC connecting to SQL server timeout

I am having issue with unixODBC. I need multiple connections to different Sql server instances and all of them are working except one. It has additional parameter in host. All host are ip or just host name, but one which is ont working has IP\smth I…
Lukas Ignatavičius
  • 3,496
  • 2
  • 24
  • 29
4
votes
1 answer

Ruby ODBC with remote database

I am working on an application that connects to a legacy database, Eloquence, through ODBC and SQL/R. I set up my server with UnixODBC and setup the drivers and datasources as follows: File /etc/odbcinst.ini [SQLR] Description=SQLR for…
Dave Long
  • 9,569
  • 14
  • 59
  • 89
1 2 3
…
41 42