ACT some progress but no one has replied so far - help please.

[garyusenet]

I posted earlier but no replies.
I have made some progress and have managed to figure out (i think)
syntax for connecting to the act database from c# only problem is it
doesn't connect. When i ask for the error code it's -87 which is listed
in the SDK as not being able to open the database.

here's my code (it's very small) : can you see anything i'm doing
wrong?
all relevent info for Act including sdk pdf can be found at
strident.net/act


==============================
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;



namespace actproject
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
ActOle.DATABASE database = new ActOle.DATABASEClass();

string mydbf = @"o:\database\database.dbf";

database.Open(mydbf);

MessageBox.Show(database.Error.ToString());
MessageBox.Show(database.LastError.ToString());




}

 

[garyusenet]

Ive discovered also if i set the filename to something random, i get a
different error code. error code 50 which indicates a bad filename. So
error code -87 which i'm getting must mean it's seeing the database but
just can't actually open it.