MS SQL Server Named Connection Example - spectrum_spatial - Latest

Spectrum Spatial Guide

Product type
Software
Portfolio
Locate
Product family
Spectrumâ„¢ software
Product
Spectrumâ„¢ software > Spatial > Spectrum Spatial
Version
Latest
ft:locale
en-US
Product name
Spectrum Technology Platform
ft:title
Spectrum Spatial Guide
Copyright
2025
First publish date
2007
ft:lastEdition
2025-03-07
ft:lastPublication
2025-03-07T10:28:48.112000

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>