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?|
|Creating New Tables|
|Implicit Pass Through Support|
|Explicit Pass Through Support|
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.