Converting from dao to ado

[jbrowne]

Hi,
I'm converting a project from VB3 to VB6. In the VB3 version, I am accessing a Btrieve database using the ISAM driver included in VB3 through the jet engine using dao. VB6 no longer provides an ISAM driver (no 32 bit equivilent) so we have to try to access thru ODBC. The problem with this is that because we are no longer using the jet workspace - dao does not support the "seek" method which is used extensively throughout the project. I have been given advise to convert to ado but I am not very familiar with ado.
Would the conversion mean extensive code changes or does anyone know if there is a better solution ??

Thanks in advance
John B

 

[Karl Blessing]

DAO can still be used with VB6, also there are no "Conversions" (you are probally the 10th person to ask) ADO will have to be learned, if you want to move from DAO to ADO, but you should be able to use DAO 3.6 with VB6

 

[jbrowne]

Hi Karl,
Thanks for your prompt reply. Basicly my situation is that I need to be able to use the

 

[jbrowne]

Hi Karl,
Thanks for your prompt reply. Basicly my situation is that I need to be able to use the "seek" method in my code because of its extensive use in the VB3 version. I haven't found a way to do this because, in VB6, to use the "seek" method you must open your recordset as a table-type which is not supported if using ODBC. This is why I was exploring the ADO option. I am not familiar with ADO and have not got any great desire to change to it but I need a solution to the "seek" problem and I was told that ADO does support the seek method. Any advise you could give me would be greatly appreciated !

John B