Advice on connections

[Willie Neal]

Is it possible to have an ado.net connection object that would connect to
both SQL Server 2000 and Oracle.

Thanks,

Will.

 

[William Ryan eMVP]

You could use OleDb or ODBC COnnection, but both of these will be much
slower and provide less functionality than the provider specific
equivalents. What I'd recommend is using a Factory pattern to create the
respective connections. This article shows you how to do it:
http://www.vbdotnetheaven.com/Code/Jun2003/2043.asp

HTH,

Bill