Stack Overflow
Stack Overflow

Questions tagged [nanodbc]

nanodbc is a database access library written in C++ as a small wrapper for the native ODBC API in C.

12 questions
21
votes
11 answers

R DBI ODBC error: nanodbc/nanodbc.cpp:3110: 07009: [Microsoft][ODBC Driver 13 for SQL Server]Invalid Descriptor Index

I continue to read the DBI/ODBC is faster than RODBC, so I tried as follows: require(DBI);require(odbc) con <- DBI::dbConnect(odbc::odbc(), dsn = 'SQLSERVER1', database = 'AcumaticaDB') I can make a successful connection to the DSN, but the…
user2948714
  • 671
  • 2
  • 9
  • 13
13
votes
1 answer

how to find ODBC driver-specific arguments

Is there a way to programmatically discover the named arguments for ODBC connections? For instance, using the "ODBC Driver 17 for SQL Server", the ODBC Data Source Administrator (in Windows) allows for authentication using a "Login ID" and…
r2evans
  • 141,215
  • 6
  • 77
  • 149
4
votes
2 answers

Connect MS Access database to R

I want to connect MS Access database to R with DBI package. I try this: library(DBI) con <- dbConnect(odbc::odbc(), "BASE_MEPSA") and I have this error Error: nanodbc/nanodbc.cpp:950: HY024: [Microsoft][Pilote ODBC Microsoft Access] « (Inconnu)…
Roland Samati
  • 77
  • 1
  • 5
3
votes
1 answer

Could there be any language issue with a ODBC in R with an Access DB?

I am using an R Script which connects to a local Access database. For that, I used the 'odbc' package in R and created an odbc Driver in Windows. It works well on my machine. The issue I have is, that it can't connect to the database when running…
leonh
  • 33
  • 4
3
votes
1 answer

Connect R to MS Access 64bit Windows

I'm trying to connect R with an MS Access database on a Windows 7 64bit machine. library(RODBC) con <- odbcConnectAccess2007("M:/path/to/mydatabase/my.database.accdb") # [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager]…
mark
  • 537
  • 6
  • 25
2
votes
0 answers

Nanodbc: value doesn’t fit into type character(2) error

I have a postgresql table like CREATE TABLE "T" ( "D" timestamp without time zone NOT NULL, "C" character(2) NOT NULL, CONSTRAINT "PK" PRIMARY KEY ("D", "C") ) WITH ( OIDS=FALSE ); and insert into it with bucket nanodbc request. Like int…
Mikhail M
  • 929
  • 2
  • 10
  • 23
2
votes
1 answer

nanodbc connecting to MSSQL from Linux

I'm getting an "Invalid attribute value" when I try to connect to MSSQL from Linux. My current /etc/odbcinst.ini file looks as follows: [ODBC Driver 17 for SQL Server] Description=Microsoft ODBC Driver 17 for SQL…
nemo
  • 73
  • 1
  • 9
2
votes
1 answer

How do you access tables not in the default Oracle schema using dplyr?

With the release of dplyr 0.7.0, it is now supposedly easy to connect to Oracle using the odbc package. However, I am running into a problem accessing tables not inside the default schema (for me it is my username). For example, suppose there is the…
Alex
  • 15,186
  • 15
  • 73
  • 127
1
vote
0 answers

Queries containing table variable fail in Nanodbc

I have a query that declares a table variable. It seems nanodbc cannot fetch data although the query works fine when directly executed on SQL server. Does it mean complicated queries are not supported by nanodbc? Environment nanodbc version:…
Lee Gao
  • 11
  • 3
0
votes
0 answers

ODBC ANSI_WARNINGS warning message is breaking stored procedures

I think ANSI warnings are somehow breaking my stored procedure calling, and I'm trying to figure out how to fix it. DB Server: MS SQL Server 2008 Client: Ubuntu Bionic unixODBC Microsoft ODBC Driver 17 for SQL Server for Linux nanodbc I have a…
user42630
  • 1
0
votes
1 answer

How to read an escaped table in SQL Server from R DBI?

I was able to use DBI::dbWriteTable to write a table with a non-standard name [name@place:funny/pages], but I am unable to read it back in with DBI::dbReadTable. When I try with: dbReadTable(con, '[name@place:funny/pages]') I see the error: Error:…
wdkrnls
  • 4,548
  • 7
  • 36
  • 64
0
votes
1 answer

nanodbc error LNK2019: unresolved external symbol - on basic connection

I am attempting to connect to a MySQL database using ODBC driver using nanodbc library a C++ wrapper for ODBC but I am getting error LNK2019: unresolved external symbol I have added the path to installed library directory in additional library…
Dark Sorrow
  • 1,681
  • 14
  • 37