why does configuring a dataAdapter create a new sqlConnection

• david myers-292056

  SSC-Addicted

  Points: 413

  More actions

  February 13, 2006 at 7:21 am

  #170592

  Hi,

  I've created an sqlConnection for my sql server database, and as I understand it you only need 1 sqlConnection per database.

  So why does adding a dataAdapter cause another splConnection to be created?

   

• yellowleonard

  SSC-Addicted

  Points: 402

  More actions

  February 14, 2006 at 6:21 am

  #620638

  I assume you're talking about .Net. I have no idea why it forces you to create a new connection for each new data adapter created in the visual designer. But I do know that it's very annoying, especially when you're using a dynamic connection and then .Net keeps trying to create static ones.

  I've no boubt there's some obscure checkbox somewhere that tells the designer not to behave this way but I've never come across it.

  My solutions:

  1) Do it the old fashioned way without using the visual designer

  2) Put up with it and just keep deleting the new connection and reconnecting your DAs to the original connection object

  All the best