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

PostgreSQL ODBC driver not showing up in Control Panel (Data Sources)

I installed psqlODBC and when I go to Control Panel -> Data Sources (ODBC) I don't see the Postgres driver installed. I rebooted, still nothing. I then noticed that if I launch this control panel applet from the file…
Assaf Lavie
  • 73,079
  • 34
  • 148
  • 203
16
votes
6 answers

ODBC prepared statements in PHP

I'm trying to use odbc_prepare and odbc_execute in PHP as follows: $pstmt=odbc_prepare($odb_con,"select * from configured where param_name='?'"); $res=odbc_execute($pstmt,array('version')); var_dump($res); //bool(true) $row =…
psx
  • 4,040
  • 6
  • 30
  • 59
16
votes
1 answer

PDO returning error "could not find driver" with a known working DSN

I'm trying to connect to an odbc database via php's PDO class: $dsn = 'odbc:CS_HDZipCodes32bit'; $username = 'demo'; $password = 'skdemo!'; $connection = new PDO($dsn, $username, $password); die( var_dump( $connection ) ); but when I do, I get…
Chris Schmitz
  • 20,160
  • 30
  • 81
  • 137
16
votes
7 answers

"General error Unable to open registry key Temporary (volatile) ..." from Access ODBC

I tried the following: private String password = ""; private String dbName = "dataHC.accdb"; private String bd = dbName + ";PWD=" + password; String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+bd+";"; private…
Erika Hernández
  • 357
  • 2
  • 3
  • 9
16
votes
5 answers

ODBC vs JDBC performance

I have an assignment to use Java and C with MySQL database and compare the results and give reasons as to why such result. No. of Records Execution time (ms) Records Java C 100 586 76 500 628 216 2000 733 …
user3213918
  • 333
  • 1
  • 6
  • 11
16
votes
7 answers

How to check if a table exists in Hive?

I am connecting to Hive via an ODBC driver from a .NET application. Is there a query to determine if a table already exists? For example, in MSSQL you can query the INFORMATION_SCHEMA table and in Netezza you can query the _v_table table. Any…
Michael Robinson
  • 1,985
  • 2
  • 21
  • 31
16
votes
6 answers

How do I connect to my 64-bit SQL Server with ODBC?

I recently installed SQL Server 2008 Express on my Windows 7 Ultimate x64 home machine. I also have IIS 7.5 with PHP 5.3, and I was trying to connect to SQL via ADODB, but kept getting this error: [Microsoft][ODBC Driver Manager] The specified DSN…
soapergem
  • 9,263
  • 18
  • 96
  • 152
16
votes
2 answers

64 bit ODBC Exception

I am getting the following ODBC exception when I moved my development platform from Windows XP X86 to Windows 7 X64: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and…
Jrud
  • 820
  • 3
  • 7
  • 21
15
votes
1 answer

How to implement optimization of INNER JOINS (push down) for Mongo Storage Plugin in Apache Drill?

I would like to extend the Apache Drill Mongo Storage Plugin to push down INNER JOINs. Therefore I would like to rewrite INNER JOIN into the mongo aggregation pipeline. How do we need to start to implement the rewrite in Apache Drill. Here is a SQL…
Dennis Münkle
  • 5,036
  • 1
  • 19
  • 18
15
votes
1 answer

How can I reference System.Data.Odbc for dotnet core in my project?

I have a project I'm deploying in Linux using dotnet core and I need to read a .mdb file. I want to use ODBC for it but even as I see that System.Data.Odbc has already been ported here and that the documentation for the library is out here I can't…
Ana Franco
  • 1,611
  • 3
  • 24
  • 43
15
votes
1 answer

What's the Option=N in the MySQL ODBC connection string?

I have seen both Option=3 and Option=4 in connection string samples for MySQL ODBC but no explanation or documentation. What do those numbers mean?
hawbsl
  • 15,313
  • 25
  • 73
  • 114
15
votes
2 answers

In SQLAlchemy, can I create an Engine from an existing ODBC connection?

I am working in an environment where I am given an ODBC connection, which has been created using credentials to which I don't have access (for security reasons). However I would like to access the underlying database using SQLAlchemy - so my…
Andy
  • 523
  • 6
  • 20
15
votes
22 answers

Oracle ORA-12154: TNS: Could not resolve service name Error?

I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my machine called oraHome90. It seems to allow a…
Joe
  • 791
  • 4
  • 9
  • 11
15
votes
1 answer

closing unused RODBC handle

I have been receiving a Warning Message: `historicalHourly <- importHistoricalHourly(startDatePast,endDatePast,Markets,location) [1] "Importing Hourly Data" [1] "Flag - Moving from importHistoricalHourly to CleaningUpHourly" [1] "Flag - Moving to…
user2480137
  • 171
  • 1
  • 1
  • 4
15
votes
7 answers

Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

I have a problem when trying to connect to MySQL database using Windows OBDC driver. There are plenty of search hits regarding the obvious... people are using old versions, however, I'm not. mysqld is on CentOS 6.4 32bit ./usr/libexec/mysqld Ver…
tlum
  • 913
  • 3
  • 13
  • 30
1 2 3
…
99 100