General information
Title:
VFP60- Remote Views
Article Q137944 explains how to create a remote connection or view programmatically.
The problem that I have is that I don't see a way to specify a USERID and PASSWORD for a VFP table or ACCESS table and also a way to specify where the SERVER with my data is.
Is this possible only with SQL Server Data Sources? I am trying to do this with an NT Server. Is this possible? Thank you in advance.
This is the code in Article Q137944:
CLOSE ALL
SET DEFAULT TO c:\temp
CREATE DATABASE zdb
CREATE CONNECTION zconn DATASOURCE sqltest USERID sa PASSWORD ""
CREATE SQL VIEW zview REMOTE CONNECTION zconn AS select * from ;
pubs..sales
USE zview
BROWSE
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only