View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default 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