Stack Overflow
Stack Overflow

Questions tagged [odbc]

Open Database Connectivity (ODBC) provides a standard software interface for accessing database management systems (DBMS).

ODBC (Open Database Connectivity) is a standard C programming language middleware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems; an application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.

ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS.

An ODBC driver can be thought of as analogous to a printer or other driver, providing a standard set of functions for the application to use, and implementing DBMS-specific functionality. An application that can use ODBC is referred to as "ODBC-compliant".

Any ODBC-compliant application can access any DBMS for which a driver is installed. Drivers exist for all major DBMSs, many other data sources like address book systems and Microsoft Excel, and even for text or CSV files.

External links:

9481 questions
26
votes
3 answers

How do I use a 32-bit ODBC driver on 64-bit Server 2008 when the installer doesn't create a standard DSN?

I ran into an issue with some third party software that we use to track software license usage in our computer labs. We recently migrated the app to 64-bit Server 2008 after receiving assurances from the company that it was compatible and running…
tvanfosson
  • 524,688
  • 99
  • 697
  • 795
24
votes
2 answers

Speed up odbc::dbFetch

I'm trying to analyze data stored in an SQL database (MS SQL server) in R, and on a mac. Typical queries might return a few GB of data, and the entire database is a few TB. So far, I've been using the R package odbc, and it seems to work pretty…
Michael Roswell
  • 1,300
  • 12
  • 31
24
votes
4 answers

SQL Server: Native client vs. ODBC?

What is the difference between SQL Server Native Client connection and ODBC connection? What are the pros and cons of these two?
juur
  • 5,633
  • 10
  • 32
  • 36
24
votes
3 answers

Connecting Python with Teradata using Teradata module

I have installed python 2.7.0 and Teradata module on Windows 7. I am not able to connect and query TD from python. pip install Teradata Now I want to import teradata module in my source code and perform operations like - Firing queries to teradata…
anurag
  • 590
  • 3
  • 8
  • 27
24
votes
4 answers

Working with an Access database in Python on non-Windows platform (Linux or Mac)

I want to access the data in a Microsoft Access database. I have some .accdb and .mdb files and want to read them in Python. From my research, pyodbc can only be used on Windows platform, but I am working on Mac OS X. I am new to Python. The other…
user2948166
  • 599
  • 1
  • 9
  • 17
24
votes
1 answer

Python odbc; how to find all tables in an odbc

Is there any way to get a list of all tables available through an odbc connection. I have to fetch data from tables that are generated along the way, and therefore I don't know the names in advance.
user2866103
  • 9,887
  • 6
  • 15
  • 15
24
votes
3 answers

PHP & SQL Server - field names truncated

Here is the relevant code: function connect(){ // DB credentials and info defined here.... $connection = odbc_connect("DRIVER={SQL Server Native Client 11.0}; Server=$server; Database=$db;", $loginname, $loginpass); return…
nmc
  • 8,724
  • 5
  • 36
  • 68
23
votes
6 answers

Common ways to connect to odbc from python on windows?

What library should I use to connect to odbc from python on windows? Is there a good alternative for pywin32 when it comes to odbc? I'm looking for something well-documented, robust, actively maintained, etc. pyodbc looks good -- are there any…
user89021
  • 14,784
  • 16
  • 53
  • 65
23
votes
4 answers

Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present

I want to do a hand install of the MS Access 64 bit odbc drivers. Uninstalling 32 bit Office and installing 64 bit Office is not an option due to the add-ins that our company uses. I downloaded the AccessDatabaseEngine_x64.exe and using WinRar and…
JMoney
  • 321
  • 1
  • 2
  • 6
23
votes
2 answers

How do I create a DSN for ODBC in Linux?

I am digging around in a Linux application that supposedly uses DSNs to connet to SQL Server. The connection stopped working and I can't find the credentials that are being used (all I know is the DSN's name). I am familiar with DSNs in Windows,…
deadprogrammer
  • 11,253
  • 24
  • 74
  • 85
23
votes
1 answer

Libraries for connecting node.js to odbc on Windows?

I'm looking for a library that allows node.js to connect to ODBC on windows. All the libraries I have found thus far seem to work with UnixODBC but not windows, can someone please suggest a library that will work with Windows?
leeand00
  • 25,510
  • 39
  • 140
  • 297
22
votes
2 answers

PDO returning empty property name

I'm having a strange issue with pdo_odbc and PDO::FETCH_OBJ (and PDO::FETCH_CLASS) that results in the following error message: PHP Fatal error: Cannot access empty property Here's the code: $dbh = new PDO("odbc:FOO"); $sth = $dbh->query(" …
mwp
  • 8,217
  • 20
  • 26
22
votes
3 answers

FreeTDS working, but ODBC cannot connect

I am trying to run connect to a MSSQL server from an Ubuntu 12.04 webserver with FreeTDS and unixODBC. Using tsql i can connect to the server with ~$ tsql -S dbs3 -U -P No problem there. When I try to connect with isql…
AndMim
  • 550
  • 1
  • 3
  • 11
21
votes
5 answers

RODBC queries returning zero rows

Issue: RODBC (falsely) returning zero rows Situation: I'm using RODBC to connect to a DSN I created using a commercial DB's ODBC driver (OSI Soft's PI Historian Time Series DB, if you're curious). > library(RODBC) > piconn <- odbcConnect("PIRV",…
Tommy O'Dell
  • 7,019
  • 13
  • 56
  • 69
21
votes
3 answers

Install ODBC driver in Alpine Linux Docker Container

I currently have the following Dockerfile to create my Docker image. FROM python:3.6.6-alpine3.8 # Add dependencies for Python packages pandas, numpy and pyodbc RUN apk add --no-cache curl gcc g++ unixodbc-dev RUN ln -s /usr/include/locale.h…
Alexis.Rolland
  • 5,724
  • 6
  • 50
  • 77
1 2
3
…
99 100