Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LIST CONNECTIONS truncating to 50 bytes
Message
From
01/10/2008 06:46:51
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01351962
Message ID:
01351972
Views:
23
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform