MS SQL Server Named Connection Example

This is an example of a named connection to a SQL Server table.


<?xml version="1.0" encoding="UTF-8"?>
<NamedConnection version="MXP_NamedResource_1_5" xmlns:gml="http://www.opengis.net/gml" xmlns:mxp="http://www.mapinfo.com/mxp">
    <DBConnection dbType="sqlserver">
        <ConnectionName>/mySQLServerConnection</ConnectionName>
        <JDBCDriverParameters>
            <JDBCUrl>jdbc:sqlserver://localhost:1433;databaseName=MyDB</JDBCUrl>
            <DriverPropertySet>
                <Property name="user" value="scott"></Property>
                <Property name="password" value="tiger"></Property>
            </DriverPropertySet>
        </JDBCDriverParameters>
    </DBConnection>
</NamedConnection>