Re: ASP, Oracle & Fox Pro knitting it all together?

From: Doug Clark <Doug_at_NoStinkingSpam.com>
Date: Tue, 24 Jul 2001 21:40:02 -0700
Message-ID: <9jlhqv$j44$1@newstest.laserlink.net>

Unfortunately the Fox Pro data is part of a 3rd party app I have no control over the structure of, as is the Oracle data.

The way I got around the problem was to use the ASP page to connect to both the Fox and Oracle databases, then copying the Fox data into a temp table created on Oracle for the purpose.

I then could pass a real Oracle query from the ASP page to Oracle and get a sensible result back.

To finish I delete the temp table. I don't know if this is a "Professional" way around this problem but it seems to work for me.

I don't have any bandwidth problems as this is all on a Intranet.

Doug. Received on Tue Jul 24 2001 - 23:40:02 CDT