An SQL connection can be used when you want to create for instance a connection on an SQL database.

Select the SQL connection type and click Create.

New SQL connection

New SQL connection

 

To establish the connection, specify the SQL server name, database name and authentication.

sql2

 

The connection string is displayed in the connection string window. The connection string of an SQL connection contains the parameters Data Source / Initial Catalog / User / Password. Via Test you can check the configured SQL connection for correctness.

_img57

icon_cross-reference

You can find more information about creating Connection Strings on http://www.connectionstrings.com.

 

You can now include tables and feature classes via your newly created SQL connection.

icon_warning

ATTENTION!

If you use the storage type "ST_Geometry" in the Select * query on your SDE feature class, the error "DataReader.GetFieldType(26) returned 'null'" may be returned when reading the data. This is because the geometry type cannot be interpreted. In order for the "ST_Geometry" field to be recognized by the client application, it is necessary to install a SQL Server version-specific feature pack. The FeaturPack is named SQLSysClrTypes.msi, must be a 32bit msi and is installed on the client.