Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using OLE DB and asp
Message
From
13/10/2001 09:47:59
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Using OLE DB and asp
Miscellaneous
Thread ID:
00568144
Message ID:
00568144
Views:
50
Hi there, i was trying to understand something about VFP and asp.
My intention was to call store procedures directly via ASP.
What have I to do ?
i tried to execute the code in VFP help changing obviously the Database address
but i got an error telling me about an invalid path or file name.
this is the code i used

Set conn = Server.CreateObject("ADODB.Connection")
conn.mode = 16
conn.ConnectionString="Provider=VFPOLEDB.1;DataSource=mydataname.dbc
conn.Open
'sql = "select * from mytable"
Set rsArrival = conn.Execute(sql)


now i got the error

Microsoft OLE DB Provider for Visual FoxPro errore "80004005"

Invalid path or file name.

/newvet/prova3.asp, riga 5

I tried to write different addresses but i always got the same error
I know i should probably study more about asp but...could you help me please ?

Thank u so much
Alessio
Next
Reply
Map
View

Click here to load this message in the networking platform