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]]

