Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlStringConnect()
Message
From
13/11/2002 15:51:59
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SqlStringConnect()
Miscellaneous
Thread ID:
00722358
Message ID:
00722358
Views:
61
Using VFP7.

The following works if I use my IP address in the server parameter.
lnHandle = SQLSTRINGCONNECT("driver={Microsoft Visual Foxpro Driver};server=MyIPAddress;" + ;
	"uid=;pwd=;SourceType=DBF; Exclusive=No;Collate=Machine;SourceDB=c:\Apps;")

?SQLEXEC(lnHandle,"SELECT * FROM mytable", "mycursor")
=SQLDISCONNECT(0)
But if I use another web servers IP address, the SQLEXEC() returns -1. But the lnHandle returns a 1.

Should I be able to query a table on another web server's drive with the above code if I got a valid handle.

Thanks,

Jerry
Next
Reply
Map
View

Click here to load this message in the networking platform