Creating a Data Source Connection to SQL Server - MapInfo_Pro - 2023

Before you begin, you need a SQL Server driver installed on your machine. Check with your database administrator to install the driver for your database.

You need to know the SQL Server name, and the login ID and password if required.

To create a new SQL Server data source connection:

1. On the HOME tab, in the File group, on the Open list, click Database Table. This can also be done from the TABLE and MAP tabs.
2. If the Open DBMS Connection dialog box opens, select ODBC from the list and then click New.
   
   

   

   
   
3. In the Select Data Source dialog box, select either the File Data Source or the Machine Data Source tab and then click New.

   You can share the connection information for a file data source with other users on the network if they have the necessary drivers, because it is stored in a file. You cannot share the connection information for a machine data source, because it is stored in the registry on the local computer.

   
   

   

   
   
4. In the Create New Data Source wizard:
   1. Select the type of data source to create: User Data Source or System Data Source. Make a selection to display the description for it in the wizard. Click Next to continue.
   2. From the driver name list, select the SQL Server driver you have installed for the database and then click Next.
   3. Click Finish.
5. In the Create a New Data Source to SQL Server wizard set the following. If you are unsure of the settings to use for your database, consult with your database administrator.
   1. In the first screen provide the following information:

      Description - Optionally, type a description if you plan on connecting to more than one database and would like a description for this connection.

      From the Server list either select from the list or type the name of the SQL Server to connect to.

      Click Next.

      
      

      

      
      
   2. In the next screen, select how SQL Server will verify the authenticity of the login ID.

      Optionally select to connect to SQL Server to obtain default settings for more configuration options. Click Next.

   3. Keep the default settings (check with your database administrator) and click Next.
   4. Keep the default settings (check with your database administrator) and click Finish.
6. In the ODBC Microsoft SQL Server Setup dialog box, click Test Data Source.
7. In the SQL Server ODBC Data Source Test dialog box, click OK.

   If there were errors, click OK to return to the ODBC Microsoft SQL Server Setup dialog box. Click Cancel to return to the Create a New Data Source to SQL Server wizard and use the Back button to view your settings and make changes. Return to step 5.

8. In the ODBC Microsoft SQL Server Setup dialog box, click OK.
9. In the Select Data Source dialog box, under the Machine Data Source tab, your new SQL Server connection displays in the list of available data source connections. Click OK.
10. In the SQL Server Login dialog box, type your login ID and password if required and click OK.
    
    

    

    
    

You must now create a map catalog for the database, continue to Creating a Map Catalog Table Using MapInfo EasyLoader.