From: Cathy Taruskin (cathyt_at_uclink.berkeley.edu)
Date: Wed Jun 11 2003 - 09:33:43 PDT
One more tip: After you link the tables in Access, rename them (in Access)
to the same table names that are currently used in your ASP select
statements. That way the only thing you'll need to change in your ASP is
the connection string -- you can leave your select statements alone (probably).
At 09:16 AM 6/11/2003 -0700, L Lockwood wrote:
> > However, if you are runing Oracle 9i it has the same capablility
> > of creating a table that is "linked" to an external data source and
> > behaves as a normal table in your db.
>
>Aha! This sounds promising, since (I think) we're about to migrate to 9i.
>
>Thank you for all the good feedback, Rusty, Kurt, Cathy, and John! I'm
>going to investigate the Access and Oracle-linking ideas first, since they
>sound like less work in the long run (we have lots of reports to convert).
>If anyone has more ideas, though, I'd still be glad to hear 'em.
>
>Much obliged, folks. I hope I can be of as much help to some of you in the
>future.
>
>-----------------
>Lyman Lockwood
>Webmaster, Programmer/Analyst-II
>PP-CS Information Systems Group
>3-8467
>
>
>
>------------------------------------------------------------------------
>The following was automatically added to this message by the list server:
>
>For information about Micronet, including subscribing to
>or unsubscribing from its mailing list and finding out
>about upcoming meetings, please visit the Micronet Web site:
><http://micronet.berkeley.edu/>.
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.
This archive was generated by hypermail 2.1.5 : Wed Jun 11 2003 - 09:34:25 PDT