MS SQL Server Reader
- All properties are very similar to ODBC connection
- Leave user name and password blank to use Windows Authentication
- To connect using different port use “server name,port” format
ODBC Drivers
Our software automatically selects the highest installed driver in the following order
- ODBC Driver 17 for SQL Server
- ODBC Driver 13 for SQL Server
- ODBC Driver 11 for SQL Server
- SQL Server Native Client 11.0
- SQL Server Native Client 10.0
- SQL Native Client
- SQL Server
Always Use set sql nocount on inside Microsoft SQL Server Stored Procedures, Triggers and Scripts
Last updated: March 8, 2023