AdsConnectionTrim spaces from string data

Fields of type String will have trailing white spaced trimmed on retrieval.

Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
Password
=myPassword;ServerType=REMOTE;TrimTrailingSpaces=TRUE;

If FALSE is specified, then trailing white space is maintained on the values when they are retrieved. This means that a fixed length String field with a width of 10, for example, will always return 10 characters when the value is retrieved; it is padded with as many spaces as necessary.

Connecting

This connection string (Trim spaces from string data using AdsConnection) can be used for connections to Sybase Advantage.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.