ICE98

ICE98 verifies the description field of the ODBCDataSource Table for an ODBC data source. It uses the SQLValidDSN function to check that only valid characters are used, and that the description does not exceed the maximum allowed length.

Result

ICE98 posts the following warnings.

ICE98 warning Description
The data source name is invalid. The value in the Description column of the ODBCDataSource Table either contains invalid characters or is too long, which means that it exceeds the SQL_MAX_DSN_LENGTH of 32.

 

Example

ICE98 reports the following warnings for the example:

The data source name is invalid: !
The data source name is invalid: <String of length > 32>

ODBCDataSource Table (partial)

DataSource Description
BadChar !
TooLong <String of length > 32>

 

ICE Reference

ODBCDataSource Table