Re: ODBC Connection To Oracle

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bill Mills (anonymous_at_discussions.microsoft.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 14:03:56 -0700

There are no conditions in WHERE. I did have some
conditions but it wasn't working so I went back to the
basics to see if I could get any data with the simple
Select from statement and couldn't get anything there
either.

>-----Original Message-----
>Does your SELECT statement have a WHERE clause that
places any conditions on
>text fields? Unlike in Access, text comparison in Oracle
(even on Oracle
>tables linked into Access) is case-sensitive.
>
>For example, if your SELECT statement is something like:
>
>SELECT
>YOUR_LINKED_TABLE.*
>FROM
>YOUR_LINKED_TABLE
>WHERE
>YOUR_LINKED_TABLE.YOUR_TEXT_FIELD = "abc"
>
>it would return records where YOUR_TEXT_FIELD
equalled "abc", but not those
>where it equalled "ABC".
>
>"Bill Mills" <Bill.Mills@wadnr.gov> wrote in message
>news:1d4bb01c453bf$69199640$a101280a@phx.gbl...
>> I currently have an ODBC connection to Oracle and have
>> linked tables to an Oracle database table. The form
uses
>> a Select statement query to pull information from the
>> table but is not showing any data nor are there any text
>> boxes displayed on the form. Any ideas why and what am
I
>> missing? Has anybody connected to oracle through linked
>> tables in Access.
>
>
>.
>

Relevant Pages

  • ODBC setup
    ... I'm trying to setup linked tables through ODBC connection to an Oracle ... I checked my tnsnames entry and used the correct server name, ... tnsnames entry for that particular database, but it is in the format: ...
    (microsoft.public.access.modulesdaovba)
  • mapping cells within same excel sheet
    ... My problem is..I am trying to load a oracle view in the sheet by ... running a database query thru ODBC connection. ...
    (microsoft.public.excel.misc)
  • ODBC Connection To Oracle
    ... I currently have an ODBC connection to Oracle and have ... a Select statement query to pull information from the ...
    (microsoft.public.access.externaldata)
  • ODBC connection to Oracle shows handle count leak
    ... The problem is within Oracle client. ... ODBC connection to Oracle shows handle count leak ... In addition to Microsoft ODBC for Oracle, ...
    (microsoft.public.data.odbc)
  • Re: ODBC Connection
    ... I think Scott might be referring to something I've wished many times, ... 95% of my Access work has to do with Oracle. ... As far as "simulating" an ODBC connection in this context - I don't know ...
    (microsoft.public.access.gettingstarted)