Problem Connecting to a DB HFSQL using ODBC

General
1

Hi,

I'm trying to connect a database from HyperfileSQL (HFSQL) in Rstudio with an ODBC connector.
Here is the code i used :

library(DBI)
library(odbc)

connexion<- DBI::dbConnect(odbc::odbc(),
                 Driver = "HFSQL",
                 Server = "server ip",
                 Database = "data base name",
                 UserName = "username",
                 Password = "password",
                 )

I get " Error: nanodbc/nanodbc.cpp:1021: S1000: Impossible to connect the caractere chain is unsuficcient"
I have no idea why...

2

Maybe this link could give you some insigth:
https://solutions.rstudio.com/db/r-packages/odbc/

3

not really, it doesnt help on connection

4

This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.