Advice on connections

  • Thread starter Thread starter Willie Neal
  • Start date Start date
W

Willie Neal

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

Thanks,

Will.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting to Oracle database 2
Most Common Errors 1
Sql Server Express won't let me connect 8
SQL Autentification: Is the password encrypted when is is being send to the server for validation? 1
Cannot display ODBC login prompt - want to connect without DSN 31
Using SMO with Oracle? 3
Count all records for all tables 5
ADO.NET connection 6

Back
Top