To whom it may concern

I already found my answer to this problem. silly of me i didn't know you have to specify to the RV whether it has to use the global connection or its own. the default value for that setting is .F. on not use a shared connections, i just had to put it to .T.

regards



>Selim,
>
>

>= SQLSETPROP(0,'DispLogin',3)  && No login dialog
>

>should prevent the login prompt from appearing. You need to put the code before the line that contains SQLCONNECT.
>
>Cheers,
>
>Zoran
>
>
>
>>I have a problem that's been bothering me for a day now.
>>
>>I am building a form in a software named Visual Accountmate for SQL. The software comes with certain number of tables and one Remote View for each table. they have been put together on a DBC and uses a connection to the backend name VAMCONNECT.
>>
>>the VAMCONNECT doesn't have a password on it, for security reasons, but the software creates a global connection through a sqlconnect command at the start of the application. everything was working well with the form i am building until i had the need of create a new sql table and a new Remote View. I added to the form and when i run the form it keeps on asking me the user and password for the ODBC connection only for the RV i added. if i remove it works well, put it again, starts asking the pass.
>>
>>any ideas?
>>
>>TIA