Re: [R] FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
Ok.
Caveman
On Thu, Jan 14, 2010 at 5:19 PM, Marcus, Jeffrey
jeffrey.mar...@nuance.com wrote:
Orvalho:
Thanks for pointing our RMySQL. The reason is that we have similar data
stored in both SQL server and MySQL databases and I want to reuse code as
much as possible.
Jeff
-Original Message-
From: Orvalho Augusto [mailto:orvaq...@gmail.com]
Sent: Wednesday, January 13, 2010 10:57 PM
To: Marcus, Jeffrey
Cc: r-help@r-project.org
Subject: Re: [R] FW: Problems connecting with MySQL using odbcDriverConnect
(RODBC package) on Linux
Thanks you solved and share with us.
But, why don't you use the RMySQL, which connects to MySQL without the
need of ODBC?
Caveman
On Wed, Jan 13, 2010 at 1:48 AM, Marcus, Jeffrey
jeffrey.mar...@nuance.com wrote:
I think I figured this out. I should not have put the Driver name in
braces. Changing it from {MySQL} to MySQL seems to work.
-Original Message-
From: Marcus, Jeffrey
Sent: Tuesday, January 12, 2010 6:09 PM
To: 'r-help@r-project.org'
Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC
package) on Linux
I am sure I'm doing something wrong here but not sure what.
Our system administrator recently installed UnixODBC and the MyODBC
driver on a Linux box running Linux version 2.6 x86_64.
I have an .odbc.ini file in my home directory with following lines:
[mydb]
Description = MySQL server on my-server
Driver=/usr/lib64/libmyodbc3.so
SERVER=my-server
I can successfully do the following:
library(RODBC)
channel - odbcConnect(mydb)
sqlQuery(channel, show databases)
And in general, I have no problems using odbcConnect to connect to the
mydb DSN.
However, for various reasons I want to make a DSN-less connection
using odbcDriverConnect. However, everything I've tried generated a
data source not found message (see below for details)
After reading through various documents, I tried doing following.
(1) Put an odbcinst.ini file in my home directory with following lines
[MySQL]
Description = ODBC for MySQL
Driver=/usr/lib64/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1
(2) Install it with odbcinst -i -f. This seems to work as when I type
odbcinst -j I get
DRIVERS: /home/jmarcus/odbcinst.ini
SYSTEM DATA SOURCES: /home/jmarcus/odbc.ini
USER DATA SOURCES..: /home/jmarcus/.odbc.ini
(2) Set the environment variable to point to this file:
bash-3.2$ ODBCSYSINI=/home/jmarcus
bash-3.2$ 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 source name not found, and no default driver specified
2: In odbcDriverConnect(connection =
Driver={MySQL};Server=my-server;Database=my_database;Uid=my_username;Pw
d=my_password) :
ODBC connection failed
Can anyone see what I'm doing wrong? Thanks.
Jeff
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
--
OpenSource Software Consultant
CENFOSS (www.cenfoss.co.mz)
SP Tech (www.sptech.co.mz)
email: orvaq...@cenfoss.co.mz
cell: +258828810980
--
OpenSource Software Consultant
CENFOSS (www.cenfoss.co.mz)
SP Tech (www.sptech.co.mz)
email: orvaq...@cenfoss.co.mz
cell: +258828810980
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
Orvalho:
Thanks for pointing our RMySQL. The reason is that we have similar data
stored in both SQL server and MySQL databases and I want to reuse code as much
as possible.
Jeff
-Original Message-
From: Orvalho Augusto [mailto:orvaq...@gmail.com]
Sent: Wednesday, January 13, 2010 10:57 PM
To: Marcus, Jeffrey
Cc: r-help@r-project.org
Subject: Re: [R] FW: Problems connecting with MySQL using odbcDriverConnect
(RODBC package) on Linux
Thanks you solved and share with us.
But, why don't you use the RMySQL, which connects to MySQL without the
need of ODBC?
Caveman
On Wed, Jan 13, 2010 at 1:48 AM, Marcus, Jeffrey
jeffrey.mar...@nuance.com wrote:
I think I figured this out. I should not have put the Driver name in
braces. Changing it from {MySQL} to MySQL seems to work.
-Original Message-
From: Marcus, Jeffrey
Sent: Tuesday, January 12, 2010 6:09 PM
To: 'r-help@r-project.org'
Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC
package) on Linux
I am sure I'm doing something wrong here but not sure what.
Our system administrator recently installed UnixODBC and the MyODBC
driver on a Linux box running Linux version 2.6 x86_64.
I have an .odbc.ini file in my home directory with following lines:
[mydb]
Description = MySQL server on my-server
Driver=/usr/lib64/libmyodbc3.so
SERVER=my-server
I can successfully do the following:
library(RODBC)
channel - odbcConnect(mydb)
sqlQuery(channel, show databases)
And in general, I have no problems using odbcConnect to connect to the
mydb DSN.
However, for various reasons I want to make a DSN-less connection
using odbcDriverConnect. However, everything I've tried generated a
data source not found message (see below for details)
After reading through various documents, I tried doing following.
(1) Put an odbcinst.ini file in my home directory with following lines
[MySQL]
Description = ODBC for MySQL
Driver=/usr/lib64/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1
(2) Install it with odbcinst -i -f. This seems to work as when I type
odbcinst -j I get
DRIVERS: /home/jmarcus/odbcinst.ini
SYSTEM DATA SOURCES: /home/jmarcus/odbc.ini
USER DATA SOURCES..: /home/jmarcus/.odbc.ini
(2) Set the environment variable to point to this file:
bash-3.2$ ODBCSYSINI=/home/jmarcus
bash-3.2$ 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 source name not found, and no default driver specified
2: In odbcDriverConnect(connection =
Driver={MySQL};Server=my-server;Database=my_database;Uid=my_username;Pw
d=my_password) :
ODBC connection failed
Can anyone see what I'm doing wrong? Thanks.
Jeff
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
--
OpenSource Software Consultant
CENFOSS (www.cenfoss.co.mz)
SP Tech (www.sptech.co.mz)
email: orvaq...@cenfoss.co.mz
cell: +258828810980
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
Thanks you solved and share with us.
But, why don't you use the RMySQL, which connects to MySQL without the
need of ODBC?
Caveman
On Wed, Jan 13, 2010 at 1:48 AM, Marcus, Jeffrey
jeffrey.mar...@nuance.com wrote:
I think I figured this out. I should not have put the Driver name in
braces. Changing it from {MySQL} to MySQL seems to work.
-Original Message-
From: Marcus, Jeffrey
Sent: Tuesday, January 12, 2010 6:09 PM
To: 'r-help@r-project.org'
Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC
package) on Linux
I am sure I'm doing something wrong here but not sure what.
Our system administrator recently installed UnixODBC and the MyODBC
driver on a Linux box running Linux version 2.6 x86_64.
I have an .odbc.ini file in my home directory with following lines:
[mydb]
Description = MySQL server on my-server
Driver=/usr/lib64/libmyodbc3.so
SERVER=my-server
I can successfully do the following:
library(RODBC)
channel - odbcConnect(mydb)
sqlQuery(channel, show databases)
And in general, I have no problems using odbcConnect to connect to the
mydb DSN.
However, for various reasons I want to make a DSN-less connection
using odbcDriverConnect. However, everything I've tried generated a
data source not found message (see below for details)
After reading through various documents, I tried doing following.
(1) Put an odbcinst.ini file in my home directory with following lines
[MySQL]
Description = ODBC for MySQL
Driver=/usr/lib64/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1
(2) Install it with odbcinst -i -f. This seems to work as when I type
odbcinst -j I get
DRIVERS: /home/jmarcus/odbcinst.ini
SYSTEM DATA SOURCES: /home/jmarcus/odbc.ini
USER DATA SOURCES..: /home/jmarcus/.odbc.ini
(2) Set the environment variable to point to this file:
bash-3.2$ ODBCSYSINI=/home/jmarcus
bash-3.2$ 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 source name not found, and no default driver specified
2: In odbcDriverConnect(connection =
Driver={MySQL};Server=my-server;Database=my_database;Uid=my_username;Pw
d=my_password) :
ODBC connection failed
Can anyone see what I'm doing wrong? Thanks.
Jeff
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
--
OpenSource Software Consultant
CENFOSS (www.cenfoss.co.mz)
SP Tech (www.sptech.co.mz)
email: orvaq...@cenfoss.co.mz
cell: +258828810980
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[R] FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
I think I figured this out. I should not have put the Driver name in
braces. Changing it from {MySQL} to MySQL seems to work.
-Original Message-
From: Marcus, Jeffrey
Sent: Tuesday, January 12, 2010 6:09 PM
To: 'r-help@r-project.org'
Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC
package) on Linux
I am sure I'm doing something wrong here but not sure what.
Our system administrator recently installed UnixODBC and the MyODBC
driver on a Linux box running Linux version 2.6 x86_64.
I have an .odbc.ini file in my home directory with following lines:
[mydb]
Description = MySQL server on my-server
Driver=/usr/lib64/libmyodbc3.so
SERVER=my-server
I can successfully do the following:
library(RODBC)
channel - odbcConnect(mydb)
sqlQuery(channel, show databases)
And in general, I have no problems using odbcConnect to connect to the
mydb DSN.
However, for various reasons I want to make a DSN-less connection
using odbcDriverConnect. However, everything I've tried generated a
data source not found message (see below for details)
After reading through various documents, I tried doing following.
(1) Put an odbcinst.ini file in my home directory with following lines
[MySQL]
Description = ODBC for MySQL
Driver=/usr/lib64/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1
(2) Install it with odbcinst -i -f. This seems to work as when I type
odbcinst -j I get
DRIVERS: /home/jmarcus/odbcinst.ini
SYSTEM DATA SOURCES: /home/jmarcus/odbc.ini
USER DATA SOURCES..: /home/jmarcus/.odbc.ini
(2) Set the environment variable to point to this file:
bash-3.2$ ODBCSYSINI=/home/jmarcus
bash-3.2$ 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 source name not found, and no default driver specified
2: In odbcDriverConnect(connection =
Driver={MySQL};Server=my-server;Database=my_database;Uid=my_username;Pw
d=my_password) :
ODBC connection failed
Can anyone see what I'm doing wrong? Thanks.
Jeff
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
