Database Drivers
DataSplice supports many different database drivers. Depending on the data source in question and the software installed on the server computer, the most appropriate driver can be used.
Choosing a DataSplice Database Driver
A DataSplice database driver combines an ADO.NET database provider with meta-data information for a specific type of database. Database client software refers to the database client installed on the machine running the DataSplice Server.
Recommended Configurations
When all aspects of the installation environment can be controlled, such as during a new installation on a fresh, dedicated server machine, the following drivers and client software should be used.
| Database Platform | Database Client Software | DataSplice Driver |
|---|---|---|
| Microsoft SQL Server 7.0 & Up | MDAC 5.8 (built into the latest .NET framework) | Microsoft SQL Server |
| Oracle 8i | Oracle NET 9 Client | Oracle ODP.NET 9 |
| Oracle 9i | Oracle NET 10 Client | Oracle ODP.NET 10 |
| Oracle 10g | Oracle NET 10 Client | Oracle ODP.NET 10 |
| MySQL | MySQL |
Other Configurations
In cases where specific client software is already in place, such as when DataSplice is being installed on an existing database or CMMS server, other drivers may need to be used. This is also true of older database versions. The following drivers can be used when either using older database platforms or when the specified older client software is already in place on the server machine.
| Database Platform | Database Client Software | DataSplice Driver |
|---|---|---|
| Microsoft SQL Server 6.5 | MDAC 5.8 | Microsoft SQL Server 6.5 via OleDb |
| Microsoft SQL Server (any version) | ODBC | Microsoft SQL Server via ODBC |
| Oracle 8 | ODBC | Oracle 8 via ODBC |
| Oracle 8i | Oracle NET 8 Client | Oracle 8 via OleDb |
| Oracle 9i | Oracle NET 9 Client | Oracle ODP.NET 9 |
Last modified 2005-12-08 12:34 PM