Prof Brian Ripley wrote:
'odbcConnect' establishes a connection to the dsn, and
'odbcDriverConnect' allows a more flexible specification via a
connection string. 'odbcConnect' uses the connection string
'"DSN=dsn;UID=uid;PWD=pwd"'.
The point here seems to be that odbcConnect i
Prof Brian Ripley wrote:
Well, we don't know what you are doing! RODBC does work with system DSNs,
but did you try odbcDriverConnect? Let me read the help page for you
odbcDriverConnect("DSN=foo") works, but odbcConnect("foo") fails as
described earlier. Is this as intended?
This seems weird, be
On Sat, 4 Sep 2004, Jack Tanner wrote:
> Under WinXP, I have a system DSN called foo. It has stored
> username/password information. (I can click Configure in ODBC
> Administrator and then Test Data Source connects to MySQL without me
> re-entering data.)
>
> Using RODBC, I can connect to the
Under WinXP, I have a system DSN called foo. It has stored
username/password information. (I can click Configure in ODBC
Administrator and then Test Data Source connects to MySQL without me
re-entering data.)
Using RODBC, I can connect to the same database. But when I do
odbcConnect("foo"), I