Connection from Rstudio to Informix database with JDBC

[Miguelanezg]

I have tried of connect from Rstudio using RJDBC to an Informix database but I have not really managed to do it, someone know or has made this type of
connection that explains how the connection string and environment variables.
I have found some information in the cloud but it has not worked for me.

Thanks.

[alexkgold]

Hi @Miguelanezg,

We recommend using the odbc package to connect to databases because then you don't have to worry about a Java installation. There's a lot of information on using odbc at db.rstudio.com.

[Miguelanezg]

Thank you very much for your prompt response, but with OBDC we have already done it and it works very well, we are really looking to do it with JDBC because it is necessary for other applications that we need to implement.