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

ODBC Connection not appearing SSIS

I have a System DSN ODBC driver configured correctly on a server (the connection has been tested and works fine). I've got an SSIS package, and when I try to create an ODBC connection manager, I can't find my ODBC connection in the drop down of data…
Sam
  • 325
  • 3
  • 15
2
votes
1 answer

Using like statement in odbc connection

Is there a way to use a LIKE statement using an ODBC connection in .net? I have tried everything I could think of, yet I always get a SQL exception. SELECT field FROM table WHERE fieldName LIKE '%SOME_STRING%'; string sql = "SELECT field FROM…
Dan
  • 1,222
  • 2
  • 17
  • 33
2
votes
0 answers

SSIS - Execute SQL Task > Date conversion issue when passing DateTime variable as parameter

Brief background of the system: Using an SSIS package to move data from SQL Server to MySQL. I use an OLE DB connection to connect to SQL Server. I use an ODBC Unicode connection to connect to MySQL. Most of the system works, but I am having a date…
Antonio Lopez
  • 21
  • 2
2
votes
1 answer

Can we write ODBC query for saved searches formula in Netsuite. To get same output by running query?

We have serval saved searches in Netsuite account and the client wants . Every saved searches formula should be written in ODBC query? Would it possible to write ODBC query for 100 of formula in Netsuite? Please help .
user5393051
  • 21
  • 1
2
votes
0 answers

symfony doctrine pdo odbc driver

I would like to configure connection to sqlserver from my symfony config file. PHP connection work fine $mssqldriver == '{ODBC Driver 17 for SQL Server}'; PDO("odbc:Driver=$mssqldriver;Server=Myserver,Myport;Database=Mydatabese;", $username,…
HaTeM
  • 21
  • 2
2
votes
3 answers

DataReader Close Method Throws OdbcException

Update: Sorry for the delay over the weekend but some updates to your comments: I have updated the stack trace to include the entire stack. As well, the problems still exists when I manually close the reader via DataReader.Close(). The database that…
mdemoret
  • 21
  • 1
  • 5
2
votes
0 answers

How can I set character set for PDO ODBC?

I'm using MDB(Microsoft Access) file as database and unfortunately all Persian characters converted to question signs (?????) I have using PDO and ODBC extension: $conn = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)};…
Mohammad
  • 385
  • 1
  • 4
  • 16
2
votes
2 answers

Database connectivity in java using odbc-: can't find microsoft access driver (*.mdb *.accdb) option

I am trying to connect MS office access with my java code using odbc driver. Precisely, In ODBC data source Administrator, as I click the add button, the Create New Data Source dialog box appears. But I can't find the Microsoft access driver…
Nithya
  • 51
  • 10
2
votes
1 answer

Extract a few million records from Teradata to Python (pandas)

I have data from 6 months of emails (email properties like send date, subject line plus recipient details like age, gender etc, altogether around 20 columns) in my teradata table. It comes around 20 million in total, which I want to be brough into…
Sreenath1986
  • 167
  • 4
  • 16
2
votes
1 answer

how do I successfully use PDO with my ODBC for MSSQL?

Windows Server 2016 64 bit (Fully Updated) WAMP/3.1.3 (Win32) Apache/2.4.33 (Win32) PHP/7.2.4 (Win32) I am trying to connect to my database on a SQL Server but can't seem to get the connection working. I have tried several approaches, downloaded…
jaesson1985
  • 718
  • 2
  • 11
  • 19
2
votes
0 answers

excel connection string - relative path

I have a connection string in an Excel Spreadsheet that links to other spreadsheets. All works well. However, the file and directory are written as absolute. Can this be relative? There are two files in the same directory…
Graeme Townsend
  • 21
  • 5
2
votes
1 answer

checking class of R-DBI connection object

I'm rewriting a function that optionally accepts a connection object. The parameter should be verified that it's a valid connection/channel. How do I do this robustly with the DBI package? (Specifically, I'm using odbc package.) I'd like…
wibeasley
  • 5,000
  • 3
  • 34
  • 62
2
votes
3 answers

Using Microsoft Excel via an ODBC Driver with PHP

I am trying to insert data and select data from Excel using an ODBC connection. I have managed to connect to it: $dbh = new PDO("odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=$file_name", $username, $password); However, I…
Abs
  • 56,052
  • 101
  • 275
  • 409
2
votes
2 answers

How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?

I've got an ms-access application that's accessing and ms-sql db through an ODBC connection. I'm trying to force my users to update the data only through the application portion, but I don't care if they read the data directly or through their own…
BIBD
  • 15,107
  • 25
  • 85
  • 137
2
votes
2 answers

SQL NOOB - nested/subqueires

I will begin by clearly stating that I am not a programmer, I am an accountant at heart! I have a need to return into excel all transactions relating to jobs that have had transactions in a given week (i.e. so that I can see an in week amount and…
TouringCanary
  • 23
  • 2
1 2 3
…
99 100