Configuring ODBC to access the database MS SQL Server |
- Start the program the Data Source Administrator. - In section User DSN or System DSN click Add button. - In the appeared window choose driver SQL Server and click the Next button.
Window of Creating Data Source:
- Window of data source settings appears. Enter a name of data source, for example, ExzampleSql.
Window of Creating Data Source:
Window of Creating Data Source:
- Use the tag Use by default a database, then choose a file of database SQL Server (for example, master).
Window of Creating Data Source:
- Click Next and then on the next page - Done. - Check the workability of the created data source.
Window of Creating Data Source:
- Select the alias, for example, ExampleSql.
Window of Adding a table into the project:
Choose a table name and click the Add button.
Window of Adding a table into the project:
When you use the ODBC Driver for SQL Server, you need a computer with installed MS SQL Server. |