search

ankane / dbx

A fast, easy-to-use database library for R
Other
187 stars 15 forks source link

rsqlite TRUE/FALSE error #10

Closed JARS3N closed 5 years ago

JARS3N commented 5 years ago

trying to connect to a MySQL db and getting this error

db <-dbxConnect(
    adapter = 'mysql',
    dbname = "table",
    url = "url",
    variables=list(
    user = "user",
    port = 3306,
    password = "pwd")
  )

"Error in if (adapter == "rsqlite") { : missing value where TRUE/FALSE needed"

ankane commented 5 years ago

Hi @JARS3N, thanks for reporting 👍 I believe the issue is the URL you're passing is invalid. I pushed a change to master to give a better error message. You'll typically want to use either adapter or url, not both. Also, user, port, and password shouldn't be nested in variables.