We have a VFP database that resides on a novell server. When we try to access it using VFP ODBC from ASP we get a message saying file is not found when we try to open it.
the ASP code is as follows:
set conn=server.createobject("adodb.connection")
conn.open("connODBC") <----- Error appears here (File not found)
where connODBC is the ODBC DSN name that points to the Novell server directory where the .DBC file resides.
This works from inside VFP or if the data resides on an NT server. Would anyone know why this is happening?
Costas