[THIN] Re: Adding System DSN ODBC for regular user
- From: "Rick Mack" <Rick.Mack@xxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Fri, 14 Oct 2005 11:23:10 +1000
Hi Chris,
SQL is easy, just dump the relevant Software\ODBC\ODBC.INI reg key, take
my example and cut and paste ;-)
regards,
Rick
Ulrich Mack
Volante Systems
Level 2, 30 Little Cribb Street
Coronation Drive Office Park
Milton Qld 4064
tel: +61 7 32431847
fax: +61 7 32431992
rmack@xxxxxxxxxxxxxx <mailto:rmack@xxxxxxxxxxxxxx>
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Walter, Chris
Sent: Friday, 14 October 2005 11:14 AM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: Adding System DSN ODBC for regular user
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.
________________________________
#####################################################################################
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:
