Increase the MEMOWIDTH to greater then 50, say 1000.
SET MEMOWIDTH TO 1000
>When I create a connection in a DBC using a connection string and then LIST the connection the string data is trucated to 50 bytes.
>
>Here is some test code:
>
>
>CREATE DATABASE test
>CREATE CONNECTION testcon CONNSTRING "Driver={MSSQL}; SERVER=123.123.123.123; UID=USRTEST; PWD=PASSWORD;"
>LIST CONNECTIONS TO FILE "test.txt"
>
>
>Here is what I see both on the screen and in the output file:
>
>
>Connections in Database TEST:
> testcon
> Driver={MSSQL}; SERVER=123.123.123.123; UID=USRTES
>
>
>Note that the connection string data is trucated to 50 bytes. Any idea why this is happening?
>
>Thanks
>
>Alec
Greg Reichert