Last active
August 29, 2015 13:57
-
-
Save alexgleith/9358893 to your computer and use it in GitHub Desktop.
SQL Server ODBC Add
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
!!Note, only use the bits in between these '---' in a .reg file. Need to be run from local machine as Admin. | |
Note2: For MapInfo, install the SQL Server Native Client driver, it allows MI to handle dates. You'll need to install it anyway to use these scripts. http://msdn.microsoft.com/en-us/sqlserver/aa937733.aspx | |
Default (works for 32 bit software on 32 bit machine, and 64 bit software on 64 bit machine). | |
--- | |
Windows Registry Editor Version 5.00 | |
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources] | |
"GIS Database"="SQL Server Native Client 10.0" | |
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\GIS Database] | |
"Driver"="C:\\Windows\\system32\\sqlncli10.dll" | |
"Description"="The GIS Database" | |
"Server"="eckert-v\\isdb" | |
"Database"="GISDB" | |
"LastUser"="none" | |
"Trusted_Connection"="Yes" | |
--- | |
32 bit (for on a 64 bit machine, weird, ask Microsoft why they made it so!). | |
--- | |
Windows Registry Editor Version 5.00 | |
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources] | |
"GIS Database"="SQL Server Native Client 10.0" | |
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\GIS Database] | |
"Driver"="C:\\Windows\\SysWOW64\\sqlncli10.dll" | |
"Description"="The GIS Database" | |
"Server"="eckert-v\\isdb" | |
"ServerSPN"="" | |
"FailoverPartnerSPN"="" | |
"Database"="GISDB" | |
"LastUser"="none" | |
"Trusted_Connection"="Yes" | |
--- |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment