World Programming Limited (WPL) develop and sell the World Programming System (WPS), an interpreter for the language of SAS. A great alternative - Request a free evaluation of WPS.
WPS
Engine ModuleWPS 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 |  |
| Writing | |
| Updating | |
| Creating new tables | |
| Implicit Pass through support | |
| Explicit Pass through support | |
| Bulk Loading | |
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.
