Re: Question about Connection to SQL

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "RobinS" <RobinS@xxxxxxxxxxxxxxx>
Date: Fri, 20 Apr 2007 14:48:56 -0700

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" <someone@xxxxxxxxxxxxx> wrote in message
news:OxraA0zgHHA.4520@xxxxxxxxxxxxxxxxxxxxxxx

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

References:
- Question about Connection to SQL
  - From: ray

Prev by Date: Re: REGULAR EXPRESSION: two short instead of one long
Next by Date: Re: IE7 hangs with Click Once deployment VS2005 - any fixes?
Previous by thread: Re: Question about Connection to SQL
Next by thread: reading and updating database as the same time
Index(es):
- Date
- Thread

Relevant Pages

Re: Frustration and Excitement with Crystal Reports
... data in it to report on. ... 'you may have to fool with the right hand side to get the right connection - ... Right click on the Database Fields. ... Select "Set Datasource Location". ...
(microsoft.public.dotnet.languages.vb)
Re: Am I attacked ?
... found no logic) TCP ports, to various ports, and it wasn't blocked!?! ... What should I do about that belgium intrusion (report? ... "Zebedee" a écrit dans le message de ... > blocked those connection attempts:) ...
(comp.security.firewalls)
Re: Virgin Media team up with SamKnows to see who is best? Virgin media come out tops!!
... My observation last year of the 20Mb/s line last year was that congestion in peak times regularly slowed the per connection speed to between 1-2Mb/s. ... This was a good report, I believe it was after this report that interested parties, such as VM, started funding Samknows. ... However much of my internet usage involved single thread operations such as video streaming and this meant the the VM line significantly under performed a 4Mb/s DSL line. ... So given that and comparing it to those mealy mouthed "up to" speeds ...
(uk.telecom.broadband)
Jimmie quits knitting
... Shah, in connection with bottoms disappointed and elderly, gasps ... then report at last the question alongside the farm. ... Taysseer, have a overseas cinema. ... appreciate architectural desires to fortunately suffer. ...
(sci.crypt)
Re: Wifi indicator LED - update
... Then I lost the connection. ... something turns wifi off and it can't be turned back one. ... No, the router is 24/7, and gets a reboot maybe 6 times/year. ... If I find any evidence to even suggest a likely explanation I'll report ...
(Fedora)