Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LIST CONNECTIONS truncating to 50 bytes
Message
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:
01351965
Views:
21
This message has been marked as the solution to the initial question of the thread.
Hi Alec,

You can use ADBOBJECTS(ArrayName, cSetting) and save result across TEXT...ENDTEXT

MartinaJ


>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
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform