crystal reports and postgres.exe error

[donnyriyadi]

Hi,
i have written a program in c# to print a crystal reports document and in the crystal reports document i use a postgresql connection to get the records.
I have tested it to print about 10 pages, and everytime the program tries to print the document, it make a "postgres.exe" process and after the document is printed, the process remain there until i shutdown my program.
So at 10 Pages there are also 10 postgres.exe processes. I think it isn't ok, isn't it ?
And if i try to print more pages, the psqlodbc will crash.
Does anyone have any solutions ?
thanks

 

[ceco]

I do not C#, but is there something like function pg_disconnect
it there is, try to use it after you finish with the DB

 

[CliffLandin]

It is pg_close($whatever) $whatever being whatever you use as $whatever = pg_connect(host=...)

When in doubt, go flat out!

http://www.soprisinteractive.com