Question about Connection to SQL

[ray]

Dear all,
My application is using vb.net and crystal report. While the application
is running, it calls the crystal report. However, after the report is
closed, the connection to the SQL server is still there. It leads to the
problem that a new connection will be created and remained after calling a
new report. All the connections will only be closed after the application is
closed. Please help. How can I close the connection after previewing each
report?
Thanks a lot,
Ray

 

[Larry Linson]

you need to give more details

you shouldn't have to explicity close anything.. unless you're using a
global variable for example


in my opinion.. MS handicapped ADO.net by not allowing us to keep a
connection open in the first place.
MS wanted to help us out and close a connetion automagically for us

I call bullshit and it's one of the reasons I ****ing hate ADO.net

 

[RobinS]

Just FYI, be careful about listening to anything that LarryLinson guy says;
he's a known troll in these newsgroups.

Robin S.

 

[RobinS]

I don't use Crystal, but can you pass the connection in to the report, then
close it when it's done, or is all of it created by Crystal Reports?

Robin S.