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:

_engbm5640

 

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

 

Window of Creating Data Source:

_engbm5641

 

Window of Creating Data Source:

_engbm5642

 

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

 

Window of Creating Data Source:

_engbm5643

 

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

- Check the workability of the created data source.

 

Window of Creating Data Source:

_engbm5644

 

- Select the alias, for example, ExampleSql.

 

Window of  Adding a table into the project:

_engbm5645

 

Choose a table name and click the Add button.

 

Window of  Adding a table into the project:

_engbm5646

 

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