Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Anyone using Reporting Services ?
Message
From
09/11/2004 10:48:14
 
 
To
05/11/2004 00:00:43
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00957655
Message ID:
00959563
Views:
15
>Are you able to connect to the data remotely using VFP OLEDB from within VFP or even VB?

Yes. At least from that machine, logged in as me.
oConn = CREATEOBJECT("ADODB.Connection")
oConn.ConnectionString = "Provider=VFPOLEDB.1;Data Source=\\eukfs01\mis_deve\andersonanalysis\data\"
? oconn.Open()
&& returned .NULL. Indicating no error
loRS = oconn.Execute("select * from dafacts")
? lors.Fields(1).Value && "GB"
? lors.Fields(1).name && "cctrycode"
? lors.Close()
&& should returned .NULL. Indicating no error
RELEASE lors
? oconn.Close()
&& should returned .NULL. Indicating no error
RELEASE oconn
I've asked someone else to test this on their machine to confirm they can access the server data from VFP.
Previous
Reply
Map
View

Click here to load this message in the networking platform