Provider for Oracle database

[Harshil]

I am developing an application in VB .NET and Oracle 8i.
I am exactly not sure about what provider should I use
for my database.

Which one would give the best performance and also will
not have any conflicts from moving from Oracle 8i to
oracle 9i in the near future.

Any help would be appreciated

Thanks

 

[Raja Balaji R]

Hi,

There are 2 provider for using one is "Oracle OLEDB
Provider" and another is "Oracle .NET Provider".

You can use any one of this, both are supplied by oracle
itself.

Better use oracle .net provider.

Regards
Raja Balaji R

 

[Paul Clement]

¤ I am developing an application in VB .NET and Oracle 8i.
¤ I am exactly not sure about what provider should I use
¤ for my database.
¤
¤ Which one would give the best performance and also will
¤ not have any conflicts from moving from Oracle 8i to
¤ oracle 9i in the near future.
¤

Oracle's ODP.NET would likely have the best support for both versions although you would need to use
the Oracle 9i release 2 client.

http://otn.oracle.com/sample_code/tech/windows/odpnet/content.html


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)