SQL Server Fix for Showcase Client 9.1.0.7

Showcase Client 9.1.0.7 introduces support for a new SQL Server driver that can be used for Warehouse Builder definitions. This is also used for running IBM Collaboration & Deployment Services jobs containing Warehouse Builder job steps to an Enterprise Server.

Query and Report Writer data sources are not affected by this enhancement and no changes are required for DBQ and RPT files.

The new driver is supported for SQL Server 2012, 2008 and 2005 databases, but NOT SQL Server 2000. The old driver is still supported for SQL Server 2008, 2005 and 2000 databases. So, current users will
not need to make any changes unless you want to connect to SQL Server 2012.

By default, the old driver is defined in the data source examples. Therefore, you will need to edit the driver name and connection string if using the new driver:

1. On the Enterprise Server PC, locate the file:
   C:\PROGRAM FILES (X86)\SHOWCASE\9\PRODDATA\CONFIG\SHOWCASE.CFG
    
2. Open this file using a plain-text editor, such as Notepad.
    
3. Locate your data source, or create a new data source by copying the sample and modify the items that follow.
    
4. Locate this line:
   SHOWCASECORP.DRIVERCLASSNAME=SPSSOEM.JDBC.SQLSERVER.SQLSERVERDRIVER
    
5. Replace that line with this one:
   SHOWCASECORP.DRIVERCLASSNAME=COM.MICROSOFT.SQLSERVER.JDBC.SQLSERVERDRIVER
    
6. Locate this line:
   SHOWCASECORP.DRIVERURL=JDBC:SPSSOEM:SQLSERVER: (followed by database connection information described below)
    
7. Replace it with this line:
   SHOWCASECORP.DRIVERURL=JDBC:SQLSERVER: (followed by database connection information described below)
    
8. Save the changes and restart the Enterprise Server service (or DOS window, whichever is running)

Database Connection Information

The connection string syntax is as follows:

showcasecorp.driverURL=jdbc:sqlserver://sssss[:nnnn[;InstanceName=iiiii
[;DatabaseName=ddddd]]]

(where sssss = ServerName, nnnn = PortNumber, iiiii = InstanceName, and
ddddd = DatabaseName)

The properties used to define the connection to the server are:

ServerName

(Required) – Name of your SQL Server machine.

PortNumber

(Optional) - The port to connect to on ServerName. The default is 1433. If you are using the default, you do not have to specify the port, nor its preceding ‘:’, in the URL.

InstanceName

(Optional) - The instance to connect to on ServerName. If not specified, a connection to the default instance is made.

DatabaseName

(Optional) - The name of the database to connect to. If not stated, a connection is made to the default database.

Other connection properties are supported. Please consult with Microsoft web page, Setting Connection Properties.

Examples:
Simple connection to the server (the default port, instance, and database will be used):

showcasecorp.driverURL=jdbc:sqlserver://ServerName

To use a port number:

showcasecorp.driverURL=jdbc:sqlserver://ServerName:1433

To use a specific instance name (where more than one instance of SQLServer database exists on a single server):

showcasecorp.driverURL=jdbc:sqlserver://ServerName:1433;InstanceName=instance1

To use a specific database:

showcasecorp.driverURL=jdbc:sqlserver://ServerName:1433;InstanceName=instance1;DatabaseName=MASTER

Note: Warehouse Builder Definitions do NOT need to be changed, since only the database name is stored there.