Skip to content

DataSplice Support Website

Sections
Personal tools

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
 

Powered by Plone

This site conforms to the following standards: