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

  • From: "Rick Mack" <Rick.Mack@xxxxxxxxxxxxxx>
  • To: <thin@xxxxxxxxxxxxx>
  • Date: Fri, 14 Oct 2005 09:42:21 +1000

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.
#####################################################################################

Other related posts: