ODBC Connection to vantage 6.1

Yahoo Archive
1
If you have a promon shortcut which I would advise.

You just execute promon the select 8 then the user number then 1.

The prompts really guide you.

Just be careful because these could be live connections it should say
odbcuser I think.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sharma_nalini
Sent: Thursday, January 12, 2006 2:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Connection to vantage 6.1


It will really be helpful if you can advise me how to close ODbc
connections from promonitor.

Just one more question:

When i try to connect to Vantage via ODBC in crystal report, I get an
error message " The Operation system denied access to a specifies
file" only on my system. I don't know what is happening.




--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
> I do not think the odbc driver closes the connections :( We
restart our
> server every night for this reason in addition sometimes we have to
use
> promon to go in and close odbc sessions. Connections are $ free
they only
> cost some memory and cpu my -n parameter is very big. We use odbc
> everywhere on custom forms, reports, applications and on the
intranet.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@l...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> sharma_nalini
> Sent: Thursday, January 12, 2006 12:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: ODBC Connection to vantage 6.1
>
>
> We have setup for 40 connections and we are using less than 10
> licenses
>
>
>
> --- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@m...>
wrote:
> >
> > I believe you have exceeded your user licenses.....
> >
> > Julie
> > Mercury Minnesota Inc.
> >
> > ----- Original Message -----
> > From: sharma_nalini
> > To: vantage@yahoogroups.com
> > Sent: Thursday, January 12, 2006 11:23 AM
> > Subject: [Vantage] ODBC Connection to vantage 6.1
> >
> >
> > HI,
> >
> > I am having problems connecting to vantage db via odbc, It was
> working
> > fine few days ago but now gives me an error for exceeding
> perimissible
> > coonection. we checked all the settings, ran the odbcfix61.r
> again but
> > but no results.
> >
> > Does anyone have any idea?
> >
> > Also is there a way to schedule the export of business queries
in
> > vantage?
> >
> >
> >
> >
> >
> > 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
> >
> >
> >
> > SPONSORED LINKS Manufacturing software Membership database
> software Database mortgage software
> > Pda database software Database management software
> Database marketing software
> >
> >
> > ------------------------------------------------------------------
--
> ----------
> > YAHOO! GROUPS LINKS
> >
> > a.. Visit your group "vantage" on the web.
> >
> > b.. To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
> of Service.
> >
> >
> > ------------------------------------------------------------------
--
> ----------
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> 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
>






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
2
HI,

I am having problems connecting to vantage db via odbc, It was working
fine few days ago but now gives me an error for exceeding perimissible
coonection. we checked all the settings, ran the odbcfix61.r again but
but no results.

Does anyone have any idea?

Also is there a way to schedule the export of business queries in
vantage?
3
I believe you have exceeded your user licenses.....

Julie
Mercury Minnesota Inc.

----- Original Message -----
From: sharma_nalini
To: vantage@yahoogroups.com
Sent: Thursday, January 12, 2006 11:23 AM
Subject: [Vantage] ODBC Connection to vantage 6.1


HI,

I am having problems connecting to vantage db via odbc, It was working
fine few days ago but now gives me an error for exceeding perimissible
coonection. we checked all the settings, ran the odbcfix61.r again but
but no results.

Does anyone have any idea?

Also is there a way to schedule the export of business queries in
vantage?





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



SPONSORED LINKS Manufacturing software Membership database software Database mortgage software
Pda database software Database management software Database marketing software


------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "vantage" on the web.

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------



[Non-text portions of this message have been removed]
4
We have setup for 40 connections and we are using less than 10
licenses



--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@m...> wrote:
>
> I believe you have exceeded your user licenses.....
>
> Julie
> Mercury Minnesota Inc.
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@yahoogroups.com
> Sent: Thursday, January 12, 2006 11:23 AM
> Subject: [Vantage] ODBC Connection to vantage 6.1
>
>
> HI,
>
> I am having problems connecting to vantage db via odbc, It was
working
> fine few days ago but now gives me an error for exceeding
perimissible
> coonection. we checked all the settings, ran the odbcfix61.r
again but
> but no results.
>
> Does anyone have any idea?
>
> Also is there a way to schedule the export of business queries in
> vantage?
>
>
>
>
>
> 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
>
>
>
> SPONSORED LINKS Manufacturing software Membership database
software Database mortgage software
> Pda database software Database management software
Database marketing software
>
>
> --------------------------------------------------------------------
----------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "vantage" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> --------------------------------------------------------------------
----------
>
>
>
> [Non-text portions of this message have been removed]
>
5
I had that problem awhile back, and I think I had to change my progress license(s) setup.
Anyone else know for sure?

Julie

----- Original Message -----
From: sharma_nalini
To: vantage@yahoogroups.com
Sent: Thursday, January 12, 2006 11:50 AM
Subject: [Vantage] Re: ODBC Connection to vantage 6.1


We have setup for 40 connections and we are using less than 10
licenses



--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@m...> wrote:
>
> I believe you have exceeded your user licenses.....
>
> Julie
> Mercury Minnesota Inc.
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@yahoogroups.com
> Sent: Thursday, January 12, 2006 11:23 AM
> Subject: [Vantage] ODBC Connection to vantage 6.1
>
>
> HI,
>
> I am having problems connecting to vantage db via odbc, It was
working
> fine few days ago but now gives me an error for exceeding
perimissible
> coonection. we checked all the settings, ran the odbcfix61.r
again but
> but no results.
>
> Does anyone have any idea?
>
> Also is there a way to schedule the export of business queries in
> vantage?
>
>
>
>
>
> 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
>
>
>
> SPONSORED LINKS Manufacturing software Membership database
software Database mortgage software
> Pda database software Database management software
Database marketing software
>
>
> --------------------------------------------------------------------
----------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "vantage" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> --------------------------------------------------------------------
----------
>
>
>
> [Non-text portions of this message have been removed]
>







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

a.. Visit your group "vantage" on the web.

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------



[Non-text portions of this message have been removed]
6
I do not think the odbc driver closes the connections :( We restart our
server every night for this reason in addition sometimes we have to use
promon to go in and close odbc sessions. Connections are $ free they only
cost some memory and cpu my -n parameter is very big. We use odbc
everywhere on custom forms, reports, applications and on the intranet.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sharma_nalini
Sent: Thursday, January 12, 2006 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Connection to vantage 6.1


We have setup for 40 connections and we are using less than 10
licenses



--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@m...> wrote:
>
> I believe you have exceeded your user licenses.....
>
> Julie
> Mercury Minnesota Inc.
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@yahoogroups.com
> Sent: Thursday, January 12, 2006 11:23 AM
> Subject: [Vantage] ODBC Connection to vantage 6.1
>
>
> HI,
>
> I am having problems connecting to vantage db via odbc, It was
working
> fine few days ago but now gives me an error for exceeding
perimissible
> coonection. we checked all the settings, ran the odbcfix61.r
again but
> but no results.
>
> Does anyone have any idea?
>
> Also is there a way to schedule the export of business queries in
> vantage?
>
>
>
>
>
> 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
>
>
>
> SPONSORED LINKS Manufacturing software Membership database
software Database mortgage software
> Pda database software Database management software
Database marketing software
>
>
> --------------------------------------------------------------------
----------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "vantage" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> --------------------------------------------------------------------
----------
>
>
>
> [Non-text portions of this message have been removed]
>







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
7
It will really be helpful if you can advise me how to close ODbc
connections from promonitor.

Just one more question:

When i try to connect to Vantage via ODBC in crystal report, I get an
error message " The Operation system denied access to a specifies
file" only on my system. I don't know what is happening.




--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
> I do not think the odbc driver closes the connections :( We
restart our
> server every night for this reason in addition sometimes we have to
use
> promon to go in and close odbc sessions. Connections are $ free
they only
> cost some memory and cpu my -n parameter is very big. We use odbc
> everywhere on custom forms, reports, applications and on the
intranet.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@l...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> sharma_nalini
> Sent: Thursday, January 12, 2006 12:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: ODBC Connection to vantage 6.1
>
>
> We have setup for 40 connections and we are using less than 10
> licenses
>
>
>
> --- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@m...>
wrote:
> >
> > I believe you have exceeded your user licenses.....
> >
> > Julie
> > Mercury Minnesota Inc.
> >
> > ----- Original Message -----
> > From: sharma_nalini
> > To: vantage@yahoogroups.com
> > Sent: Thursday, January 12, 2006 11:23 AM
> > Subject: [Vantage] ODBC Connection to vantage 6.1
> >
> >
> > HI,
> >
> > I am having problems connecting to vantage db via odbc, It was
> working
> > fine few days ago but now gives me an error for exceeding
> perimissible
> > coonection. we checked all the settings, ran the odbcfix61.r
> again but
> > but no results.
> >
> > Does anyone have any idea?
> >
> > Also is there a way to schedule the export of business queries
in
> > vantage?
> >
> >
> >
> >
> >
> > 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
> >
> >
> >
> > SPONSORED LINKS Manufacturing software Membership database
> software Database mortgage software
> > Pda database software Database management software
> Database marketing software
> >
> >
> > ------------------------------------------------------------------
--
> ----------
> > YAHOO! GROUPS LINKS
> >
> > a.. Visit your group "vantage" on the web.
> >
> > b.. To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
> of Service.
> >
> >
> > ------------------------------------------------------------------
--
> ----------
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> 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
>
8
Frank,
The ODBC connections do close themselves unless there is a glitch just like
Vantage licenses.
You need to beware though, for instance if you have an ODBC connection in a
subreport of a crystal report that you can create many connections at once
that will all stay open until the report is closed. I was finding problems
when I used ODBC to deal with the Rep issue on SO Acknowledgements. Each
open SO form would create 5 ODBC connections. The all cleared when the
report was printed and closed, but admins had them open on their desktops
for hours. They would close themselves after the call was ended, but what
you may be facing is something like Access connection left open by someone
have a form or report still open. You might want to investigate the cause
further. I use ODBC extensively and only reboot the server every 3 to 6
months depending on OS updates.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Frank Zeigafuse
Sent: Thursday, January 12, 2006 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: ODBC Connection to vantage 6.1


I do not think the odbc driver closes the connections :( We restart our
server every night for this reason in addition sometimes we have to use
promon to go in and close odbc sessions. Connections are $ free they only
cost some memory and cpu my -n parameter is very big. We use odbc
everywhere on custom forms, reports, applications and on the intranet.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sharma_nalini
Sent: Thursday, January 12, 2006 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Connection to vantage 6.1


We have setup for 40 connections and we are using less than 10
licenses



--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@m...> wrote:
>
> I believe you have exceeded your user licenses.....
>
> Julie
> Mercury Minnesota Inc.
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@yahoogroups.com
> Sent: Thursday, January 12, 2006 11:23 AM
> Subject: [Vantage] ODBC Connection to vantage 6.1
>
>
> HI,
>
> I am having problems connecting to vantage db via odbc, It was
working
> fine few days ago but now gives me an error for exceeding
perimissible
> coonection. we checked all the settings, ran the odbcfix61.r
again but
> but no results.
>
> Does anyone have any idea?
>
> Also is there a way to schedule the export of business queries in
> vantage?
>
>
>
>
>
> 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
>
>
>
> SPONSORED LINKS Manufacturing software Membership database
software Database mortgage software
> Pda database software Database management software
Database marketing software
>
>
> --------------------------------------------------------------------
----------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "vantage" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> --------------------------------------------------------------------
----------
>
>
>
> [Non-text portions of this message have been removed]
>







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











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
9
On the Business Queries, yes. If you select the format of the Query to be
XML and then start up the Process Server on a computer. Within the process
server you will need to set a delay and then (very important to set delay
first) start the Business Activity Query Process. Without a delay it will
run the query back to back and consume tons of resources.
Unfortunately it seems that only the XML format queries are exported by the
schedule. This is designed to feed the ASP pages that it can auto generate
for you, but you could exploit it for your benefit if you can work with the
XML export format.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of sharma_nalini
Sent: Thursday, January 12, 2006 12:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Connection to vantage 6.1


HI,

I am having problems connecting to vantage db via odbc, It was working
fine few days ago but now gives me an error for exceeding perimissible
coonection. we checked all the settings, ran the odbcfix61.r again but
but no results.

Does anyone have any idea?

Also is there a way to schedule the export of business queries in
vantage?
10
Thanks Aaron. Do you have an odbc broker?

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Thursday, January 12, 2006 3:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: ODBC Connection to vantage 6.1


Frank,
The ODBC connections do close themselves unless there is a glitch just like
Vantage licenses. You need to beware though, for instance if you have an
ODBC connection in a subreport of a crystal report that you can create many
connections at once that will all stay open until the report is closed. I
was finding problems when I used ODBC to deal with the Rep issue on SO
Acknowledgements. Each open SO form would create 5 ODBC connections. The
all cleared when the report was printed and closed, but admins had them open
on their desktops for hours. They would close themselves after the call was
ended, but what you may be facing is something like Access connection left
open by someone have a form or report still open. You might want to
investigate the cause further. I use ODBC extensively and only reboot the
server every 3 to 6 months depending on OS updates. Good luck, Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Frank Zeigafuse
Sent: Thursday, January 12, 2006 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: ODBC Connection to vantage 6.1


I do not think the odbc driver closes the connections :( We restart our
server every night for this reason in addition sometimes we have to use
promon to go in and close odbc sessions. Connections are $ free they only
cost some memory and cpu my -n parameter is very big. We use odbc
everywhere on custom forms, reports, applications and on the intranet.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sharma_nalini
Sent: Thursday, January 12, 2006 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Connection to vantage 6.1


We have setup for 40 connections and we are using less than 10 licenses



--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@m...> wrote:
>
> I believe you have exceeded your user licenses.....
>
> Julie
> Mercury Minnesota Inc.
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@yahoogroups.com
> Sent: Thursday, January 12, 2006 11:23 AM
> Subject: [Vantage] ODBC Connection to vantage 6.1
>
>
> HI,
>
> I am having problems connecting to vantage db via odbc, It was
working
> fine few days ago but now gives me an error for exceeding
perimissible
> coonection. we checked all the settings, ran the odbcfix61.r
again but
> but no results.
>
> Does anyone have any idea?
>
> Also is there a way to schedule the export of business queries in
> vantage?
>
>
>
>
>
> 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
>
>
>
> SPONSORED LINKS Manufacturing software Membership database
software Database mortgage software
> Pda database software Database management software
Database marketing software
>
>
> --------------------------------------------------------------------
----------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "vantage" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> --------------------------------------------------------------------
----------
>
>
>
> [Non-text portions of this message have been removed]
>







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











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










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