System properties that can be set in the registry to change certain Design Manager behavior and to manually change SQL Server connection and database options
The following are options that can be set in registry to change certain functions and system behavior in Design Manager Pro 7.0. These setting can only be changed for the current user, if the setting needs to be changed for all users then the setting needs to be change on each user’s computer or a group policy can be created.
To change the properties, create a new key (folder) in the registry under (if it does not already exist):
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Design Manager Pro 7.0
The key (folder) should be called SystemProperties
Under HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Design Manager Pro 7.0\SystemProperties, the following STRING values are valid (if they do not exists then the default value is used). To change the option, create the key and set the appropriate value, type is always STRING.
The following entries that start with the letters “DB” are only used when DM is running using SQL Server:
DBProvider – This the OLEDB Provider Name, the default is “SQLNCLI10.1”*
DBDriver – This the Driver Name used to open a “DSN – less” connection and is only used when DM is running using SQL server.
The default is “SQL Server Native Client 10.0”
DBServer – This is the name of the SQL Server that is hosting the Design Manager Database. The format is: <servername>\<sqlserverinstancename>
DBName – Name of the database on the server; the default is “DMP70”
DBOptions – Additional options used to construct the OLDB connection string.
The default is “Integrated Security=SSPI;DataTypeCompatibility=80;MARS Connection=True;”
DBReportPicturePath – This is the location or url of the folder that contains the report (.rpt) files and that contains the pictdata folder.
The default is the application path or the same folder that the dmpro70.exe resides.
The application path is also used if this is blank.
- *Note: The SQL Server 2012 Native Client cannot be loaded on to Windows XP. If a mix of Windows XP and newer workstations are to access an SQL 2012 server, the SQL 2008 Native Client must be used on all workstations. If no XP machines are present, the OLE DB Provider can be set to SQLNCLI11 to use the 2012 Native Client.
The following entries control other DM behavior:
- RolodexMapLink – This the Internet link header to the Map Provider for the map button on Rolodex Window (and search within address fields). The default is http://maps.google.com/maps?q=
- POSSkipCCReceipt – Normally after a credit card is approved in the point of sale window through Merchant Warehouse a merchant receipt for signature prints directly to POS printer, the user then clicks OK and the sales receipt for the customer is printed. Setting this property to “True” will prevent the merchant signature receipt from printing.
- POSHasAutoCut – Normally after the merchant receipt for signature prints, the system displays a message box to allow the user to tear the receipt before the client’s copy is printed. Setting this to “True” will prevent the message from being display if the printer has a cut sheet feeder that cuts the sheets between documents automatically.
- ProjSpecShowDefault – Defaults the Show drop down list when the Projects and Specifications Window is opened. The default is “0” or Active, “1” = Inactive, “2” = Completed, “3” = All.
- MaxPictureLoadSize – Defaults to “2097152” Bytes (or 2MB) as a string in hosting mode and unlimited (zero, “0”) in normal desktop mode.