ODBC Server 2

Configuring this setting will create a ODBC connection profile for DBM Tools

ODBC DSN: This should be the name of the ODBC DSN to connect to.
DSNs can be configured / viewed in the Data Sources control panel applet.

Type: This should be the type of database, meaning software platform.
Choose from the list of supported software.
If your software is not listed here but is supported, you may be using an outdated version of the GP template; update your template by running the GP template install script again, which can be downloaded from DBMTools.com

Note: Please be aware that on 64 bit machines there are two DSN configurations, one for 32 bit applications and one for 64 bit applications. The architecture of the end user application (i.e. Excel, Access) determines which configuration will be used.

ODBC DSN

Registry Hive	HKEY_CURRENT_USER
Registry Path	Software\Policies\DBMTools\DBProfiles
Value Name	ODBCDsn2
Value Type	REG_SZ
Default Value

Database Type

0. American Contractor
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	American Contractor

1. ComputerEase
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	ComputerEase

2. DBM Tools
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	DBM Tools

3. Spectrum V13
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	Spectrum V13

4. Spectrum V14
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	Spectrum V14

5. Timberline Office
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	Timberline Office

6. Viewpoint
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	Viewpoint

7. Other
   

   Registry Hive	HKEY_CURRENT_USER
   Registry Path	Software\Policies\DBMTools\DBProfiles
   Value Name	ODBCPlatform2
   Value Type	REG_SZ
   Value	Other