Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using RDS inside VFP (with DBF tables on IIS)
Message
 
To
26/11/2001 06:11:30
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00585249
Message ID:
00586068
Views:
39
Ok, on the server is working standard technology:

DBF+ASP+IIS (customers can see, change and add information), all of this work perfectly.

But I need application where I can see information on the remote server in my VFP 6.0 application via HTTP. I was reading in Microsoft's manual, that we can do it via RDS and wrote next program:

conn="Provider=MS Remote;"
conn=conn+"Remote server=http://myserver/"
conn=conn+"Remote provider=MSDASQL;"
conn=conn+"DSN=base;uid=;pwd="
sql="select * from title"
ors=createobject("ADODB.Recordset")
ors.Open(sql,conn)

But I receive error when try ors.Open(sql,conn) - service forbidden and in the protocol on the server I can see error 403 (resource not available).

May be I do something wrong? I don't know but I filling that it have to work...


>Sergey can you post the code in ASP file that works and the code that you say doesn't work via standard MS RDS take note that as I said in my previous message you can't access via HTTP.
>
Previous
Reply
Map
View

Click here to load this message in the networking platform