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

Which option to select to use sql in C++

I want to connect and use sql database within my C++ application . My application need to store some data (can be stored in form of tables) which will be growing continuously and need to be shared between different processes - so I need a database.…
Abhishek Gupta
  • 6,465
  • 10
  • 50
  • 82
11
votes
1 answer

"System resource exceeded" during connection to Access file through Java jdbc odbc

I've read all "System resource exceeded" posts, but this is nothing like them. I've spend the last 3 hours searching for a solution. I don't have many connections / statements / resultsets and I always close all of them. My code used to work but now…
Stefanos Kargas
  • 10,547
  • 22
  • 76
  • 101
11
votes
3 answers

Trick to reset odbc_error()

I've learnt that odbc_execute() does not always trigger a proper ODBC error when it returns FALSE (not at least with the Oracle driver) and I can't fully trust odbc_error() or odbc_errormsg(). This situation is easy to detect when there wasn't a…
Álvaro González
  • 142,137
  • 41
  • 261
  • 360
11
votes
4 answers

Specify a default driver for ODBC

I have a legacy VB6 app which builds a DSN based on a parameter in a config file. The parameter is an ODBC connection, and the connection has a name (DSN-NAME) which maps a server (DBSERVER) to a driver ("SQL Server Native Client"). Generally, it…
crb
  • 8,132
  • 6
  • 37
  • 48
11
votes
5 answers

Excel ODBC and 64 bit server

using ASP.NET I need to update an excel template. Our server is running Windows 2008 in 64 bit mode. I am using the following code to access the excel file: ... string connection = @"Provider=MSDASQL;Driver={Microsoft Excel Driver…
Ris Adams
  • 1,345
  • 4
  • 13
  • 25
11
votes
2 answers

What are the differences between ODBC and ADO.NET

I'm devolving a new module that will connect to an Oracle DB over .net 4.5.1. Should I use ODBC or ADO.NET and what are the differences between them? I read that ADO.NET requires an additional installation of an Oracle's client. Is there any way to…
Eran Reuven
  • 136
  • 1
  • 1
  • 5
11
votes
3 answers

ODBC Connection to Excel error

I'm having a problem with the ODBC connection that is supposed to connect to an Excel table and do stuff with it. I've already read a lot stuff on the internet about it, but none of the solutions helped me (including stackoverflow). So basically I…
AbyPhantom
  • 111
  • 1
  • 6
11
votes
9 answers

Using Azure SQL Services from a Mac?

Azure SQL Services looks pretty cool, and I'd like to use it as a hosted database. I set myself up with a starter web edition database, and after clicking through a million and five EULAs, I got to a console and created a database. It gave me a…
Erik Paulson
  • 111
  • 1
  • 1
  • 3
11
votes
7 answers

Connecting to SQL Server using PHP, ODBC, and Windows authentication

I'm trying to use PHP to connect to an ODBC data source using Windows authentication. I can connect just fine to the server in SQL Server so I know it's running. When I try to run the command $link = odbc_connect("my_odbc","",""); I get the…
Compysaurus
  • 191
  • 1
  • 2
  • 13
11
votes
2 answers

how to check status of native ODBC connection in matlab?

Brief introduction of the problem: the main problem is not in the connection procedure, i could connect to database successfully, and insert some rows in my database(firs code block shows this),but after closing the connection if someone tries to…
Hadi
  • 1,203
  • 1
  • 10
  • 20
11
votes
3 answers

SQLGetInfo - How to use this function

I have developed a c# application which connects to many types of database servers like Sql,Oracle,Mysql etc..Connection was established using ODBC. I need to find the server type (DBMS type) for which the connection was established, as the user…
Dah Sra
  • 4,107
  • 3
  • 30
  • 69
11
votes
2 answers

Python pyodbc Unicode issue

I have a string variable res which I have derived from a pyodbc cursor as shown in the bottom. The table test has a single row with data ä whose unicode codepoint is u'\xe4'. The Result I get is >>> res,type(res) ('\xe4', ) Whereas the…
rogue-one
  • 11,259
  • 7
  • 53
  • 75
11
votes
0 answers

Object or Provider is not able to perform the requested operation

I am trying to run the classic asp application which uses RDS (Remote data service) on Windows Server 2008 Following is the code written in…
RemS
  • 272
  • 1
  • 9
11
votes
4 answers

pyodbc + MySQL + Windows: Data source name not found and no default driver specified

I am trying to connect to MySQL 5.6 on a Windows Server 2008 R2 localhost with pyodbc. I used the full installation for the MySQL instance on the localhost, including the ODBC connector. I have it connecting to a remote SQL Server instance…
sct.chang
  • 121
  • 1
  • 1
  • 4
11
votes
1 answer

Tally database synchronization with c# Application

I want to make an application to sync Tally Sales Order and Sales Invoice from tally to our SQL Database. Currently for testing purpose I am using Tally ERP 9 Educational Version. I have created some sales orders in tally and need all order with…
Sagar Vaishnav
  • 111
  • 2
  • 6
1 2 3
…
99 100