How do you create a System DSN in the control panel on ones PC using Powershell or .NET?
Asked
Active
Viewed 4,711 times
6
-
... using the database connection object's constructor? – Ry- Sep 24 '11 at 00:52
-
I would use connection strings passed into the connection object. Look at the things like SqlConnectionStringBuilder ... – bryanmac Sep 24 '11 at 01:04
-
What I meant was: How do you create a System DSN in the control panel on one's PC? – Chad Sep 24 '11 at 01:13
1 Answers
7
This can be done with some registry edit. Refer this link:
http://derek858.blogspot.com/2010/02/create-32-bit-system-dsn-with.html
Note that for 64-bit you will be using HKEY_LOCAL_MACHINE\Software\Odbc\Odbc.ini\

manojlds
- 290,304
- 63
- 469
- 417