Displaying 2 results from an estimated 2 matches for "y_database".
Did you mean:
my_database
2010 Jan 12
1
FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
...$ export ODBCSYSINI
(3) Start R
Note that R has inherited environment variable
> Sys.getenv("ODBCSYSINI")
ODBCSYSINI
"/home/jmarcus"
(4) Try to connect to the MySQL server
> conn <-
odbcDriverConnect(connection="Driver={MySQL};Server=my-server;Database=m
y_database;Uid=my_username;Pwd=my_password")
This generates following:
Warning messages:
1: In odbcDriverConnect(connection =
"Driver={MySQL};Server=my-server;Database=my_database;Uid=my_username;Pw
d=my_password") :
[RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver
Manager]Data...
2010 Jan 12
0
Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
...$ export ODBCSYSINI
(3) Start R
Note that R has inherited environment variable
> Sys.getenv("ODBCSYSINI")
ODBCSYSINI
"/home/jmarcus"
(4) Try to connect to the MySQL server
> conn <-
odbcDriverConnect(connection="Driver={MySQL};Server=my-server;Database=m
y_database;Uid=my_username;Pwd=my_password")
This generates following:
Warning messages:
1: In odbcDriverConnect(connection =
"Driver={MySQL};Server=my-server;Database=my_database;Uid=my_username;Pw
d=my_password") :
[RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver
Manager]Data...