Error when Getting Data from R Script which References MySQL Query

[RossP96]

I'm trying to run an R script in Power BI which connects to multiple sources and then runs a GLM to return predictions in a new dataframe. Im struggling with debugging some of the errors im getting.

The latest one is "Error in sqlQuery - first argument is not an open RODBC channel"

I have connected to the server initially in script:

con <- DBI::dbConnect(odbc::odbc(),
Driver = "{MySQL ODBC 8.0 ANSI Driver}",
Server = "server name",
UID ="username",
Database = "database",
PWD = "password",
Port = 3306)

I have then used the following at the start of the SQL query:

dataframe_name <- sqlQuery (con,

"SELECT.....

Any ideas why im getting this error?

Thanks

[Anonymous]

Hi @RossP96 ,

There are some similar topic, please take a look.

https://informatics-support.perkinelmer.com/hc/en-us/articles/4408237205140--Unable-to-translate-byt... 

https://support.tibco.com/s/article/Unable-to-translate-bytes-E9-at-index-1-from-specified-code-page... 

https://stackoverflow.com/questions/39076157/unable-to-translate-bytes-fc-at-index-35-from-specified... 

Best Regards,

Jay

[RossP96]

Update: ive now got the above working by moving to dbGetQuery, which is working for my first query. However the second query is giving me the error "Unable to translate bytes [A3] at index -1 from specified code page to Unicode." I've had a look online and cant see much for this error, any ideas?