Re: Access and Oracle

if you using Oracle ver 7 or up
Try to used Oracle object for OLE which come with documentation when you insall it.
The documentation have an examples event on how to connect or using with C++

however, I really fell that VB5 will be eassiy for for convert Oracle to Access by adding more function

Hope it help
good luck

Boon

Kinna Patel <kinna_at_qmark.co.uk> wrote in message 3587a10d.10585880_at_news.dial.pipex.com...
>I am currently looking into Oracle with the intention of converting
>our existing Access database into an Oracle one.
>
>I will be using ODBC to connect to the Oracle database and will then
>need to write my own C++ code to convert from Access to Oracle. This
>is because we need this functionality to be in a product we are
>producing. This means that we are unable to use any existing tools for
>this.
>
>My question is I need to be pointed in the right direction of where I
>can find information on an Oracle database ie what are the field
>types, what can/can't be used for field names, are there any
>constraints in the conversion (ie does an Oracle database support all
>the field types available in Access). Are there any limits to the size
>of a table/field?
>
>Any help would be appreciated on this.
Received on Sat Jun 27 1998 - 21:47:54 CDT