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

Is there a Windows 7 ODBC driver for Access?

I have an existing PHP script that needs to work with data from an Access db, and the machine it's on is migrating from Win2K to Windows 7. I looked around, and Microsoft seems to say that this is still available somewhere, but I can't find any…
fields
  • 4,433
  • 4
  • 27
  • 32
9
votes
3 answers

"The data has been changed" error when stepping from main form into sub form

I'm migrating an Access database to SQL Server using the SQL Server Migration Assistant (SSMA). The Access application will continue to be used but with linked tables instead of local ones. I've run into a problem during the post-migration testing…
Simon Elms
  • 17,832
  • 21
  • 87
  • 103
9
votes
2 answers

Native vs ODBC database connections

I understand that some databases have native support in R (e.g. MySQL) but you can connect to other DBs like MS SQL Server using RODBC. How much speed improvement does one gain for reading/writing with the native drivers vs. RODBC? What other DBs…
JD Long
  • 59,675
  • 58
  • 202
  • 294
8
votes
4 answers

Enabling PHP pdo_odbc extension on a Mac OSX

I am trying to get the pdo_odbc extension for PHP enabled on my Mac which is running PHP 5.3 Here is what i did to try to get it to work: I installed UnixODBC with brew $ brew install unixodbc Downloaded the source for PHP 5.3.8. In the terminal…
toddgeist
  • 902
  • 9
  • 21
8
votes
3 answers

ODBC ConnectionString

I have written a program in C# to pull some data using OdbcConnection : using System.Data.Odbc; ...... OdbcConnection OdbcConn = new OdbcConnection(Properties.Settings.Default.ConnectionString); OdbcCommand cmd = new…
saiful
  • 159
  • 1
  • 2
  • 5
8
votes
2 answers

Get the list of ODBC data source names programmatically using Delphi

I saw several examples where the list of the source names were took from registry (HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC Data Sources). Is there any other way to get the list of ODBC data sources names? I need to work only with Delphi…
RBA
  • 12,337
  • 16
  • 79
  • 126
8
votes
3 answers

ODBC can't find correct OpenSSL version after upgrading OpenSSL

Update: if you have this same issue, the source of the problem is being discussed here After upgrading to Python3.10 with homebrew, my OpenSSL was upgraded to version 3 as well. Now I can't connect to my SQL Server anymore, since ODBC requires…
Erfan
  • 40,971
  • 8
  • 66
  • 78
8
votes
4 answers

Using Rails 2.x with MS SQL Server 2005

Does anybody here have positive experience of working with MS SQL Server 2005 from Rails 2.x? Our developers use Mac OS X, and our production runs on Linux. For legacy reasons we should use MS SQL Server 2005. We're using ruby-odbc and are running…
squadette
  • 8,177
  • 4
  • 28
  • 39
8
votes
2 answers

How to configure ODBC Data Source Administrator connection for Teradata 17?

I have an instance of Teradata up and running from VMWare Workstation Player on my local machine. I am able to connect to that Teradata database using the default login DBC via putty. I have created another login dbc_test, using the dbc_test also I…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
8
votes
2 answers

ODBC connection string to Snowflake for Access Pass Thru Query

I am trying to create a connection string to get to Snowflake data from Access 2010 and above. I can create a database DSN and link to the tables I use, but I need to build DSN-less connection strings for distributed applications. Here's what I have…
BrianHtx
  • 81
  • 1
  • 2
8
votes
1 answer

Correct way to escape input data before passing to ODBC

I am very used to using MySQL and mysql_real_escape_string(), but I have been given a new PHP project that uses ODBC. What is the correct way to escape user input in a SQL string? Is addslashes() sufficient? I would like to get this right now…
psx
  • 4,040
  • 6
  • 30
  • 59
8
votes
2 answers

Which ODBC-JDBC bridge maps its own calls to JDBC driver?

We have some legacy applications that use an ODBC driver for accessing their databases. I'm looking for an ODBC driver that would be able to map its own calls to a JDBC driver (ODBC-JDBC bridge). Eventually, I'm interested with some documentation…
Stephan
  • 41,764
  • 65
  • 238
  • 329
8
votes
3 answers

QSqlQuery::prepare + MySQL ODBC Connector

I was using Qt's MySQL driver with 32bit MinGW Qt. This was working: QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); db.setDatabaseName("MyDatabase"); //SETUP if (db.open) { QSqlQuery q; if (q.prepare("SELECT id FROM Things WHERE…
smsware
  • 429
  • 1
  • 13
  • 41
8
votes
1 answer

R and RStudio not detecting installed PostgreSQL (or any other) ODBC drivers

I am trying to connect to a PostgreSQL database using the R ODBC drivers in RStudio. For some reason, the drivers are not being detected by R: $ Rscript -e 'odbc::odbcListDrivers()' [1] name attribute value <0 rows> (or 0-length…
Floris
  • 637
  • 1
  • 8
  • 17
8
votes
1 answer

Install ODBC Driver heroku

I can not get rid of the error. django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 13 for SQL Server' : file not found (0) (SQLDriverConnect)") Put heroku buildpacks:add --index 1…
TiRuRi
  • 81
  • 5
1 2 3
…
99 100