OpenInsight has native drivers for SQL Server and Oracle. You may want to compare the performance of the ODBC connection with the native connection. To do this, you change the connection in the Client/Server Connection Designer and then run your application.
To change to the native SQL Server connection, click on the Data Source Type: dropdown and select SQLServer. The Server attribute is required. The other attributes are optional.
The dialog where you make the change is shown below:
After saving the changes, the PUBS connection will connect as a native SQL Server data source. An ODBC definition is not required. CS_SPY will display the Data Source Type as SQLServer if the connection is using the native SQL Server driver.
No changes need to be made to the application code, since the PUBS connection is handling the connection details on behalf of the program.
