Create an ODBC using a reg edit file
22-Mar-1616 Leave a comment
With thanks to:
https://kencenerelli.wordpress.com/2012/07/26/export-an-odbc-data-source-from-the-registry/
Save following as a file e.g. MyODBCName.reg
Double-click to install into the registry
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources]
"MyODBCName"="SQL Server Native Client 11.0"
[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\MyODBCName]
"Driver"="C:\\Windows\\SysWOW64\\sqlncli11.dll"
"Server"="MyServerName"
"Database"="MyDatabaseName"
"LastUser"="MyLastUserName"