Folder Permissions 1

[joevig]

I'm setting up an VB6 app that uses crystal 8.5. It's installed on Windows 2003 server. When I run the app all is well. When another user runs the app they get 'Can't open sql server'. I had admin rights, the other users don't. If I give them admin, it works as it should. It's a permissions thing, but I don't know what folders should have what permissions. Any help would be appreciated.

 

[vidru]

When you say 'admin permissions', do you mean the Windows login, or the Server/DB login?

What code are you using to call the reports, and what type of db/connectivity/security are you dealing with?

-dave

 

[joevig]

They are the windows login permissions. I'm using VB6 calling a crystal report via crystal.ocx using ADO for db access to a sql server 2000 backend. It all runs fine if you have admin privleges. If you don't, it doesn't work. There must be a folder somewhere that requires admin privledges, but I don't know where! Could it be a Sql Server 2000 issue?

 

[vidru]

It could be a SQL Server issue if you're using Windows Authentication. Are you sending and ADO recordset to the report at runtime? If so, what driver is the report using (it should be pdsmon.dll or p2smon.dll, which is the Active Data driver).

If you're using ODBC, have a look here:

http://support.businessobjects.com/library/kbase/articles/c2007612.asp

Also, be aware that Server 2003 is not a supported/tested platform for CR 8.5.

-dave

 

[joevig]

Thanks for the tip. The problem was the odbc driver. Followed the link, installed fix and it worked...
Thanks again!