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 fucking hate ADO.net


On Apr 20, 4:14 am, "ray" <[e-mail]:

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

[RobinS]

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

Robin S.
---------------------------
"ray" <so*****@microsoft.comwrote in message
news:Ox**************@TK2MSFTNGP02.phx.gbl...

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

[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.
-----------------------------------
"ray" <so*****@microsoft.comwrote in message
news:Ox**************@TK2MSFTNGP02.phx.gbl...

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