ODBC Users Blank Title 68569

Yahoo Archive
1
Vantage 8.03.409C

Just looking to get a feel of how other manage ODBC.

I have created an ODBC connection and have been testing with great success. I have not created additional users at this time. I am pulling data into Excel.

Now, I looking to expand a little and want to bring in another user. There is a possibility that we may role out a spreadsheet for others to use, which would require a connection for many (not necessarily concurrent).

How are you setting up user(s)?

Jeff
2
For those of you that use Microsoft Access or Excel or other ODBC connections to query vantage, how is your progress configured to use SQL connections? We use both Access and Excel to query vantage and we seem to be getting a lot of 'exceed connection limit' errors.

Any suggestions?

Thanks,
Jasper




[Non-text portions of this message have been removed]
3
The exceed connection limit errors are resulting from the connections exceeding the specifications from the ODBC configuration of your Database. You will need to increase the number of servers allocated. I don't remember what the default is either since I have reduced ours from the default. Ours is only set to 10 servers with 4 maximum clients per server but then we have a very limited number of reports using ODBC and absolutely no connections from Access and Excel. I would suspect you will need to increase the number of servers dramatically. I hope you are running progress 10.1b. Progress 10.0a/b did not handle ODBC connections very efficiently.


Charles Carden
IT Manager
Manitex, Inc.

----- Original Message -----
From: Jasper Recto
To: Vantage Groups (vantage@yahoogroups.com)
Sent: Friday, September 05, 2008 1:35 PM
Subject: [Vantage] ODBC Users


For those of you that use Microsoft Access or Excel or other ODBC connections to query vantage, how is your progress configured to use SQL connections? We use both Access and Excel to query vantage and we seem to be getting a lot of 'exceed connection limit' errors.

Any suggestions?

Thanks,
Jasper

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Charles,

What version of Vantage does Progress 10.1b support? We are on version 6.1.

Thanks,
Jasper

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charles Carden
Sent: Friday, September 05, 2008 4:34 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC Users


The exceed connection limit errors are resulting from the connections exceeding the specifications from the ODBC configuration of your Database. You will need to increase the number of servers allocated. I don't remember what the default is either since I have reduced ours from the default. Ours is only set to 10 servers with 4 maximum clients per server but then we have a very limited number of reports using ODBC and absolutely no connections from Access and Excel. I would suspect you will need to increase the number of servers dramatically. I hope you are running progress 10.1b. Progress 10.0a/b did not handle ODBC connections very efficiently.

Charles Carden
IT Manager
Manitex, Inc.

----- Original Message -----
From: Jasper Recto
To: Vantage Groups (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Sent: Friday, September 05, 2008 1:35 PM
Subject: [Vantage] ODBC Users

For those of you that use Microsoft Access or Excel or other ODBC connections to query vantage, how is your progress configured to use SQL connections? We use both Access and Excel to query vantage and we seem to be getting a lot of 'exceed connection limit' errors.

Any suggestions?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
5
Actually you should be on version 9 of progress if you are still on 6.1. Version 10.0 did not come into place until version 8.0xx and Version 10.1 until 8.03.40x. I have not used Version 9 of progress in a long time so I cannot tell you how efficient it is for ODBC connections. Also, the instructions I gave you may not be good. If I remember right there are quite a few differences between version 9 and 10 but as I said it has been a long time since I was on version 9.

Someone that is currently using version 9 will probably have to give you more specifics concerning the handling of ODBC connections and server allocation.

Sorry for the misinformation.


----- Original Message -----
From: Jasper Recto
To: 'vantage@yahoogroups.com'
Sent: Friday, September 05, 2008 4:12 PM
Subject: RE: [Vantage] ODBC Users


Charles,

What version of Vantage does Progress 10.1b support? We are on version 6.1.

Thanks,
Jasper

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charles Carden
Sent: Friday, September 05, 2008 4:34 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC Users

The exceed connection limit errors are resulting from the connections exceeding the specifications from the ODBC configuration of your Database. You will need to increase the number of servers allocated. I don't remember what the default is either since I have reduced ours from the default. Ours is only set to 10 servers with 4 maximum clients per server but then we have a very limited number of reports using ODBC and absolutely no connections from Access and Excel. I would suspect you will need to increase the number of servers dramatically. I hope you are running progress 10.1b. Progress 10.0a/b did not handle ODBC connections very efficiently.

Charles Carden
IT Manager
Manitex, Inc.

----- Original Message -----
From: Jasper Recto
To: Vantage Groups (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Sent: Friday, September 05, 2008 1:35 PM
Subject: [Vantage] ODBC Users

For those of you that use Microsoft Access or Excel or other ODBC connections to query vantage, how is your progress configured to use SQL connections? We use both Access and Excel to query vantage and we seem to be getting a lot of 'exceed connection limit' errors.

Any suggestions?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]