Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View Problem
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01205044
Message ID:
01205142
Views:
18
>Yep, that's what I figured. I've done tow things to set up the connection:
>
>(1) I created a File DSN.
>
>(2) I created a DBC Connection.
>
>Neither seems to do the job and I cannot open the file automatically without that OPEN FILE dialog box appearing every time wanting me to find the MDB that is already defined as said in the above two places.
>
>I may have to create the Connection on the fly with SQLSTRINGCONNET()?
>
>Cecil
>
>>If you can't open the view with USE in a command window, something's missing. With ODBC and remote views, you have two basic choices:
>
>>- include connection information as part of the Remote View definition, stored in the .DBC
>>- create your connection on-the-fly
>
>>Assuming the former, you might want to check that your connection string is complete. One good resource is http://connectionstrings.com/ .

Have you checked that your connection string is complete, at the site I referenced?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform