moonknightt
Programmer
Does anyone know the differences or the benefits of using either of these in CR 10 or XI
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle provider for Ole DB vs Oracle Native connection
- Thread starter moonknightt
- Start date
- Status
Hi,
The general KISS rule applies..simplest is usually best..The Native connection ( SqlNet) is more likely to be able to use Oracle-specific functions than any other method and has fewer layers involved..All other connection methods use it eventually, so I prefer to use it directly.
If you had a JAVA connection ( or a thin-client wire-protocol ODBC driver) you could avoid even using SqlNet- there are some ODBC drivers available that use that technology..
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
The general KISS rule applies..simplest is usually best..The Native connection ( SqlNet) is more likely to be able to use Oracle-specific functions than any other method and has fewer layers involved..All other connection methods use it eventually, so I prefer to use it directly.
If you had a JAVA connection ( or a thin-client wire-protocol ODBC driver) you could avoid even using SqlNet- there are some ODBC drivers available that use that technology..
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question