Graham,
nice package this :-)-O.
It was easy to set up MySQL but I struggled immensely to get the stock
ODBC working with PostgreSQL (8.3), which has been discussed on the
mailing list before (Prof Brian):
Warning messages:
1: In odbcDriverConnect(st, ...) :
[RODBC] ERROR: Could not SQLDriverConnect
2: In odbcDriverConnect(st, ...) : ODBC connection failed
aka (DBD::ODBC in Perl)
Missing server name, port, or database name in call to CC_connect.
(SQL-IM002)
aka (iodbctest)
SQLDriverConnectW = Unknown connect option (Set) (205) SQLSTATE=S1009
Figured it out, though:
Leopard comes with iODBC installed, and many people install unixODBC
additionally.
Then then configure /sw/etc/odbc*.ini and unixODBC works, but iODBC
doesn't.
Even if you symlink the INI files to /Library/ODBC it doesn't work.
Even if you
remove theunixODBC installation and only use the /Library/ODBC/
odbc*.ini files
it doesn't work. Even if you copy libodbcpsql.so and libodbcpsqlS.so
from
/sw/lib/ to /usr/local/lib/ and then remove unixODBC (through fink) it
doesn't
work.
However, if you leave the two libs in /usr/local/lib after removel of
unixODBC
install the libiodbc/libiodbc-shlibs packages from fink, and then
symlink the
ini files to /sw/etc, it *DOES* work.
Leading me to suspect the version of iODBC that comes with 10.5.5 (and
earlier)
is broken. Since Google is my friend I know that the CC_connect issue
is also
prevalent on linux so I reckon it's not Mac specific.
All in all this is extremely cool, because I will have to use a
firebird database
for my practice management software which doesn't have a direct R
driver but now
I am confident will be able to use it (with the Read Only option :-)-
O) to analyse
my ICD and Procedure Codes :-)-O
Three Requests for Features for rattle(): would it not be nice to also
have direct
PostgreSQL (RdbiPgSQL) and MySQL (RMySQL) support and support for a
SELECT statement?
In other words, sometimes the database tables directly don't give you
what you need
and so you have to develop a (convoluted) SQL statement first.
Would be nice if one could ratlle(convolutedSQL) :-)-O
greetings, el
--
Dr. Eberhard W. Lisse \/ Managing Member, |Ondis (cc)
accou...@ondis.co.na/ * | Telephone: +264 81 124 6733 (cell)
PO Box 98256 \ /Please do NOT send e-mail to e...@lisse.na
Windhoek Namibia ;/ if it is in ANY way DNS/|Ondis related
--
Dr. Eberhard W. Lisse \/ Obstetrician Gynaecologist (Saar)
e...@lisse.na el108-ARIN / * | Telephone: +264 81 124 6733 (cell)
PO Box 8421 \ / Please send DNS/NA-NiC related e-mail
Bachbrecht, Namibia ;/ to dns-ad...@na-nic.com.na
__
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.
