Data Engine Module

WPS Engine for SQL Server

SQL Server Database Connectivity

Accessing a SQL Server database with WPS is supported by using the WPS Engine for ODBC module. WPS provides a specific SQLSERVER facility in the WPS Engine for ODBC dedicated to accessing a SQL Server database.

Type of Access Supported?
Reading Yes
Writing Yes
Updating Yes
Creating New Tables Yes
Implicit Pass Through Support Yes
Explicit Pass Through Support Yes
Bulk Loading Yes

Dependencies and Usage

The SQLSERVER facility in the WPS Engine for ODBC can only be used on the Windows platform.

For use on Windows, the operating system is supplied with an ODBC administrator, however you will require an appropriate third party ODBC SQL Server driver.

Please enable JavaScript to get the best out of our website. You will be unable to do certain things without it, including logging in, registering or filling out our contact forms.