Is this an issue with my application server the interface is on or the SQL server?
SQLDriverConnect [C][IM002]: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ICU > rdbodbc > DSN Settings > DSN:
RDBMS Interface user manual says following.
For the ODBC connection, the Data Source Name (DSN) must be created via the ODBC Administrator (the Data Sources ODBC icon in Windows Control Panel). This DSN name is then passed within the start-up parameters of the interface; example: /DSN=OracleX.
If you are using an ODBC data source to establish the connection, the data source MUST be a System DSN.
Have you configured DSN correctly from ODBC Administrator utility? If you runs on 64bit, check following KB.
KB00262 - How to configure the PI RDBMS Interface to run on the 64-bit Windows Operating System
Yes I configure the DSN and tested it. It test successfully, but when starting the interface I get the error.
ok not sure what I did differently this time but I got it now. thanks
Retrieving data ...