Which library? - Xtreme Visual Basic Talk

01-21-2005, 03:03 PM

wicko3

Junior Contributor

Join Date: Dec 2003

Location: England

Posts: 254

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:

Code:

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

__________________
Error - keyboard not detected. Press F1 to continue.

01-21-2005, 03:41 PM

HardCode

Ultimate Contributor

Forum Leader
* Expert *

Join Date: Feb 2004

Location: New Jersey

Posts: 3,338

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.

__________________
DON'T CLICK HERE

Useful forum tags: [VB][/VB], [CODE][/CODE], [HTML][/HTML]

01-21-2005, 05:10 PM

MKoslof

Cum Grano Salis

Retired Moderator
* Guru *

Join Date: Jul 2002

Location: Baltimore, Maryland

Posts: 14,636

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.

__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown