Unanswered: ACT! Database access from a scripting language
I'm trying to connect to an ACT! database with ASP, however, I'm having absolutely ZERO success. Has anyone has any experience with this at all and/or could point me to some decent documentation on how this is done?
I've gone through the normal connection string and ISAM supportive perspectives to no avail...
Here's my code *just in case* I'm so tired I'm missing the boat entirely...
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= ""C:\Database\Contacts.dbf""; Extended Properties=""FoxPro 3.0;"";"
and the lovely error that I always receive is:Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC dBase Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/act/dbConnect.asp, line 13
I'm also interested in a solution to this problem. We use ACT internally and would like to make a section of our data available on our website for viewing, it's a referral directory which users can browse.
I had a look on the ACT! website and they recommend not to do it, but probably because they want to sell their own tool, ACT! for Web, see article at:
Has anyone had any luck connecting to an ACT! database .dbf file using ODBC or an OLE DB or connection string and is able to read and write back to the ACT! database and still use it with the ACT! application itself?
I'm able to access about a dozen or so ACT 6.0 databases in my office. The problem is the results are not always reliable. I have a database with 639 leads in it, and if I do a "SELECT * FROM mydb.dbf" I only get 527 records.
To make things worse, some of the 527 are records that have been deleted from within Act! If anyone has any insight to this, I'd really like to hear it.