>Hi to all:
>
>I get a "can't open the file my database.dbc" error when I try to open an adodb.connection object from an asp page (the driver is set to open the database shared and it isn't open exclusive in any machine).
>I tryed whith oledb for odbc and with the new oledb provider from vfp. The command open, view the .dbc file because returns his name in the error message but can't open it.
>I perform this task a few years ago with VFP5 without problems using the same asp page and I do it now using Access and it works fine.
>Is that anything new with the new drivers or ado sintaxis?
>Thanks for your help!
>
>Pedro
It could be a permissions problem. Make sure that the IUSR_ account for the web server has permissions on the file/folder where the DBC is located. Usually if you can get the FileSystemObject to see the file than you can open it with the ADO code on your ASP page.
Set FSO=Server.CreateObject("Scripting.FileSystemObject")
bFound = FSO.FileExists(strDBCPath)
Where strDBCPath is the full path to the DBC. HTH