I get the following message when trying to connect to an advantage database:
Run-time Error '3706' Provider cannot be found. It may not be properly installed.
It works fine when I try and connect to the database using the machine the application was developed on, but get the error when using a different pc even though i am usings the same .exe and database?
My VB code is as follows:
ConnObj.Open "Provider = Advantage OLE DB Provider;Data Source = C:\Program Files\Acorn\Database\connex.add;ServerType=ADS_LOCAL_SERVER; TableType=ADS_ADT;"