odbc-configure connection dialog box always prompt, why ?

Now, I can create my remote view programically (save as create_view.prg)
However, everytime I run the create_view.prg,
there is a dialog box prompt out , i need to press "OK" , otherwise, the
remote cannot be created.
It is very troublsome for the user .

Can anyone how to solve it ??
Thanks in advance
From agnes


My code is shown as below.
OPEN DATABASE u:\cgl\vfpseafreight\data\transport.dbc
IF INDBC("t_data","connection") = .F.
CREATE CONNECTION t_data;
connstring ;
'Driver={Microsoft Visual Foxpro
Driver};DBQ=u:\cgl\vfpseafreight\data\transport.dbc;BackgroundFetch=Yes'
ENDIF
IF INDBC("tview","VIEW") = .F.
CREATE sql VIEW tview remote CONNECTION t_data AS SELECT
number,jobno,closesw FROM billLadingHeader order by number
ENDIF

Leemi
Wed Feb 04 09:18:18 CST 2004

Hi Agnes:

Have you tried issuing a SET SAFETY OFF or a SET NOTIFY OFF?


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003



>Now, I can create my remote view programically (save as create_view.prg)
>However, everytime I run the create_view.prg,
>there is a dialog box prompt out , i need to press "OK" , otherwise, the
>remote cannot be created.
>It is very troublsome for the user .

>Can anyone how to solve it ??
>Thanks in advance
>From agnes


>My code is shown as below.
>OPEN DATABASE u:\cgl\vfpseafreight\data\transport.dbc
>IF INDBC("t_data","connection") = .F.
> CREATE CONNECTION t_data;
> connstring ;
> 'Driver={Microsoft Visual Foxpro
>Driver};DBQ=u:\cgl\vfpseafreight\data\transport.dbc;BackgroundFetch=Yes'
>ENDIF
> IF INDBC("tview","VIEW") = .F.
> CREATE sql VIEW tview remote CONNECTION t_data AS SELECT
>number,jobno,closesw FROM billLadingHeader order by number
> ENDIF

anonymous
Wed Feb 04 09:26:07 CST 2004

What dialog box? Is it the ODBC Admin window
Please try to read about SQLSETPROP(lnHandle, "DispLogin", 3

If it is not solved, then try not to use remote views instead use SQL SELEC
directly and attach INTO CURSOR NameOfCursor i.e

SELECT <fields> FROM <table> INTO CURSOR Xy

After which you can already manipulate the cursor Xyz just like any cursor