Solved

ODBC Connections using RemoteApp

Posted on 2013-05-23
5
1,541 Views
Last Modified: 2013-06-07
Hi

   I have a window server 2008 standard with terminal services roles installed, and i have added a remoteApp program from TS RemoteApp Manager, and then to add RemoteApp program -< create .rdp files to a shared folder, remote desktop user to click on the .rdp file to run the application from the terminal server,  below is the issue

i have added a remoteApp program, a front end application , at the back it has MS sql 2008 as back end database, with ODBC connected, at first remote user will be able to connect to the application by clicking .rdp files, but when it reachs to database, the ODBC error pop up, and then i added another remoteApp program "ODBC" on it, and again save it to a shared folder on terminal server, remote user click in the .rdp file for ODBC, and configure the ODBC inside, this time i can run the application with no problem with the ODBC, is it a must to manually create a .rdp files for ODBC in order to make the front end application work ?

and when remote user trying to gerenate report, there is no response, it looks like that it can not gerenate data from database, but there is no problem at all when i work physically on the server with the application,  just wonder do i need to add another .rdp as well for this issue ?  

also remote desktop user want to use the printer on their local computer, when they are using the application via terminal server, when they click on print button, the printer only show from the server, not the printer on user's computer, is there any chance user can print out from their local printer instead ? Hope anyone can help with my problem , Thx

Keith
0
Comment
Question by:piaakit
  • 3
  • 2
5 Comments
 
LVL 11

Assisted Solution

by:marek1712
marek1712 earned 500 total points
ID: 39191806
- redistribute ODBC connection through Group Policy Preferences. You'll be able to use your application without problems.
- if the client connects from the domain workstation - you can add local printer port pointing to his device. Another way - force them to use remote desktop printing or enable printer capturing in the RemoteApp properties.
0
 

Author Comment

by:piaakit
ID: 39194896
where do i need change from GPO ? now i need to adding another remoteApp ODBC from terminal server, and remote user click on ODBC .rdp file to setup ODBC, n it works, to aviod to do this, i can modify GPO to do that ?

how do i add local printer port pointing to user device ?
0
 
LVL 11

Accepted Solution

by:
marek1712 earned 500 total points
ID: 39194925
ODBC in GPP by PeteNetLive: LINK
RDP Easy Print: LINK

Adding sahred printer as a local port may be a hassle if you have more than a few, as you have to add a port for each one of them.
0
 

Author Comment

by:piaakit
ID: 39195215
how do i change login id if i,m using a remoteapp .rdp file in computer A, once i have login with peter when clicking in a remoteapp, and i can not switch other user to login to this computer


and i have this digital certificate, vaild unitl 2023, how do i publish to remote user ? the current one remote user install is valid until oct 2013,

cert

valid until oct 2013
cert2
0
 
LVL 11

Expert Comment

by:marek1712
ID: 39229671
There's, also in the GPMC, snap-in that will let you install the certificate for every account.
More information: HERE.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now