Selim,
= SQLSETPROP(0,'DispLogin',3)
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