I've got a list of about 50 user MS SQL server DSNs to add for an app I'm packaging and the settings in odbcad32.exe need to be set so that the option to "Connect to SQL server to obtain default settings for the additional configuration options" is unticked.
So i did it for one, exported the reg key and then wrote a script to amend the reg file with a new DSN with respective name/decription/server etc and it all worked fine.
Then when I import the reg file I notice that the "Connect to SQL server to obtain default settings for the additional configuration options" is ticked.
I tested it again manually and I can't get that option to stay unticked not even for a single DSN using the wizard.
I ran it as an admin and still no joy (it's a user DSN anyway...) - any ideas what I need to do to make that option stay unticked?
This is on a VMware image, logged in as admin using the odbcad32.exe from C:\Windows\SysWOW64 on Win 7 Enterprise edition.
So i did it for one, exported the reg key and then wrote a script to amend the reg file with a new DSN with respective name/decription/server etc and it all worked fine.
Then when I import the reg file I notice that the "Connect to SQL server to obtain default settings for the additional configuration options" is ticked.
I tested it again manually and I can't get that option to stay unticked not even for a single DSN using the wizard.
I ran it as an admin and still no joy (it's a user DSN anyway...) - any ideas what I need to do to make that option stay unticked?
This is on a VMware image, logged in as admin using the odbcad32.exe from C:\Windows\SysWOW64 on Win 7 Enterprise edition.
Comment