Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odbc error from asp page
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00576671
Message ID:
00576683
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform