?
Solved

ODBC Connections using RemoteApp

Posted on 2013-05-23
5
Medium Priority
?
1,699 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 11

Assisted Solution

by:marek1712
marek1712 earned 2000 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 2000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
OfficeMate Freezes on login or does not load after login credentials are input.
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 give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
Suggested Courses
Course of the Month13 days, 6 hours left to enroll

801 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