[THIN] Re: Adding System DSN ODBC for regular user

From: "Walter, Chris" <christopher.walter@xxxxxxx>
To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
Date: Thu, 13 Oct 2005 21:14:24 -0400
Just out of curiosity you would have an example using SQL would you?

 

-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of Rick Mack
Sent: Thursday, October 13, 2005 7:42 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Adding System DSN ODBC for regular user

 

Hi,

 

It isn't that hard to do it with a group policy, eg. for a Movex DSN

 

    POLICY "Enable Movex User DSN ODBC Settings"
    KEYNAME "Software\ODBC\ODBC.INI"
            ACTIONLISTON                    
                KEYNAME "Software\ODBC\ODBC.INI\Movex Servers v12"

                    VALUENAME "Driver" VALUE
"C:\WINNT\system32\ODBCJT32.DLL"
                    VALUENAME "DBQ" VALUE "C:\Program Files\Intentia\Movex
Explorer v12\Servers\MvxServers.mdb"
                    VALUENAME "Description" VALUE "Movex Server
Configuration Database Connection"
                    VALUENAME "FIL" VALUE "MS Access;"
                    VALUENAME "UID" VALUE ""
                    VALUENAME "DriverId" VALUE NUMERIC 25 
                    VALUENAME "SafeTransactions" VALUE NUMERIC 0
                KEYNAME "Software\ODBC\ODBC.INI\Movex Servers
v12\Engines\Jet"
                    VALUENAME "ImplicitCommitSync" VALUE ""
                    VALUENAME "MaxBufferSize" VALUE NUMERIC 2048
                    VALUENAME "PageTimeout" VALUE NUMERIC 5
                    VALUENAME "Threads" VALUE NUMERIC 3
                    VALUENAME "UserCommitSync" VALUE "Yes"
                KEYNAME "Software\ODBC\ODBC.INI\ODBC Data Sources"
                    VALUENAME "Movex Servers v12" VALUE "Microsoft Access
Driver (*.mdb)"
                KEYNAME "Software\ODBC\ODBC.INI\MvxDocLink v12"

                    VALUENAME "Driver" VALUE
"C:\WINNT\system32\ODBCJT32.DLL"
                    VALUENAME "DBQ" VALUE "C:\Program Files\Intentia\Movex
Explorer v12\DocumentLinks\MvxDocLink.mdb"
                    VALUENAME "Description" VALUE "Movex OLE Document
Database Connection"
                    VALUENAME "FIL" VALUE "MS Access;"
                    VALUENAME "UID" VALUE ""
                    VALUENAME "DriverId" VALUE NUMERIC 25 
                    VALUENAME "SafeTransactions" VALUE NUMERIC 0
                KEYNAME "Software\ODBC\ODBC.INI\MvxDocLink v12\Engines\Jet"
                    VALUENAME "ImplicitCommitSync" VALUE ""
                    VALUENAME "MaxBufferSize" VALUE NUMERIC 2048
                    VALUENAME "PageTimeout" VALUE NUMERIC 5
                    VALUENAME "Threads" VALUE NUMERIC 3
                    VALUENAME "UserCommitSync" VALUE "Yes"
                KEYNAME "Software\ODBC\ODBC.INI\ODBC Data Sources"
                    VALUENAME "MvxDocLink v12" VALUE "Microsoft Access
Driver (*.mdb)"
                KEYNAME "Software\ODBC\ODBC.INI\MvxIcons v12"

                    VALUENAME "Driver" VALUE
"C:\WINNT\system32\ODBCJT32.DLL"
                    VALUENAME "DBQ" VALUE "C:\Program Files\Intentia\Movex
Explorer v12\IconLinks\MvxIconLink.mdb"
                    VALUENAME "Description" VALUE "Movex Icon Database
Connection"
                    VALUENAME "FIL" VALUE "MS Access;"
                    VALUENAME "UID" VALUE ""
                    VALUENAME "DriverId" VALUE NUMERIC 25 
                    VALUENAME "SafeTransactions" VALUE NUMERIC 0
                KEYNAME "Software\ODBC\ODBC.INI\MvxIcons v12\Engines\Jet"
                    VALUENAME "ImplicitCommitSync" VALUE ""
                    VALUENAME "MaxBufferSize" VALUE NUMERIC 2048
                    VALUENAME "PageTimeout" VALUE NUMERIC 5
                    VALUENAME "Threads" VALUE NUMERIC 3
                    VALUENAME "UserCommitSync" VALUE "Yes"
                KEYNAME "Software\ODBC\ODBC.INI\ODBC Data Sources"
                    VALUENAME "MvxIcons v12" VALUE "Microsoft Access Driver
(*.mdb)"
            END ACTIONLISTON

 

            ACTIONLISTOFF
                ; dummy entry
            ENDACTIONLISTOFF
            
    END POLICY ; movex DSN

 

 

regards,

Rick

Ulrich Mack
Volante Systems


 

 

-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of Walter, Chris
Sent: Friday, 14 October 2005 8:08 AM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: Adding System DSN ODBC for regular user

User should have access to write to HKCU.  Try running Regmon.  I'd love to
see your script if it works, I've been trying to find out a way to put in an
ODBC entry with the packager after an application install but I couldn't
find anything that would work.

 

Thanks,

 

Chris

 

-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of Evan Mann
Sent: Thursday, October 13, 2005 6:00 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Adding System DSN ODBC for regular user

 

Anyone know how you can add a System DSN ODBC under a users profile who has
regular user access.  I have the info in a registry file and am running it
in a login script, but if you do not have Power User or above access, it
will not create, even though it's in the HKCU key.

  _____  

This e-mail, including all attachments, may be confidential or privileged.
Confidentiality or privilege is not waived or lost because this e-mail has
been sent to you in error.  If you are not the intended recipient any use,
disclosure or copying of this e-mail is prohibited.  If you have received it
in error please notify the sender immediately by reply e-mail and destroy
all copies of this e-mail and any attachments.  All liability for direct and
indirect loss arising from this e-mail and any attachments is hereby
disclaimed to the extent permitted by law.

  _____
[THIN] Re: Adding System DSN ODBC for regular user

Other related posts:
