Oracle Database Discussions

Hi All,

I work mainly with MS SQL Server and Active Server Pages, I last used Oracle 7.3. I have a requirement to connect via a VPN to a customers Oracle Database to use their tables in a read-only view as a data source for a dynamic Web page built using ASP at my site.

There appears to be an ODBC driver in WIN NT, but when you try to configure it, it seems you need to add some Oracle Client software to make it work. Is this the case ? I had great fun configuring SQL*Net when I last used Oracle.

Next question, how do I get hold of the relevant Oracle Client software and is it chargable ? Does their Licence cover my connection (provided of course that they have bought the relevant user counts ?

Last question, is ODBC the best way to go for this application, or is there a better way to do it ? I'm obviously a bit worried about network latency across the VPN.

I'd prefer to have an Oracle database at my site and use replication, then connect my ASP pages to the local copy, but the cost appears to prohibit this option.

Any help gratefully received.

Mark