I have an application that communicates with a Sybase database using the Sybase 12.5 OLEDB driver on Windows Server 2003 R2 SP2. I have a normal Windows account (TestUser) belonging only to the Users permissions group. I gave TestUser Full Control permissions to the Sybase125 folder (where the .ids files, the sydaase.dll file, and the rest of the installed Sybase files reside), Read permission on HKLM\Software\ODBC\ODBC.INI in the registry, and Read & Execute permissions on C:\Program Files\Common Files\System (where I think the MDAC binaries reside). When running the application, I get a "COMException (0x80004005): Cannot load data source: [data source name]". If I put TestUser in the Administrators group, the application can access the Sybase database and return data.
It seems to me that in my situation, access to the Sybase database is solely a permissions issue. What are the minimum security permissions required to adequately use the Sybase OLE driver?
UPDATE: I gave read and write permissions to the root of the drive (D:) where the driver files reside, and it works. Using ProcMon, I could see that the driver wanted to attempt to write something to D:, which I don't understand at all. This doesn't answer my question of what permissions are required, but it gets me by.
