Re: Oracle and Access Integration

Hi,

I have recently started (in the last two months) integrating some oracle data sources into Access applications. (I have very little Oracle background, but have used Access for a few years) I'm using Intersolv's DataDirect ODBC drivers. Granted, they're not free, but they work fairly well. I tried Oracle's ODBC drivers first, but got frustrated trying to set them up correctly.

Actually I'm using Oracle 7.3 and Windows 95, but I expect your null date field problems are unrelated to that difference.

Are you using tables linked from Oracle, or pass through queries, or just importing data directly through ODBC?

Mike
MSchenk_at_LiquidSystems.com

Lane W. Sharman <lane_at_san.rr.com> wrote in article <34944023.DF28CCA_at_san.rr.com>...
> Hi,
>
> I have been developing in Oracle for a couple of years and Access for a
> year and am really impressed with the potential for integrating Access
> as a front-end to Oracle for RAD. In spite of my strong belief that Java
> will win the day - that day is still a >long< ways off when it comes to
> UI building.
>
> So. Here is my current technical glitch. It appears that MS Access
> chokes on an Oracle date field if the value is null. If this is a known
> bug, I'd sure like to know about it now because it tempers my enthusiasm
> somewhat and concerns me that maybe there are some other Access/ODBC
> issues relating to Oracle I need to consider.
>
> Environment:
> Oracle 8.0.3
> ODBC Driver: Oracle
> NT 4.0
>
> Thanks much in advance for any light on this subject.
>
> --
> Lane Sharman
> ...
> hypocrite lecteur, mon semblable, mon frere.
> -Charles Baudelaire
> Les Fleurs du mal
> Fleurs du Java:
> http://www.opendoors.com
>
>
>
  Received on Mon Dec 15 1997 - 00:00:00 CST