Problem Connecting to a DB HFSQL using ODBC


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


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...

Maybe this link could give you some insigth:

not really, it doesnt help on connection

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.