Databases
StackOverflow2013
Postsdbo
POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
    primarykey
    data
    text
    <p>I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various attempts, we've decided that the simplest series of steps for a clean installation include:</p> <ol> <li>Set up an Oracle Instant Client</li> <li>Install the accompanying ODBC driver</li> <li>(Test the connection using EZCONNECT via SQL Plus)</li> <li>(Test the connection by creating a Windows DSN)</li> </ol> <p>Everything up to here works fine. Problem is, I cannot figure out the syntax to tell ADO to use the <em>instant client</em> ODBC driver, which appears in my ODBC driver list as "Oracle in MyTest" (no quotes). Using the MSFT ODBC driver with EZConnect as <a href="https://stackoverflow.com/questions/782181/connect-to-an-oracle-10g-database-with-microsoft-odbc-for-oracle">this post</a> suggests does not work any better than it did prior to setting up the instant client (which is to say, not at all). But <a href="https://stackoverflow.com/questions/1272998/do-i-still-need-to-install-oracle-client-if-using-microsoft-odbc-for-oracle-to-co">this post</a> seems to suggest it's possible, without stating exactly how, and <a href="http://www.connectionstrings.com/oracle#p12" rel="nofollow noreferrer">connectionstrings.com</a> only tells you what the Data Source portion of the string looks like, i.e. SomeUser/SomePassword@AServer:PortNumber/InstanceName</p> <p>Short version: What is the exact syntax of a classic ADO connection string referencing an instant client ODBC driver?</p> <p>Thanks in advance for your help. Took me a stupid long time to get going with SO...</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USdownwitch
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis post http://forums.oracle.com/forums/thread.jspa?threadID=621679&tstart=90 seems to explain why MSFT's ODBC driver doesn't like the ORCL instant client--it delivers dlls it doesn't support for ODBC without including their dependencies. Unfortunately nothing I could do would get MSFT's driver to see those dependencies even once I copied them in to the IC folder.
      singulars
      1. POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
      1. USdownwitch
    2. COAt work (I am at home now, my timezone is CET) we do this all the time. There is (an existing) Access DB and sometimes when a new Oracle DB gets added I basically add in control center an ODBC connection (somwhat like described here http://support.microsoft.com/kb/303968) next I go and then go copy the passthru object in the Access DB and change the DB name in this endlessly long string. I guess you are looking for this long string. Well if your question is still unanswered tomorrow I might need to paste that string and it might help.
      singulars
      1. POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
      1. UShol
    3. COThanks for your help, but I'm actually looking to connect directly to the Oracle server in its "most native" syntax, which is either EZ Connect or a kind of connection-string embedded TNS like this article describes using http://www.codeproject.com/KB/vbscript/connection_string.aspx but which fails as I describe in my first comment.
      singulars
      1. POConnection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
      1. USdownwitch
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload