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
15
votes
3 answers

Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu

I'm trying to get MSSQL working on Ubuntu 12.04 via ODBC, and I've followed these steps to the letter: http://jamesrossiter.wordpress.com/2011/03/08/connecting-to-microsoft-sql-server-using-odbc-from-ubuntu-server/ However, this omits both of these…
Michael B
  • 1,743
  • 4
  • 21
  • 35
15
votes
5 answers

MSSQL Server's Native ODBC Driver for Linux and PHP 5.4

I have Apache 2.2.16 and PHP 5.4.3 on a Linux Debian 6 x64. To install the MSSQL Server's Native ODBC Driver for Linux, I use the following instructions: http://www.codesynthesis.com/~boris/blog/2011/12/02/microsoft-sql-server-odbc-driver-linux/ I…
Vinicius Garcia
  • 1,740
  • 4
  • 30
  • 54
14
votes
2 answers

PHP ODBC connect() to Access - architecture mismatch

I have googled for hours now. I have read countless articles such as: Is there a Windows 7 ODBC driver for Access? I have tried using both the ODBC admin - and have managed to successfully add there system DSN for both: Microsoft Access…
Alex.Barylski
  • 2,843
  • 4
  • 45
  • 68
14
votes
3 answers

Connect to Azure SQL in Python with MFA Active Directory Interactive Authentication without using Microsoft.IdentityModel.Clients.ActiveDirectory dll

To connect to Azure SQL Database using MFA (which is in SSMS as "Active Directory - Universal") Microsoft recommends and currently only has a tutorial on connecting with C# using Microsoft.IdentityModel.Clients.ActiveDirectory Setting…
dmi_
  • 1,187
  • 2
  • 12
  • 26
14
votes
4 answers

Is it possible for 64-bit pyodbc to talk to 32-bit MS access database?

I am using 64-bit python anaconda v4.4 which runs python v3. I have MS Access 2016 32-bit version. I would like to use pyodbc to get python to talk to Access. Is it possible to use 64-bit pyodbc to talk to a MS Access 2016 32-bit database? I…
user3848207
  • 3,737
  • 17
  • 59
  • 104
14
votes
5 answers

The riddle of the working broken query

I was going through some old code that was written in years past by another developer at my organization. Whilst trying to improve this code, I discovered that the query it uses had a very bad problem. OdbcDataAdapter financialAidDocsQuery = …
clifgriffin
  • 2,008
  • 3
  • 21
  • 41
14
votes
3 answers

Crystal Reports Changing the Data Source

I have a Crystal report where the data source has originally been set to use ODBC connections. Now I want to modify the data source to instead use OLE DB instead of using ODBC. How do I replace the data source connection without breaking the…
Batuta
  • 1,684
  • 17
  • 48
  • 62
14
votes
2 answers

Getting list of odbc drivers available in windows 7 using python

I am trying to write a generic database connector class in python. For this I want to first check what drivers are installed on the machine and throw an error if the required drivers are missing in the machine. Is there a way to do this in python?
haraprasadj
  • 1,059
  • 1
  • 8
  • 17
14
votes
6 answers

How to connect PHP with Microsoft Access database

I am currently faced with a new challenge to develop a site using Microsoft Access as the primary database instead of mysql. I have not used MS Access before and I would like guidiance on how to go about it, I have looked up the w3c website on…
user2503040
14
votes
4 answers

Updating an SQLite database via an ODBC linked table in Access

I am having an issue with an SQLite database. I am using the SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ Installed the 64-bit version and created the ODBC with these settings: I open my Access database and link to the datasource. I can…
Herrozerro
  • 1,601
  • 1
  • 22
  • 37
14
votes
3 answers

How does OPENQUERY differ for SELECT and INSERT?

I'm aware that the following query will pull down the result set from a linked server: SELECT * FROM openquery(DEVMYSQL, 'SELECT event_id, people_id, role_id, rank, last_updated FROM event_cast') However, is this the same case when it comes to…
Abs
  • 56,052
  • 101
  • 275
  • 409
13
votes
2 answers

Test ODBC entry on Unix

Does anyone know a way of testing if an odbc entry on the odbc.ini file is configured correctly? I would like to know if my linux server is able to connect to my SQL Server using an ODBC entry I configured.
Diego
  • 34,802
  • 21
  • 91
  • 134
13
votes
6 answers

How to properly install pyodbc and drivers on M1 mac

I have a new M1 pro macbook and I'm trying to install pyodbc and relevant drivers on my machine. So far I have installed unixodbc via homebrew and ODBC drivers according to the instructions found here:…
kdot
  • 131
  • 1
  • 1
  • 4
13
votes
1 answer

how to find ODBC driver-specific arguments

Is there a way to programmatically discover the named arguments for ODBC connections? For instance, using the "ODBC Driver 17 for SQL Server", the ODBC Data Source Administrator (in Windows) allows for authentication using a "Login ID" and…
r2evans
  • 141,215
  • 6
  • 77
  • 149
13
votes
5 answers

Listing ODBC Data Sources in C#

I'm looking for a properly abstract way to get a list of ODBC data sources from the system in C#. I've tried the "Poking-around-in-the-registry" trick, which I've found works fine in English: RegistryKey reg =…
Jamez
1 2 3
…
99 100