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
3 answers

CodeIgniter ODBC Woes

Well, I had built an application intended for MSSQL, and originally ran it that way, I bought a new computer and for some odd reason it won't let me connect via MSSQL. So I set up ODBC. It connects fine, but it seems to hate active records. Am I…
Zen
  • 7,197
  • 8
  • 35
  • 57
2
votes
1 answer

BigQuery Simba ODBC Connection - Google Drive OAuth Error

I am trying to export the results of a BigQuery view to Excel using the Simba ODBC Connection. The view I am querying references tables which are linked to Google Sheets, however I can't get the permissions to pass through to the Google Sheet,…
MVData
  • 21
  • 1
  • 3
2
votes
1 answer

PHP + odbc: Data source name not found and no default driver specified

I use odbc driver to load data from an MS Access database file. PHP code: $connStr ='odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};' . 'Dbq=C:\\inetpub\\wwwroot\\dir\\dir.accdb;'; $dbh = new…
Spiris
  • 69
  • 2
  • 9
2
votes
1 answer

Connection to Google Bigtable in Google Dataproc using HBase odbc driver

Has anyone already made a connection to Google Bigtable in Google Cloud Dataproc using any available HBase odbc driver? If yes, can you tell which ODBC you've used? Thanks
Red
  • 1,141
  • 8
  • 13
2
votes
1 answer

PHP 7 - ODBC Support is built in...or is it?

The stock php.ini file for php 7 declares in a comment: "Note that ODBC support is built in, so no dll is needed for it." However, a few lines down there is: extension=php_odbc.dll ...and that file is included in the ext directory. We support…
AS7K
  • 417
  • 4
  • 20
2
votes
1 answer

R odbc Impala Change from Default Database in Select

I have successfully connected to Impala using R's odbc package. When I created the connection using my Microsoft ODBC Administator tool, I set the default database to default. This is a database which exists in this Impala instance, but it isn't one…
Nick Criswell
  • 1,733
  • 2
  • 16
  • 32
2
votes
1 answer

Azure C# App Service ODBC connection to Redshift

I have developed an Azure Api Service (Rest API) that needs to connect occasionally to a aws Redshift database. This is working fine on my development environment (once I installed the Redshift ODBC driver, and created an DSN entry) however fails…
Mark Ruse
  • 387
  • 1
  • 4
  • 12
2
votes
1 answer

PostgreSQL text field loads as strL

I have data stored in PostgreSQL with the data type text. When I load this data into Stata it has type strL, even if every string in a column is only one charter long. This takes up too much memory. I would like to continue using the text type in…
Molly
  • 13,240
  • 4
  • 44
  • 45
2
votes
0 answers

What is the location of Anaconda config to specify the location of ODBC drivers?

I need to install Vertica's ODBC driver here but it installs to different location than my custom path $ which python /Users/hhh/anaconda3/bin/python I could fix the problem by uninstalling Anaconda and installing Anaconda under the same place as…
hhh
  • 50,788
  • 62
  • 179
  • 282
2
votes
0 answers

MS Access adds always current day in time defined postgres column

We are moving BackEnd tables from a large MS Access application to postgresql. In one table we have a field ErZei defined in postgres as time(0) without time zone DEFAULT ('now'::text)::time(0) without time zone Inside this field only the time…
Maoam
  • 21
  • 1
2
votes
1 answer

RODBC in Ubuntu truncates text strings to 255 characters

I am using RODBC installed on Ubuntu 16.0.4, and I am porting my Windows-based R project/package to this Linux environment. I am running into the issue where sqlQuery returns only the first 255 characters of a text string from an MS SQL Server…
Peter B
  • 91
  • 4
2
votes
2 answers

Can I connect to NetSuite data via ODBC without having SuiteAnalytics?

Just starting a job with a company that uses NetSuite. I am new to NetSuite, and my background is in SQL and C# - I'd like the ability to access the data outside of the UI and wondering if there's a way to do that without asking management to…
A Flynn
  • 47
  • 1
  • 8
2
votes
0 answers

Power BI Desktop ODBC connection to Firebird

I have trouble to connect my Power BI desktop to ODBC DSN to Firebird database. My System DSN with Firebird driver is connected successfully from ODBC settings. When I select my DSN (correct DSN is selected) in Power BI Desktop an error…
TomasKincl
  • 21
  • 1
  • 2
2
votes
1 answer

ADODB, SQLSERVER, SERVERPROPERTY: different types using sqloledb or ODBC driver?

I'm trying to switch one of my VBS scripts from using SQLOLEDB to ODBC driver. So long all works like expected - all but one thing: When fetching SERVERPROPERTY("is_clustered") from an MSSQL instance the resulting value is different using each…
Marcel
  • 21
  • 3
2
votes
2 answers

Adding Linux ODBC drivers for SQL Server to a Kaggle/Python docker image

I am trying to build out a data science machine capable of running machine learning python programs in a production environment. The current business case data needs to be pulled from SQL Server, scored with Machine Learning using python and pushed…
CRAFTY DBA
  • 14,351
  • 4
  • 26
  • 30
1 2 3
…
99
100