General information
Title:
Using OLE DB and asp
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
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