You are using remote views, so I assume you have created a connection in the database. To look at the connection, type -- MODIFY CONNECTION or MODI CONN -- then pick the connection to modify from the dialogue box.
You should have a DSN selected and the UserID and Password fields are probably blank. Type in a UserID but leave the password blank.
Look in the VFP Help under DBSetProp to learn how to set the UserID, Password and ShareConnection properties. To get you started, here is some sample code on how to make all remote views for a specific connection name use a shared connection:
lnRetVal = adbobjects(laViews, 'View')
for i = 1 to lnRetVal
if upper(dbgetprop(laViews[i], 'view', 'connectname')) = 'YOUR_CON_NAME_HERE'
DBSetProp(laViews[i], 'View', 'ShareConnection', .T.)
endif
endfor
>I'am sorry but I do not fully understand using the dbsetprop. I am new to vfp 6.0. I stayed too long in fp2.6 dos. Trying to catch up.
>
>open database xyx ( 10 tables in this database)
>
>then I;
>
>use namefile
> (Must enter password at this time)
>
>select namefile
>copy to another directory
>use
>
>repeat above.
>
>I changed the connection information as someone suggested, but it did not seem to make a difference.
>
>What would the code look like to run it as you suggested?
>
>
>Thanks much....
>Roland
Mark McCasland
Midlothian, TX USA