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

How to access a Postgres db from Excel Mac?

I need to create a really simple table in Excel with data from a Postgres db in localhost. I've managed to do it with OpenLink PostgreSQL Lite Driver but doesn't look friendly or manageable. I used to use ODBC on Windows, but I'm not sure on OS X. I…
Diego Aguado
  • 1,604
  • 18
  • 36
10
votes
1 answer

SSIS ODBC SQL parameters

I've got a SQL command in an odbc source data flow task that needs to take parameters, but the option to add them isn't there. I tried to add the database as an ADO.NET connection with an ODBC provider, but there were also no parameters available.…
Jooooosh
  • 331
  • 2
  • 4
  • 13
10
votes
3 answers

MySQL ODBC Link Fails due to "authentication protocol refused"

I've had a good search around but not yet found an answer that allows me to rectify this problem. I'm trying to connect from MS Access to a MySQL 5.2 database on a remote server. I've set up a user account which has select, insert, update, delete…
Ambulare
  • 897
  • 3
  • 10
  • 32
10
votes
4 answers

DSN-less connection with PHP ODBC using MDBTools Driver

I'm attempting to read from an Access database using MDBTools drivers to execute an odbc_connect on Ubuntu 11.10. It's working fine when using the DSN setup in /etc/odbc.ini. Below are the contents of /etc/odbc.ini: [logindb] Description = Microsoft…
Tim S
  • 5,023
  • 1
  • 34
  • 34
10
votes
4 answers

DSN to connectionstring?

We've got an ASP.NET website that uses a database that we want to be able to use a connectionstring to get to. We've successfully set up a DSN for connecting to this DB, but I can't seem to discover the correct magic to go with a…
Beska
  • 12,445
  • 14
  • 77
  • 112
9
votes
7 answers

When should I be using Odbc, OleDb, SQLClient? What are the trade-offs

I am starting off with a SQLServer database. So it would seem that I should use System.Data.SqlClient namespace. But, there is a chance that we might shut down our SqlServer database and go to MySql or Oracle. For this reason, I am coming up with a…
Raj Rao
  • 8,872
  • 12
  • 69
  • 83
9
votes
3 answers

How to programmatically configure an ODBC Datasource using C#

Is there any way to create a ODBC DSN with C#? Maybe a P/invoke?
olorin
  • 2,214
  • 3
  • 19
  • 22
9
votes
5 answers

Connect to remote PostgreSql database using Powershell

I'm trying to connect to a remote PostgreSql database using powershell. This is my first time using powershell so I'm sorry if this is a noob question. This is my Code: $DBConnectionString = "Driver={PostgreSQL…
stirling
  • 143
  • 2
  • 3
  • 8
9
votes
1 answer

SQL SERVER ODBC ERROR(Invalid object name) but when I add in SQL query mydb.dbo.mytable all works fine

I have an old asp.net 1 project (it works fine on old server, mytable exist in db. Now I am trying to upgrade it to asp.net 4 My connection string is:
John
  • 864
  • 1
  • 11
  • 26
9
votes
1 answer

Efficient way to test ODBC connection

Our product is a TCP listening transaction processor. Incoming connections are assigned a thread to handle the connection and a DB connection to work with. Rather than costly approach of establishing new DB connection for each incoming client…
user390935
  • 255
  • 1
  • 4
  • 9
9
votes
1 answer

Determine real cause of ODBC failure (error 3146) with ms-access?

My client is using Access as a front end to a SQL Server database. They recently started getting ODBC - 3146 errors from time to time when running some reports. From what I can tell, this is just a generic ODBC call failed error. I've tried…
Aaron Hinni
  • 14,578
  • 6
  • 39
  • 39
9
votes
4 answers

SQL Server to MySQL data transfer

I am trying to transfer bulk data on a constant and continuous based from a SQL Server database to a MYSQL database. I wanted to use SQL Server's SSMS's replication but this apparently is only for SQL Server to Oracle or IBM DB2 connection.…
JBone
  • 3,163
  • 11
  • 36
  • 47
9
votes
3 answers

Use 32-bit version of ODBC on 64-bit Windows 7?

I'm having problem with ODBC and an application written with Visual Basic 6 (so it's 32-bit). It seems that the ODBC library of VB6 is not compatible with the 64-bit ODBC of Windows 7. The error code returned is -2147220992 and it's rambling about…
john2x
  • 22,546
  • 16
  • 57
  • 95
9
votes
3 answers

Pyodbc on M1 Macs

I am trying to connect to a Microsoft sql server database using pyodbc. I keep getting the error Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)") Checking…
Pawan nandakishore
  • 111
  • 1
  • 1
  • 4
9
votes
2 answers

ODBC Driver 17 for SQL Server on apple M1

I am trying to get ODBC Driver 17 for SQL Server to work but somehow it doesn't on my brand new apple M1. Apparently I got unixodbc installed and also the driver, but starting them doesn't work. Looks like the odbc driver is not yet ready for the…
nico525
  • 137
  • 1
  • 8
1 2 3
…
99 100