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

MySQL ODBC configuration

I have managed to make my Access work as a frontend for MySQL. I have managed to make it work through connection string but because some specifics in code i would like to save DSN configuration as user DSN. I have ran into one specific problem. I…
stacks
  • 221
  • 3
  • 13
2
votes
1 answer

Rstudio Connections tab doesn't help me refer to an object name in code

I can see an object but I can't refer to it in code: library(odbc) library(DBI) library(tidyverse) library(readr) con <- dbConnect(odbc::odbc(), driver = "libtdsodbc.so", database = "AdventureWorks2012", …
John David Smith
  • 573
  • 1
  • 6
  • 15
2
votes
1 answer

CS0246 error with OdbcConnection line in C#

Ive been chasing this CS0246 error for a couple hours and am not sure how to resolve it. Given this simple C# code: using System; // using Microsoft.Data.Odbc; using System.Data.Odbc; namespace dotnetdb { class Program { static…
Omortis
  • 1,334
  • 19
  • 44
2
votes
1 answer

Suppress but capture warnings in R

I am building a function to connect to a specific password-protected ODBC data source that will be used many members of a team - it may be used in multiple environments. In the event that the connection is rejected, I would like to display the…
dmawhirter
  • 23
  • 5
2
votes
0 answers

invalid column name error when using sqlsrv in php

Below are my code : $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn ) { }else{ echo "Connection could not be established.
"; die( print_r( sqlsrv_errors(), true)); } $sql = 'SELECT [group_id],[type] FROM…
hafez busra
  • 19
  • 7
2
votes
2 answers

C# - Get Field Types

In a C# 2.0 I have a list of fields and a list of values (stored as strings), a table name, and an ODBC Connection. I need to get the data types of the fields that are on that table, so I know how to generate my sql. What's the best way to get…
C. Ross
  • 31,137
  • 42
  • 147
  • 238
2
votes
1 answer

Pandas to_sql right truncation error

I'm trying to use Pandas to_sql to insert data from .csv files into a mssql db. No matter how I seem do it I run into this error: pyodbc.DataError: ('String data, right truncation: length 8 buffer 4294967294', '22001') The code I'm running looks…
Drew Huslig
  • 41
  • 5
2
votes
6 answers

How do I Display one Row for the lowest number of a column?

This question is complicated so examples would work best...I have the following table on ODBC, not SQL server Management NAME SEQNUM JOHN 2 JOHN 4 JOHN 7 MARY 12 MIKE 4 MIKE 9 PETER 7 PETER 12 So, i…
MrM
  • 21,709
  • 30
  • 113
  • 139
2
votes
0 answers

How to connect to SQL Anywhere database from linux?

I want to access to a SQL Anywhere database which is on another server. I can do it easily from Windows, but I need to do it from Debian now. All of this in php. Windows side : I have installed SQL anywhere driver from…
Nihiora
  • 21
  • 1
  • 5
2
votes
1 answer

Access frontend with SQL Server backend, works on some machines, not others

I'm in the midst of moving my company's timekeeping system from an old, slow Access backend to a snappy and quick SQL Server backend. What I'm finding though, is that while the frontend has no problem connecting to the backend on my machine or a…
Garrett Courtney
  • 31
  • 3
2
votes
2 answers

What database tool to use on Linux to read an as/400 database?

From Linux (Red Hat dist), we need to read an AS400 database. We have the ODBC driver to connect, what's the best query tool?
Anthony C
  • 1,990
  • 3
  • 23
  • 40
2
votes
1 answer

pyodbc + MySQL ODBC cannot deal with Unicode database name

I am using pyodbc 3.0.3 python 2.7.12 GNU/Linux 4.4.0-59-generic x86_64 Ubuntu 16.04.1 LTS (Xenial Xerus) unixODBC 2.3.1 ODBC 5.3(w) Driver When a try to pass a Unicode database name in the connection string I get the error A Unicode connection…
Sachin Aryal
  • 781
  • 14
  • 36
2
votes
0 answers

SAS to Google Bigquery using Simba ODBC Driver

Not able to connect from SAS to Google Bigquery using Simba ODBC Driver. OS:Linux ODBC.ini [GoogleBQ] Driver= Description=Simba ODBC Driver for Google BigQuery (64-bit) DSN …
Mahebunnisa Shaik
  • 21
  • 2
2
votes
1 answer

How do you remove linked server metadata cache when there are no defined linked servers?

Microsoft Linked Server instances cache metadata for faster query resolution. This does not get properly refreshed when the Progress Database resides on a remote server. Dropping the Linked Server instance does not remove the metadata cache. Any new…
kalaolani
  • 323
  • 1
  • 16
2
votes
1 answer

Update Query Timeout on SQL Server View with MS Access

I am having some trouble with updates to an SQL Server View through MS Access. The set of tables used for this is built off of a base table. This base table is of this format. Id int (not-nullable; auto-assigned) A1 varchar(50) (nullable) A2 …
Nathan M.
  • 286
  • 1
  • 9
1 2 3
…
99
100