The DataDirect Oracle ODBC driver uses a connection string format that differs from the Microsoft Oracle ODBC driver. The connection string format used for Essbase Studio is designed for the DataDirect Oracle ODBC driver.
Note the following guidelines for using non-DSN connections:
The non-DSN connection to Oracle is intended for use with the DataDirect Wire Protocol ODBC driver only.
The non-DSN connection to IBM DB2 is intended for use with the DataDirect Wire Protocol ODBC driver only.
The non-DSN connection to Microsoft SQL Server is intended for use with both the Microsoft SQL Server ODBC driver and the DataDirect Wire Protocol ODBC driver.
The non-DSN connection to Teradata is intended for use with the native Teradata ODBC driver only. It is not intended for use with the DataDirect Wire Protocol ODBC driver.