Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE Dd OR NATIVE ORACLE

Status
Not open for further replies.

crystalize

Vendor
Nov 20, 2007
26
US
How do I tell whether I am using ole db or Oracle Native?
Crystal 9 and Oracle 8i.
 
Go to your database menu, database expert, current connections.

Right-click on your connection. Properties.

If it is Oracle Native it will say "Database Type: Oracle Server". If it is OLE, it will say OLE, If it is ODBC it will say ODBC.

The first being the least helpful of these, since they're all hooking up to Oracle.

Native will show a 'service', ODBC will show a 'datasource name' and a 'UseDSNProperties', Ole will show a 'provider'.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top