Hi,

I've read a lot of articles about using Shared connection but I failed to make it. Thank you for your help.
What I've done are:
1. In the VFP setting, checked the "Share connection" and saved as default.
2. Create a database, create a valid connection with "connection string".
3. Add a view using that connection and set it as "shared connection".
4. Modify that connection and put dumpy "aaaa" in the PWD and UID.
5. Establish a connection :
n1=sqlstringconnect('DSN=testdb;UID=dba_test;PWD=test;SERVER=testdb;')
The n1 is work. I've tested it by SQLEXEC().
6. Use the remote view: USE TEST1.

But I always got a message ->Connectivity error: invalid username/password.

Did I miss something ?

Wilfred