Find knowledge base article(s) by searching for keywords in the title e.g. type linux in the search box below
Find knowledge base article(s) by browsing the subject categories of articles
Technology quick references, cheatsheets, user manuals etc.
Shop Online through ShopifyLite
Tutorials on various IT applications.
Search Title    (UL:0 |SS:f)

Software >> Development >> API >> ADO >> How to make ADODB work with Oracle 8i database

1. Make sure MDAC 2.1 or later installed (this provides the OLEDB provider for Oracle 2. Make sure (Oracle) Net8 client is installed that the connection to the Oracle 8i database server is tested from this client eg. using PL/SQL on that client machine 3. In the ADO code, specify the ADODB connection string as = "Provider=OraOLEDB.Oracle;User ID=user;Password=password; Data source=net8_connect_string_in_tnsnames_ora;" eg. = "Provider=OraOLEDB.Oracle;User ID=user;Password=****; Data source=<your oracle server hostname>;"
[ © 2008-2021 myfaqbase.com - A property of WPDC Consulting ]