Configuring ODBC to access the database MS SQL Server

Print Previous page Top page Next page

- 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:

clip0013

 

- Window of data source settings appears. Enter a name of data source, for example, ExzampleSql.

 

Window of Creating Data Source:

clip0014

 

Window of Creating Data Source:

clip0015

 

- Use the tag Use by default a database, then choose a file of database SQL Server (for example, master).

 

Window of Creating Data Source:

clip0016

 

- Click Next and then on the next page - Done.

- Check the workability of the created data source.

 

Window of Creating Data Source:

clip0017

 

- Select the alias, for example, ExampleSql.

 

Window of  Adding a table into the project:

clip0018

 

Choose a table name and click the Add button.

 

Window of  Adding a table into the project:

clip0019

 

When you use the ODBC Driver for SQL Server, you need a computer with installed MS SQL Server.