系统DSN不适用于所有用户的RDS

系统DSN不适用于所有用户的RDS

本文介绍了系统DSN不适用于所有用户的RDS的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

I am running a VB 6 application for a report. It prints well in local with System DSN. But when i put the .exe of the application in RDS , report is not printing for System DSN rather its printing for User DSN. For System DSN its showing- "Cannot open SQL server".

My Efforts-
1-   http://social.technet.microsoft.com/Forums/windowsserver/en-US/bb2ced17-9dd3-40e4-b5b6-dd773ee7001c/system-dsn-on-rds-server 

I tried with creating a 32 bit DSN using [WindowsDir]\SysWOW64\odbcad32.exe, but wont work out for me.

2.  http://www.tek-tips.com/viewthread.cfm?qid=341776
 I tried to change the permission of the System DSN as logged in as Administer and to give full permission for the user using regedt32. But still the same error as "Cannot open SQL server". But as soon i create User DSN, it works fine. Please help.

推荐答案


这篇关于系统DSN不适用于所有用户的RDS的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-10 06:23