kshathrya <kshathrya_at_hotmail.com> wrote in message
news:tot5lsgms59i02_at_corp.supernews.com...
> The scoop, i need an application server or a database interface, which can
> talk to the c,c++ tools and the database and can keep the database
> connections open and do caching.
>
There are _so_ many issues here. Why do you need to maintain the connection
and do caching? I'll admit that that SQL*NET (which AIR oracle odbc uses)
can be a pig and very slow to get up to steam, but a better solution might
be to use a 3rd party odbc/jdbc. Or run a data warehouse (in the _original_
sense of the term - a staging area for reporting data out of a transactional
system - not specifically an OLAP system). You might also want to have a
look at odbc/odbc bridge (try searching http://freshmeat.net).
HTH
Colin
Received on Fri Aug 31 2001 - 03:04:15 CDT
