ODBC on Terminal Server

Yahoo Archive
1
Paul, I have done this before. I will have to check some notes but I think
you need to check your security in regedt32. Check Microsoft and search on
terminal server and odbc.



Judd
Custom Hoists, Inc.
Ph: (419) 368-4721 EXT. 246

-----Original Message-----
From: Paul Oliver [mailto:p.oliver@...]
Sent: Thursday, December 18, 2003 10:55 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC on Terminal Server


The Merant ODBC driver isn't listed under the administrator or user accounts
in the Drivers tab of the windows ODBC Data Source Administrator so I cannot
create system or user DSNs.

I'm going to try uninstalling and reinstalling Progress to see if that makes
a difference.

Paul.



----- Original Message -----
From: "Adam Ellis" <aellis@...>
To: "Vantage Group" <vantage@yahoogroups.com>
Sent: Thursday, December 18, 2003 3:37 PM
Subject: Re: [Vantage] ODBC on Terminal Server


> Paul,
>
> Try logging in as one of your terminal server users, going into the ODBC
> control panel, and see if you can add the data source manually. We have
> a small terminal server install, so for each user I set up I log in and
> have to manually configure their ODBC. Having it correct on the Admin
> profile is not enough.
>
> HTH,
> AE

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
I have set up a new Windows 2000 terminal server to support our growing user
base. As per the Epicor guidelines I've installed Progress with the latest
patch on the terminal server and run the Vantage client install selecting
the terminal server option. We're on Vantage 5.20 at the moment and will be
upgrading to 6.10 next year.

The problem I've found is that the Merant ODBC driver isn't installed on the
terminal server so much of our reporting is unavailable to the users logged
into that server. Our existing terminal server has the ODBC driver running
correctly although that machine was originally set up under Vantage 5.10 so
I suspect there is a difference in the client installation.

Epicor support here in the UK have suggested that I install a full copy of
Vantage on the terminal server rather than the usual client install but
before I go ahead and try that does anyone have any other suggestions or
tips for getting ODBC running?

Paul Oliver
Concentric Controls Ltd.

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498
3
I installed the full version of Progress 9.1D from the 5.2 CD on my T.S. and the ODBC Drivers installed fine.

Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Paul Oliver [mailto:p.oliver@...]
Sent: Thursday, December 18, 2003 9:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC on Terminal Server


I have set up a new Windows 2000 terminal server to support our growing user
base. As per the Epicor guidelines I've installed Progress with the latest
patch on the terminal server and run the Vantage client install selecting
the terminal server option. We're on Vantage 5.20 at the moment and will be
upgrading to 6.10 next year.

The problem I've found is that the Merant ODBC driver isn't installed on the
terminal server so much of our reporting is unavailable to the users logged
into that server. Our existing terminal server has the ODBC driver running
correctly although that machine was originally set up under Vantage 5.10 so
I suspect there is a difference in the client installation.

Epicor support here in the UK have suggested that I install a full copy of
Vantage on the terminal server rather than the usual client install but
before I go ahead and try that does anyone have any other suggestions or
tips for getting ODBC running?

Paul Oliver
Concentric Controls Ltd.

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498



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

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

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

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
4
> The problem I've found is that the Merant ODBC driver isn't installed
> on the
> terminal server so much of our reporting is unavailable to the users
> logged
> into that server. Our existing terminal server has the ODBC driver
> running
> correctly although that machine was originally set up under Vantage
> 5.10 so
> I suspect there is a difference in the client installation.

Paul,

Try logging in as one of your terminal server users, going into the ODBC
control panel, and see if you can add the data source manually. We have
a small terminal server install, so for each user I set up I log in and
have to manually configure their ODBC. Having it correct on the Admin
profile is not enough.

HTH,
AE
5
The Merant ODBC driver isn't listed under the administrator or user accounts
in the Drivers tab of the windows ODBC Data Source Administrator so I cannot
create system or user DSNs.

I'm going to try uninstalling and reinstalling Progress to see if that makes
a difference.

Paul.



----- Original Message -----
From: "Adam Ellis" <aellis@...>
To: "Vantage Group" <vantage@yahoogroups.com>
Sent: Thursday, December 18, 2003 3:37 PM
Subject: Re: [Vantage] ODBC on Terminal Server


> Paul,
>
> Try logging in as one of your terminal server users, going into the ODBC
> control panel, and see if you can add the data source manually. We have
> a small terminal server install, so for each user I set up I log in and
> have to manually configure their ODBC. Having it correct on the Admin
> profile is not enough.
>
> HTH,
> AE

This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498