Creating a VBA connection string from an ODBC System DSN entry
Posted on 2011-09-08
Our DBA created the necessary ODBC entry for our database using the System DSN page.
The Connection Test passes and the one thing we needed to do was uncheck the Enable Query Timeout checkbox, which is checked by default.
Could someone please show me how to create a connection string that I can use in Excel 2007 to connect to the Oracle database with which this ODBC connection is linked?
It's an Oracle database. I am running Windows 7, and Excel 2007. The spreadsheet control is an Active X control.
In case its relevant, our DBA configured SQL Tools with that same connection and I have the following data available for each of the following fields:
Bypass tnsnames.ora (checkbox is checked)
Use Service instead of SID (checkbox is checked)