[AccessD] {Accessd] ODBC driver to Oracle to enable Access queries

Hi Bill:

I have been this route a few times and the one outstanding issue I found was
the speed or lack of speed when using an ODBC drivers. I have always
converted/have had to concert the connection to ADO-OLE... the performance
is on a magnitude of difference.

The bottle neck comes when attempting to download data (select). Delete,
Update and in most cases Add requests are fairly quick. It also helps a lot
if most of the SQL processing is done through procedures on the Oracle
server... as well as it being much more secure.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Morrill
Sent: Tuesday, September 18, 2007 7:49 AM
To: Accessd at databaseadvisors.com
Subject: [AccessD] {Accessd] ODBC driver to Oracle to enable Access queries

 9-18-07

I have a client who wishes to link up to Oracle databases in several US
cities. These hookups would be up to 1000 miles from his office.   He wants
to use an Access ODBC driver via the Internet to enable Access querying.  He
has asked me to check this out as to the whys and wherefores.


Help!!!!!.   Is it possible to do this?  Any books/articles on this topic?

Thanks in advance,

Bill
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com