Only Domain Admins able to access System DSN on Win2K Citrix server

[yert33]

Visual FoxPro program connects to a Notes database via a system DSN defined in ODBC manager. Works fine if the Win2K user is a Domain Admin, but not if they are a Domain User.

(For foxdev; This is my SQL statement:
STORE SQLCONNECT('ARCOLLECT') TO gnConnHandle
I have tried using the SQLSTRINGCONNECT function but can't make it connect no matter who the user is...)

How can I give access to the ODBC DSN to Domain Users?

Thanks in advance!

 

[yert33]

Here's the solution I found:

The problem is with registry key permissions. I used regedt32.exe to give the group Domain Users access to the HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\(system dsn name here) key. I selected all Allow for all permissions and applied to 'This key only'.

whew... this took me 7 hours to crack....

 

[realstandman]

yert33,

I have this problem too. I can't find where you selected all allow. Can you direct me?

Standman1

 

[yert33]

The server is a Win2K server.
Start: Run: regedt32

Navigaste to the key and have it highlighted in the LH pane. Then up at the top of the regedt32 window there is a security menu tab. Under it is "Permissions..."

That is where you change it.