ADO vs ODBC question

[David Wessell]

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

 

[Guest]

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).

 

[David Wessell]

Hi Vergel..

Thanks for that..

Is there a way to fashion it such that the file can reside on the
server, and when a user opens the file from their machine (But the
file is on the server) that it would utilize the ODBC connection on
the server, instead of their client machine?

I've written a spreadsheet, that makes DB query calls, and I want
everyone to be able to access it for viewing, but not have to install
the ODBC driver... Thanks for any suggestions.

Thanks
David

 

[David Wessell]

Hi Vergel..

Thanks for that..

Is there a way to fashion it such that the file can reside on the
server, and when a user opens the file from their machine (But the
file is on the server) that it would utilize the ODBC connection on
the server, instead of their client machine?

I've written a spreadsheet, that makes DB query calls, and I want
everyone to be able to access it for viewing, but not have to install
the ODBC driver... Thanks for any suggestions.

Thanks
David

Actually, I think I'll do a new topic on this one.. Thanks for the
information..

Thanks
David