After struggling to configure Windows 7 64 Bit ODBC to Oracle 11.2 using Oracle's native ODBC drivers, I found this is the way to setup the ODBC connection:
Parametric example
Data Source Name: TNSNAME_ENTRY_NAME_HERE
TNS Service Name: DOMAIN_HERE.SERVER_ADDRESS_HERE.COM:PORT_HERE/SID_HERE
User ID: USER_NAME_HERE
Example with values
Data Source Name: NORTHWIND
TNS Service Name: EXAMPLE.DOMAIN.COM:1521/NORTHWIND
User ID: JPICARD
No comments:
Post a Comment