>When I run the following code I get the VFP... Select Data Source dialog.... for each command. Can anyone give me direction as to what I need to change to keep this dialog from comeing up?
>
>open database sugar
>
>create connection myconnect connstring MS Access 97 Database;DBQ=C:\PROGRAM FILES\MICROSOFT VISUAL STUDIO\VFP98\test.mdb;DefaultDir=C:\PROGRAM FILES\MICROSOFT VISUAL STUDIO\VFP98;DriverId=281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
>
>create sql view myview remote connection myconnect as select * from tom
>
>
>Thanks for your help.


Its asking for datasource and this means your connection string is invalid. I could see " " are missing in your connection string. Try enclosing your string inside these quotes.

Regards