Hi there,
I am using the RODBC library to connect to an Empress database.
I have installed the ODBC data source with the server DNs number and port, and
named the source "Trawl".
It is the odbcDriverConnect that seems to have the problem, and I suspect one
of the settings in my Data Source is wrong, or that my syntax to identify the
database is wrong. I have not set CodeSet or ODBC Version.
Here are the error messages.
1: In odbcDriverConnect("Trawl") :
[RODBC] ERROR: state 08001, code -256, message [Empress Software][ODBC
DLL]Unable to connect to data source
2: In odbcDriverConnect("Trawl") :
[RODBC] ERROR: state 01S00, code 0, message [Microsoft][ODBC Driver Manager]
Invalid connection string attribute
3: In odbcDriverConnect("Trawl") : ODBC connection failed
Can anyone point me in the right direction? Is there a specific syntax for
naming the database other than its name? It does bring up a GUI where I can
choose my data source and login, but then it just gives the errors above.
Any help is greatly appreciated.
Steve
Please consider the environment before printing this email.
NIWA is the trading name of the National Institute of Water & Atmospheric
Research Ltd.
[[alternative HTML version deleted]]
______________________________________________
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.
