![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
• Copy the appropriate JDBC drivers file to BE_HOME/lib/ext/tpcl. You must restart BusinessEvents Studio Explorer after copying the drivers file. This step is required before you can use the design-time Test Connection feature. It is also required for runtime.
•
• Microsoft SQL Server 2008 has added a new data type, datetime2, which has a date range of 0001/01/01 through 9999/12/31. Therefore, if you are using Microsoft SQL Server 2008, then you can manually change the generated SQL script (DDL) for your backing store, and replace any affected columns’ data type from datetime to datetime2.
• Use the SQL Server JDBC driver, sqljdbc4.jar. You can download this driver from:
• Use ojdbc6.jar drivers file.You can download this file from the following location:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |