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
11
votes
5 answers

ODBC works fine in MS Excel, but not in R

I've set up my ODBC driver so that MS Excel can import the data into a spreadsheet just fine. However, when I try to establish the connection with R, using ch <- odbcConnect(leprosyDHISdb, uid = leprosyDHISid, pwd = leprosyDHISpw) Then I get the…
Tom
  • 4,860
  • 7
  • 43
  • 55
11
votes
4 answers

How to fix the [unixODBC][Driver Manager]Data source name not found, and no default driver specified (ODBC::Error)

/local/rvm/gems/ruby-1.9.2-p320/gems/activerecord-sqlserver-adapter-3.2.12/lib/active_record/connection_adapters/sqlserver_adapter.rb:455:in `initialize': IM002 (0) [unixODBC][Driver Manager]Data source name not found, and no default driver…
Clone
  • 919
  • 4
  • 11
  • 22
11
votes
2 answers

Go/Golang sql.DB reuse in functions

sql.Open() returns a variable of type *sql.DB I have a function that calls 10 other functions that all need to make database calls Is it more correct/efficient to: Send the *sql.DB pointer to every function, or Create a new *sql.DB object in each…
Allison A
  • 5,575
  • 6
  • 28
  • 32
11
votes
3 answers

Using Excel as an ODBC database

I'd like to know, how to create a database table in Excel, so that it may be used with ODBC I want to use ODBC, and I have two options, either MS Access or Excel, As you probably know, in order to indicate some MS Access file or Excel file as an…
mangusta
  • 3,470
  • 5
  • 24
  • 47
11
votes
4 answers

SQLGetPrivateProfileString failed with

Typing the command: odbcinst -q -s on RHEL 6, I get the following error message: odbcinst: SQLGetPrivateProfileString failed with . All my DSN's are also not showing up when I run: odbcinst -q -d
Kapil Vyas
  • 607
  • 2
  • 8
  • 22
11
votes
3 answers

Connecting Excel to PostgreSQL via VBA

Is it possible to make query like SELECT from VBA in Excel, so I can query a PostgreSQL DB from Excel? If is possible please explain me how to connect to the database. I was looking in Google but found no results.
vivid
  • 1,115
  • 2
  • 14
  • 34
10
votes
3 answers

Connection forcibly closed while executing the subqueries in the QuickBooks online ODBC driver connection

I am using the trial version of QuickBooks Online ODBC (QODBC) driver and configured the DSN named QuickBooks Online Data as well as QuickBooks Online Data QRemote I have ensured the connection using the test tool and I am able to execute the SQL…
Janakiraman
  • 121
  • 4
10
votes
2 answers

unable to install pyodbc using python 3.10 in windows 10

I get this Error when I try to install Pyodbc , I have already install visual studio and I have Microsoft Visual C++ 12 , 15-19 in my machine but still its giving this error. Running setup.py clean for pyodbc Failed to build pyodbc Installing…
umair mehmood
  • 529
  • 2
  • 5
  • 17
10
votes
6 answers

How do I change a Crystal Report's ODBC database connection at runtime?

I have a report made with Crystal Reports 2008 that I need to deploy a production system which means that I need to be able to change the database connection at runtime. The database is PostgreSQL 8.3.0 and the connection I use for creating the…
Ryan Taylor
  • 8,740
  • 15
  • 65
  • 98
10
votes
6 answers

How to connect java to Ms Access 2010?

Does anyone have any ideas of how to connect Access 2010 to java jdbc. I use this method, but when I call it, it doesn't work: public void loadDb(){ try{ Class.forName("sun.jdbc.JdbcOdbcDriver"); File f = new…
Tepken Vannkorn
  • 211
  • 3
  • 4
  • 7
10
votes
6 answers

does anyone know the format of an odbc connection string for vertica?

I'm using the following: DRIVER={Vertica ODBC Driver 4.1}; SERVER=lnxtabdb01.xxxx.com; PORT=5433; DATABASE=vertica; USER=dbadmin; PASSWORD=vertica; OPTION=3; i'm getting this error and I just wanted to make sure that my connection string was cool…
Ramy
  • 20,541
  • 41
  • 103
  • 153
10
votes
3 answers

SQL0666 - SQL query exceeds specified time limit or storage limit

Periodically, I get this error message while making a call to a DB2 database using the Odbc connection string. I have tried setting the CommandTimeout of the DbCommand object to multiple values, but I still get the following error. SQL0666 - SQL…
Isaac Levin
  • 101
  • 1
  • 1
  • 3
10
votes
5 answers

Exporting ODBC System DSNs from a windows 2003 machine?

Is there a way to export all the ODBC System DSNs from a windows 2003 machine?
Zaffiro
  • 4,834
  • 5
  • 36
  • 47
10
votes
1 answer

SYBASE ODBC .Net CORE

1. Has anyone successfully used ODBC from c# to Sybase ASE? 2. Or Better, has anyone successfully used Sybase ASE with .NET Core? I am using .NET Core 1.1 and the current Sybase.AdoNet4.AseClient.dll doesn't work, so I am attempting to use ODBC. I…
Monkey Man
  • 163
  • 10
10
votes
4 answers

Mac OS X 10.6 ODBC Drivers

I'm going crazy trying to find a FOSS free (doesn't have to be open source) ODBC driver to connect to an MS SQL Server. While it doesn't strictly have to be free (which is a huge plus, for obvious reasons), the drivers I have found haven't had an…
tjsimmons
  • 733
  • 4
  • 10
  • 21
1 2 3
…
99 100