Which library?

Is there any difference between Microsoft ActiveX Data Objects 2.8 Library and Microsoft ActiveX Data Objects 2.7 Library?

I am only using ADO to execute commands of the following types:


myCon.ConnectionString = "....."
myCon.Open
myCon.Execute "SQL Statement here"
Set myRec = myCon.Execute("SQL Statement here")
myCon.Close


I've been using the 2.8 library at home, but school only has the 2.7 library. I'm just trying to find out in advance whether my program will still work. Will I need to adapt any code, to allow for the different libraries?

John

You always want to make sure that the PC running the app has the correct ADO version as the program using ADO. If you need to create apps at home and at school, then you can download ADO2.7 from Microsoft and install it on your home PC and reference 2.7. You can have all of the ADO versions installed at the same time on a PC. When searching MS, the file name will decievingly be "MDAC_type.exe" with no version info. Change the .exe name to include the correct version for future reference.

To add to what HardCode has said, with every new version of MDAC, typically something is improved or removed :). For example, with the release of version 2.8, support for the old MSDASQL drivers has depreciated. These database drivers are no longer supported and it is advised to use native OLEDB providers instead.

Basically, it is always good to have the latest and greatest MDAC.

thank you

Good luck, let us know if you have any more questions