Questions about dbi
Read more about dbi
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
SQL Joining Tables from 2 Different Servers: R vs SAS
I have set up two different connections in R:
connection_1 <- dbConnect(odbc::odbc(), driver = my_driver, database = "database_1", uid = "my_id", pwd = "my_pwd", serve...
stats_noob
Votes: 0
Answers: 1
Connect R to DB ORA -12560
I've the error ORA - 12560 when I try connect to Oracle DB installed on VM.
sql*plus, pl/sql, excel - connect successfully
Сonnection code in R
con <- dbConnect(odbc::odbc(), driver ='Oracle in i...
Akalit
Votes: 0
Answers: 1
R SQL templating with glue_sql, ability to dynamically drop where clause
TLDR
I would like to be able to template SQL queries and run them in R. The glue package and DBI work great, but I can't figure out a way to template statements. In other words, is there a way to do s...
Mark Druffel
Votes: 0
Answers: 2
Specify another Windows account than session one when using DBI::dbConnect() and MS SQL Windows Authentication?
I am in a corporate environment.
I can easily establish a connection between R and a SQL database thanks to DBI and odbc packages this way:
con <- DBI::dbConnect(
odbc::odbc(),
driver = SQL.dri...
yeahman269
Votes: 0
Answers: 0