Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!feed2.news.rcn.net!rcn!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: kielhd@freenet.de (kielhd)
Newsgroups: comp.databases.oracle.server
Subject: Error when accessing a DB-view via MS-Access / ODBC
Date: 5 Jun 2003 23:32:40 -0700
Organization: http://groups.google.com/
Lines: 54
Message-ID: <10a4173d.0306052232.3908bf72@posting.google.com>
NNTP-Posting-Host: 217.5.231.244
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1054881160 1537 127.0.0.1 (6 Jun 2003 06:32:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2003 06:32:40 GMT
Xref: core-easynews comp.databases.oracle.server:188816
X-Received-Date: Thu, 05 Jun 2003 23:35:49 MST (news.easynews.com)

Environment on the Client:
MS Access 2000
Oracle ODBC Driver 8.01.07.00

Environment on the Server:
Oracle Release 8.1.7.0.0

Problem:
I am accessing a DB-view via MS-Access using a ODBC driver. The access
was ok until I made a change to the view. Before the error occured,
the view was looking like this:

 1  create view IMD_HARDWARE
 2  as
 3  select  CSM_COMPSYSID_CSMSERVID.CSM_SERVICE_ID,
 4          COMPUTER.COMPUTER_MODEL,
 5          COMPUTER.SYS_SER_NUM,
 6          COMPUTER.OS_INST_DATE,
 7          COMPUTER_SYS_MEM.PHYSICAL_TOTAL_KB,
 8          PROCESSOR.PROCESSOR_MODEL,
 9          PROCESSOR.MAX_SPEED,
10          INST_PROCESSOR.PROCESSOR_NUM,
11          COMPUTER.OS_NAME,
12          COMPUTER.OS_MAJOR_VERS,
13          COMPUTER.OS_MINOR_VERS,
14          COMPUTER.OS_SUB_VERS
15  from    COMPUTER,
16          PROCESSOR,
17          INST_PROCESSOR,
18          COMPUTER_SYS_MEM,
19          CSM_COMPSYSID_CSMSERVID
20  where   CSM_COMPSYSID_CSMSERVID.COMPUTER_SYS_ID =
COMPUTER.COMPUTER_SYS_ID and
21          COMPUTER_SYS_MEM.COMPUTER_SYS_ID =
COMPUTER.COMPUTER_SYS_ID and
22          INST_PROCESSOR.COMPUTER_SYS_ID = COMPUTER.COMPUTER_SYS_ID
and
23          INST_PROCESSOR.PROCESSOR_ID = PROCESSOR.PROCESSOR_ID;

To have the date displayed in a different format, I changed line 6 to 

 6          to_char(to_date(COMPUTER.OS_INST_DATE, 'DY MON DD
HH24:MI:SS YYYY'), 'DD.MM.YYYY') OS_INST_DATE,

and the following error occured:

ODBC Call failed
[Oracle][ODBC][Ora]ORA-01846: not a valid day of the week (#1846).

As I need to access this view via ODBC, I am looking forward for any
hints.

Best regards
Henning