Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RV keep on asking me for the user and password
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01299737
Message ID:
01299740
Views:
9
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform