The new ODBC Driver 13.1 is significant in its own right, especially when combined with the latest DataFlex driver for Microsoft SQL Server. It also has enhanced security and now runs on the Linux as well as Microsoft operating systems. SQL Server 2017 offers breakthrough scalability, performance, and availability for mission-critical, intelligent applications and data warehouses. See the Current Products List for details. Both products are now supported for use with DataFlex mobile, web and Windows applications. Your data source is now ready for use under your Windows user account on the computer where these steps were performed.Microsoft has recently released SQL Server 2017 and ODBC Client 13.1.

Click OK to close the test results and then OK again to save the new data source.

Confirm that test results indicate 'TESTS COMPLETED SUCCESSFULLY!'. In the ODBC Microsoft SQL Server Setup window, click Test Data Source.Check the Change the default database box and then, in the drop-list below, click the drop-down button and select your SQL Server database.Select the appropriate authentication (login) options to access your SQL Server and click Next.In the Server box, click the drop-down and select the SQL Server where your database is stored.In the Description box, enter a description for your data source.The Create New Data Source to SQL Server window will appear. In the Create New Data Source window, scroll down the list of drivers, select SQL Server and click Finish.If so, enter the login credentials for a user with administrator permissions on the local machine. NOTE - You may receive a User Account Control prompt at this point.

In the Open box, type one of these two paths depending on whether your operating environment is 32-bit or 64-bit and then click OK:.Click Start and then Run, or while holding down the Windows key on the keyboard, press R.One application of this would be for testing the operation of the ODBC driver to confirm whether it is functioning as expected on a given workstation. This topic is therefore provided for the purpose of utilizing ODBC functionality outside of Event 1 applications. Event 1 applications access the SQL Server databases via ODBC without the need to define a Data Source. Applications that can utilize ODBC Data Sources will allow you to identify the source of data using the name that you assign. An ODBC Data Source consists of a descriptive name that you provide and a SQL Server database that it represents.

Microsoft odbc driver for sql server