View Single Post

  #9 (permalink)  
Old 03-24-2008, 03:02 PM
bobby21 bobby21 is offline
Junior Member
 
Join Date: Mar 2008
Posts: 12
bobby21 is on a distinguished road
Answer for eighth question:
sqlconnection interacts with the database directly,whereas oledbconnection needs oledb standard interface(com based) for interacting with the database.
sqlconnection can interact only with sql server database,whereas oledbconnection can interact with any database.
sqlconnection doesn't need sql provider for interacting with sql server 7.0 (and above).where as, oledbconnection needs oledb data provider for interacting with database.
Reply With Quote