系统DSN不适用于所有用户的RDS [英] System DSN is not working in RDS for all users

问题描述

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.

推荐答案

修复错误20599无法打开SQL Server [ ^ ]

http://www.dreamincode.net/forums/topic/48730-a-problem-with-crystal-reports-85-using-vb6/ [ ^ ]

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