Stack Overflow
Stack Overflow

Questions tagged [dbconnect]

19 questions
2
votes
1 answer

error in evaluating the argument 'drv' in selecting a method for function 'dbConnect': could not find function "MySQL"

I am getting an error message " error in evaluating the argument 'drv' in selecting a method for function 'dbConnect': could not find function "MySQL"" Here is the part of the code: library(DBI) conn <- dbConnect( drv = RMySQL::MySQL(), dbname =…
Mahmood
  • 21
  • 1
  • 2
1
vote
1 answer

Batch executing query in RPostgres returning same data

I am currently trying to download a large database using RPostgres - however, when I try to write the results to csvs in batches, it writes the same data over and over (always the first 1M records). Here is the code I am currently using: wrds <-…
mhohaus
  • 11
  • 1
1
vote
0 answers

How can a java application running within a Fargate container connect to Aurora Postgresql db?

We have a java application running in a Fargate container and this application needs to connect and have limited access to the Aurora Postgesql DB. How can this java application connect to Aurora Postgres DB? I thought of creating a user account…
Vidya
  • 11
  • 2
1
vote
1 answer

DB Connect and workspace notebooks returns different results

I'm using DB Connect 9.1.9. My cluster version is 9.1LTS with a single node (for test purposes). My data is stored on a S3 as a delta table. Running the following: df = spark.sql("select * from where runDate >= '2022-01-10 14:00:00' and…
Arthur Clerc-Gherardi
  • 495
  • 1
  • 3
  • 16
1
vote
0 answers

connecting to clickhouse in R

I am new to clickhouse. I am trying to set connection in the following way: library(DBI) con <- dbConnect(clickhouse::clickhouse(), host="localhost", port=8123L, user="default", password="") but I get this error: Error in…
Bahman Ajdari
  • 39
  • 5
1
vote
0 answers

R: NULL value passed as symbol address, error in .Call(RS_PostgreSQL_init, config.params, force) :

I'm new to stackoverflow, so please forgive me if this is not the right place for my question. When I set up a connectin with PostgreSQL via RPostgreSQL package i get the following error: error in .Call(RS_PostgreSQL_init, config.params, force)…
F Black
  • 19
  • 2
1
vote
1 answer

Connect to Firebird DB via ODBC

I am trying to connect to a firebird DB via ODBC. I have an working ODBC Windows Connection (ODBC Data Sources 32 Bit) and also an established connection via Tableau. I tried using dbConnect but was not able to set the right parameters I guess. I…
Holmer
  • 11
  • 3
0
votes
0 answers

Warning: uses an old dbplyr interface

I'm trying to suppress the following warning Warning: uses an old dbplyr interface ℹ Please install a newer version of the package or contact the maintainer This warning is displayed once every 8 hours. I know the code that…
cashes11
  • 1
  • 2
0
votes
0 answers

How do I get R to find dbConnect function?

Hi, I seem to be having trouble with RSQLite and dbConnect. DBI and RSQlite appear to be active in the packages but continue to receive the message that the dbConnect function isn't found. Any suggestions would be appreciated. Thanks! ajamsterdam
ajamsterdam
  • 1
0
votes
0 answers

How to add query count of the result fetched at the footer while spooling file using unix shell script

I am trying to write unix shell script in which i want to connect to db and fetch the query result in tab delimited format. Also required to add query result count at the footer. Query.sql Select id, empname from…
PAS
  • 41
  • 5
0
votes
0 answers

py4j.protocol.Py4JJavaError when converting RDD to pyspark dataframe with dbconnect

I am trying to create a new data frame and get an error. I've managed to find the most basic form of code that returns the error: spark.sparkContext.parallelize([('a', 'b')]).toDF().show() I have managed to run this specific code and of course this…
Miel
  • 1
  • 1
0
votes
0 answers

I have 2 main dbs and i want to create one as a connection of those two

I have a simple project in mind. 2 apps with 2 seperate databases (sql server) I want to have a third db that stores the information i want from db2 (lets call it Item Info) into a table Tb1 and when there is an insert on db1 (lets call it orders)…
Nikos Papaefstathiou
  • 24
  • 2
0
votes
1 answer

R teradata DBI:dbConnect() error: TimedOut: No response received when attempting to connect to the Teradata server

I am going to ask and answer this question because I spent more time than I'd like to admit searching for a response and couldn't find one. I installed Teradata ODBC Driver 16.20. In the ODBC Data Source Administrator, I added a Data Source. I named…
user3866200
  • 113
  • 1
  • 1
  • 5
0
votes
1 answer

dbConnect works in Rstudio.exe and RGui.exe but fails as an executable in RScript.exe

I am trying to create a RScript file that can be run like an executable. I have R code that connects to a Microsoft Azure SQL Server database which uses active directory password authentication, queries the database, and writes a csv report. I…
Joshua Maxwell
  • 11
  • 1
0
votes
1 answer

How can I install the dbconnect module in Python?

I am VERY new to python (as in I just started yesterday, but I have used R in the past) and I'm trying to install this module (https://github.com/CellProfiler/CellProfiler-Analyst/find/master) but in order for me to do that I have to install a…
momonotmorg
  • 1
1
2