ODBC Connections

Yahoo Archive
1
We have created a bunch of special reports using Crystal that I have
placed in the Vantage menu so that my users can run them inside of
Vantage. But I am running into a issue where there are not enough
ODBC connections available and we are getting out of ODBC connection
messages (In Vantage it is just trying to connect with no success).

I have 25 user license for Vantage, which if I am not mistaken gives
me 25 ODBC connections also.

When I look at the Server and do a Net Sessions it show 4 or 5 users
connected but each has 5 Opens.

First, why is each user when they run a Crystal Report using 5 opens
and Second, how can I clear these connections or set a parameter to
clear these.

I am a little lost with this right now and can't seem to find why
this is occuring.

Scott Litzau
2
I am currently running Vantage 6.10.513 08/16/04 and Progress 9.1D
Full. I have created many reports using Crystal 8.5 for all users
using vantage, but when they run a crystal generated report an ODBC
connection is made but when they close the report it does not close
the connection. If a user runs 50 reports a day they open 50 ODBC
connections and until the user logs off of Vantage the ODBC
connections will not close. This can cause problems if users never
logs off because i then run out of ODBC connections. Has anybody ever
experienced this problem and may have a solution.
3
Yes, we have experienced the problem :) It is another bug :) from progress
this time. You use promon to close the connections :(:(:( Very, Very
Annoying POOR,POOR PROGRAMMING

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: keizer_jeff [mailto:keizer_jeff@...]
Sent: Thursday, June 16, 2005 2:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Connections


I am currently running Vantage 6.10.513 08/16/04 and Progress 9.1D
Full. I have created many reports using Crystal 8.5 for all users
using vantage, but when they run a crystal generated report an ODBC
connection is made but when they close the report it does not close
the connection. If a user runs 50 reports a day they open 50 ODBC
connections and until the user logs off of Vantage the ODBC
connections will not close. This can cause problems if users never
logs off because i then run out of ODBC connections. Has anybody ever
experienced this problem and may have a solution.




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links