SQL Server ODBC Add

SQLServerGISDatabase.reg

!!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"
---