HOWTO: How to Disable ODBC Login Prompt at Run-Time

MORE INFORMATION

Using a Named Connection

1. Create/Open a database container (for example Test.dbc).
2. Create a dummy connection, "conn1", and specify a datasource.
3. Leave the Userid and Password fields blank.
4. Select Never for "Display ODBC Login Prompt".
5. Use the following code to change the Username and Password in the named connection:

         =dbsetprop("Conn1","connection","UserID","<userid>")
         =dbsetprop("conn1","Connection","Password","<password>")
   							

6. Now you can use the connection to connect to an ODBC DataSource without getting the Login prompt.

Using SQLStringConnect() or SQLConnect()

1. Run the following code to set the default setting of a SQL connection:

         =SQLSetProp(0,"Displogin",3)
   							

   Setting 0 (zero) as the connection handle specifies Visual FoxPro default settings at the environment level.
2. Now you can connect to the ODBC datasource using one of the following commands, without getting the login prompt:

         =SQLStringConnect('dsn=<Data Source>;uid=<User ID>;pwd=<Password>')
   							

   -or-

         =SQLConnect('<Data Source>', '<User ID>', '<Password>')