ADO vs ODBC question
David,
I hope I get this right. ADO provides you with classes to work with a
database. In order to connect to a database, you must specify a database
provider or interface like ODBC, OLE, etc..
So, if a client computer needs to use ADO in order to connect to a database,
they will need to install the Microsoft Data Access Components to get the
runtime libraries for ADO. And, they will need to install the appropriate
database driver (i.e., ODBC driver or OLE DB Driver).
--
Hope that helps.
Vergel Adriano
"David Wessell" wrote:
Hi.. I'm creating a Spreadsheet that will reside in a Shared Folder on
a Server 2k3 machine.
Users will open up the spreadsheet from the shared folder on their
local machine.
Am I correct that if I use a ADO connection, they will need the driver
(Firebird DB, Interbase driver) on their machine?
However, if I use a ODBC connection that is setup on the server, then
they will not need the drivers on their machine?
thanks
David
|