Re: MSAccess97(NT4SP3)-->ODBC-->Oracle7(Unix) Problem

In article <63u1lg$jqt_at_no-names.nerdc.ufl.edu>, john_at_hpe.ufl.edu says...
> Hi Jim.
>
> Ready for this?
>
> When you export stuff from Access, make sure that the table and column names
> are in UPPERCASE. Otherwise, Oracle won't be able to read them unless you
> put the table and/or column names in quotes (single, I think). I suppose
> quotes are still an option, but it's impractical in the long run. I'd put
> all the Access table and field names in uppercase and re-export. And
> remember, this won't make a difference to Access, because it ignores case.
>
> Convenient, eh?
>
> Note that Oracle stores tables and columns created with its own tools (such
> as SQL*Plus) in uppercase.
>
> Annoying, huh?
>
>
> I pulled out much hair over this, until a colleague pointed it out.
> Best of luck!
>
> -John Hopkins
> Programmer/Analyst
> Bone Marrow Transplant Unit
> Shands Hospital
> Gainesville, FL
>
> -----Original Message-----
> From: Jim Garrison <jhg_at_austx.tandem.com>
> Newsgroups:
> comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracl
> e.tools
> Date: Tuesday, November 04, 1997 1:14 PM
> Subject: MSAccess97(NT4SP3)-->ODBC-->Oracle7(Unix) Problem
>
> >I have just installed the current version of Personal
> >Oracle on my NT workstation, and successfully set up
> >an ODBC connection to an Oracle7 database running
> >on Unix (Solaris). The connection works, and I can
> >link from Access to tables on the Oracle DB with no
> >problem.
> >
> >Then I "exported" an Access table to Oracle
> >(File:SaveAs/Export:External Database:ODBC). The
> >export was successful, and I was then able to link
> >from Access to the newly created Oracle table, and
> >am able to view and manipulate the Oracle rows from
> >within Access.
> >

This is not standard behavior for all ODBC Drivers, OpenLink Software provides High-Performance ODBC Drivers for Oracle that do not have this problem at all.

These Drivers are available in 2 formats :

Lite - Drivers Requires SQL*Net for remote Oracle DB Access Mutli Tier - Drivers do not Require SQL*Net for remote DB Access

• These Drivers also handling the type mapping between Oracle & Access correctly ***

You can download these drivers from : http://www.openlinksw.com on a free non expiring basis.

Regards,
Product Marketing
OpenLink Software Received on Thu Nov 06 1997 - 00:00:00 CST