Not really!, i think i forgot to tell you, there is more than one RV on the DE. about 14 of them open with zero problems. only when it comes to the new table and new remote view i just added.

so it only happends with this cursor

>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