Which connection type should I use?

[email protected] · January 25th, 2005, 05:22 PM

I'm using an oracle database and VS2005. Which connection type should I be using to get the best results in my queries: odbc, dsn, oledb? and should I use native oracle connections or microsoft for oracle?

Also...is there a way to use the GUI in VS2005 to select the fields in sql statement, rather than having to specify sql statement manually. The GUI works perfectly for SQLServer...

GREG LANDGRAF
APPLICATION EXPERT
Computerized Facility Integration (CFI)
20 N Wacker Drive, Suite 2600, Chicago, IL 60601
OFFICE:  312.236.2323 x 6854
MOBILE: 847.721.3027
FAX:       &nbs p;312.236.2336
EMAIL:   [email protected]
Facilities Technology - Better, Faster and Cheaper!

evandro.paula · February 2nd, 2005, 12:45 PM

OleDb was sanctioned to Oracle and Access databases by Microsot, but don't forget this data provider it more generic (it has to manage 2 different databases), so you're going to get a lower performance.
In order to get a best performance in your application, you should use the .NET Framework Data Provider for Oracle.
It can be downloaded through the address: http://www.microsoft.com/downloads/d...displaylang=en