• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1886
  • Last Modified:

ODBC Connections using RemoteApp

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
piaakit
Asked:
piaakit
  • 3
  • 2
2 Solutions
 
marek1712Commented:
- 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
 
piaakitAuthor Commented:
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
 
marek1712Commented:
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
 
piaakitAuthor Commented:
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
 
marek1712Commented:
There's, also in the GPMC, snap-in that will let you install the certificate for every account.
More information: HERE.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now