Re: SQLServer to Oracle Migration

Jody Tucker wrote:
>
> Hello Everyone:
>
> One of my co-consultants here at a client site is about to undertake a
> SQLServer to Oracle7 migration of a mid-sized application. The
> front-end is written in VB and will interface to other Oracle
> applications in multiple directions.

Hi Jody!
You have 2 choices. Use ODBC or the Oracle API (OCI, Oracle Call Interface).

One if more generic, but slower, since it is "an" implementation over the OCI layer.

The OCX/OCI on the other hand gives you direct OCI API programming control, total control, no guessing, but is for programmer building applications for Oracle only, it simply needs SQL*NET to be installed.

For the OCX/OCI check http://www.sfi-software.com about the SQL-Sombrero/OCX for OCI (Oracle Call Interface). Comes with a 32 bit and 16 bit OCX and VB4 samples.

See what an Oracle VP has to say about it at: http://www.sfi-software.com/doc/pressrelease/jan2996oracle.htm

or access the documentation at:
http://www.sfi-software.com/doc/ocxoci/doc/sqlocxoc.html

You can download it for your own testing by following the instructions at: http://www.sfi-software.com/doc/downloadrequest.htm

Or call Sylvain Faust Inc.(SFI) at 819 778-5045, fax 819 778-7943.

Hope this can help.
Sam Q. Lang
Sylvain Faust Inc.(SFI), Creator of SQL-Programmer(r) Oracle Alliance Partner
Sybase Synergy Partner
Microsoft Solution Provider Received on Thu Jun 20 1996 - 00:00:00 CEST