Wrox Home  
Search P2P Archive for: Go

  Return to Index  

ado_dotnet thread: Using ADO.NET to connect diff db's


Message #1 by Daniel Eriksson <d.eriksson@g...> on Thu, 13 Dec 2001 09:03:21 -0800
Hi all,



Question for you?

How can have the same db code with ADO.NET. With ADO I can use the same 

ADODB.Connection, ..Command, ...Recordset and so on for different db's (any 

ODBC compliant db. ei AS400, MSSQLxx, MySql)

Can I still use ADO.NET or do I need to use System.Data.OleDb?



If not.. why?



Thanks

/Daniel



Message #2 by "Fredrik Normén" <fnormen@h...> on Tue, 18 Dec 2001 14:48:26
Hi,



I will try to answer your question, but I don't realy understand what you 

are after. I hope this will give the answer you are asking for.



To connect to a ODBC compliant DB you have to use the OleDb data provider 

(System.Data.OleDb) with is a part of ADO.Net



You can still use ADO 2.x in .Net if you rather like to do that.



/Fredrik Normén



> Hi all,

> 

> Question for you?

> How can have the same db code with ADO.NET. With ADO I can use the same 

> ADODB.Connection, ..Command, ...Recordset and so on for different db's 

(any 

> ODBC compliant db. ei AS400, MSSQLxx, MySql)

> Can I still use ADO.NET or do I need to use System.Data.OleDb?

> 

> If not.. why?

> 

> Thanks

> /Daniel

> 


  Return to Index