Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eA96P5s95811 for ; Thu, 9 Nov 2000 01:25:05 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from relay2.austria.eu.net (endjinn.austria.eu.net [193.81.13.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA8EqLs97907 for ; Wed, 8 Nov 2000 09:52:22 -0500 (EST) (envelope-from ANDREAS.STEINBACH@INF.OEBB.AT) Received: from fire1a (fire1a.oebb.at [193.81.167.3]) by relay2.austria.eu.net (8.11.1/8.11.1) with SMTP id eA8Epk901430 for ; Wed, 8 Nov 2000 15:51:47 +0100 (MET) Received: by gw003.rlo.tk.oebb.at (8.8.8/1.1.22.3/15Jun00-1025AM) id PAA0000028056; Wed, 8 Nov 2000 15:51:05 +0100 (MET) X400-Received: by mta "Z.GW003" in /PRMD=RAIL/ADMD=ADA/C=AT/; Relayed ; 8 Nov 2000 14:51:04 +0000 X400-Received: by mta "Z.MHSW" in /PRMD=RAIL/ADMD=ADA/C=AT/; Relayed ; 8 Nov 2000 14:50:30 +0000 Date: 8 Nov 2000 14:50:30 +0000 X400-Originator: ANDREAS.STEINBACH@INF.OEBB.AT X400-Recipients: pgsql-sql@postgresql.org (Physical Forwarding Address Requested) X400-MTS-Identifier: [/PRMD=RAIL/ADMD=ADA/C=AT/;DD4C90F311D4B58E484D06BD] Discarded-X400-MTS-Extensions: (43) (12) (2) (135) (115) (5) (6) (3) From: "ANDREAS STEINBACH" (Tel 31128) To: pgsql-sql@postgresql.org (Non Receipt Notification Requested) (IPM Return Requested) Subject: Oracle, ODBC, MS IIS -> problem! Importance: normal Sensitivity: Company-Confidential Autoforwarded: FALSE Message-Id: Original-Encoded-Information-Types: (1) (0) (10021) (7) (1) (0) (6), (1) (0) (10021) (7) (1) (0) (1) X400-Content-Identifier: E170ISM3EC5B X400-Content-Type: P2-1988 (22) X-Archive-Number: 200011/62 X-Sequence-Number: 93 Hi, My problem is: I have to create a web interface for an Oracle database. I use MS Internet Information Server, ODBC driver (tried one from MS and one from Oracle) and an Oracle database (I have no permission to change anything in that database). I don't have a problem accessing one table, but I need to read fields of several tables and some of them have the same name. I simplified my problem to the following example: select p.pkey, p.text, d.dkey, d.text from schema1.product p, schema1.details d where p.pkey = 15555 I created a webpage containing the following: ---------- <% Set cn = Server.CreateObject("ADODB.Connection") cn.open "dsn=XXXXXXX;uid=XXXXXXX;pwd=XXXXXXX" abfrage="select p.pkey, p.text, d.dkey, d.text from schema1.product p, schema1.details d where p.pkey = 15555" Set rs = cn.Execute(abrage) %> <% m_produkt=Server.HTMLEncode(rs.Fields("p.pkey").Value)%> --------- The last line give a (german) error message that I will try to translate: ADODB.Fields-error '800a0cc1' ADO couldn't find an object in the list, that corresponds to the name or the ordinal reference, that was requested by the application. Is there anybody out there who can be of help on that matter? I really tried to find an answer myself, but now I'm stuck. Any help is highly appreciated. Thanks in advance, Andreas (Vienna, Austria, Europe, Earth)