Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Connect to Oracle with installing Oracle Client (Read 4684 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Connect to Oracle with installing Oracle Client
17.05.06 at 11:42:11
 
How to connect to Oracle without installing the Oracle Client software
 
Greg from the UK asked the following question:
 
Question:
I've installed and activated the software successfully.  Just one question though do I need to have an Oracle client installed?
 
Answer:
No you do not. To connect to Oracle you can use the Oracle Instant Client software (Oracle IC). The Oracle IC is a set of files that do not need installing, just unzipping. It is very small too. I recall it is 5-10MB or so.  
Please remember that you need the Oracle IC software and the IC ODBC component that is also shipped by Oracle for free.
 
To connect with SQL*XL through the Oracle IC please follow the same steps as you would do when you would connect to Oracle through ODBC.
 
References:
Excel Oracle Instant Client (IC) Connection
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/oracle_ic.html
Oracle Instant Client (Oracle IC) downloads
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
Oracle connection problems
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130748978
Oracle client and networking components missing
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1144399335
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
OLEDB: Oracle Instant Client
Reply #1 - 08.01.09 at 22:10:18
 
OLEDB: Oracle Instant Client
 
A SQL*XL user just reported that the Microsoft OLE DB provider for Oracle is available with the Oracle Instant Client. So not only the ODBC driver seems included also the OLE DB provider.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1