Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

sqlquery doesn't work with RODBC

Open
#1 4 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
45/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
r, sql
Domain
databases

Research direction

Reproduce the issue using the RODBC connection example and start at the sql_query entry point, following its call to dbListTables. Determine what is required for RODBC compatibility; done means the example no longer raises the inherited-method error when sql_query receives an RODBC connection.

Written by the indexing model from the issue text.

Description

Bonjour ;)

DreamRs/sqlquery could be helpful but it doesn't work with RODBC.

library(RODBC)
library(RODBCext)
connexion_bdd_odbc_txt<- 'driver={ODBC Driver 17 for SQL Server}; server=xxxx,yyyy;database=ma_base_de_donnee;uid=uuuu;pwd=pppp;')
connexion_bdd<-odbcDriverConnect(connexion_bdd_odbc_txt)
library(sqlquery)
sql_query(conn = connexion_bdd)
Error in (function (classes, fdef, mtable)  : 
  unable to find an inherited method for function ‘dbListTables’ for signature ‘"RODBC"’
Dominant language
JavaScript
Stars
29
Forks
11
PR merge metrics
No merged PRs in 30d

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from dreamRs/sqlquery

All issues in dreamRs/sqlquery

Similar issues

More JavaScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.