ADODC in Visual Basic 6 - error -5016 connecting to dbf
Posted on 2009-04-07
I am trying to create a standard exe application in VB6 that can work with our client database, which is in .dbf format.
I have added Microsoft ActiveX Data Objects 2.8 Library and Microsoft ActiveX Data Objects Recordset 2.8 Library as references and added the ADODC component.
With the ADODC I am using a data link file named "clients.dbf.dsn" to link to the database and this contains the follwoing:
DRIVER=Driver do Microsoft dBase (*.dbf)
I have chosen the command type adCmdTable and this allows me to select the only Table contained in the database, named "clients".
I have added a text box and named the record source as the ADODC, but when I try to name the Data Field I recieve the following error:
[Microsoft][ODBC dBase Driver] Reserved error (-5016); there is no message for this error
I can find no resources about what this means, other than it is an "Unexpected error from external database driver"
I have connected to both .mdb and .dbf in this manner before and cannot work out what is going wrong.
I have tried importing the database into Access and recieve the same, or very similar, error message.
Can anyone please help?