pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Oracle, ODBC, MS IIS -> problem!
2+ messages / 2 participants
[nested] [flat]

* Oracle, ODBC, MS IIS -> problem!
@ 2000-11-08 14:50 ANDREAS STEINBACH <ANDREAS.STEINBACH@INF.OEBB.AT>
  2000-11-09 16:25 ` Re: Oracle, ODBC, MS IIS -> problem! Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 2+ messages in thread

From: ANDREAS STEINBACH @ 2000-11-08 14:50 UTC (permalink / raw)
  To: pgsql-sql

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)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Oracle, ODBC, MS IIS -> problem!
  2000-11-08 14:50 Oracle, ODBC, MS IIS -> problem! ANDREAS STEINBACH <ANDREAS.STEINBACH@INF.OEBB.AT>
@ 2000-11-09 16:25 ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2000-11-09 16:25 UTC (permalink / raw)
  To: ANDREAS STEINBACH (Tel 31128) <ANDREAS.STEINBACH@INF.OEBB.AT>; +Cc: pgsql-sql

Mr. Steinbach,

> 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).
<snip>

	You seem to have joined/posted to our mailing list in error.  This is a
PostgreSQL SQL-developers mailing list.  If you need help with Oracle, I
suggest proceeding to www.oracle.com and looking for appropriate forums;
I'm sure there are many.

					-Josh Berkus

-- 
______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology      josh@agliodbs.com
    and data management solutions       (415) 436-9166
   for law firms, small businesses       fax  436-0137
    and non-profit organizations.       pager 338-4078
                        		San Francisco



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-11-09 16:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-08 14:50 Oracle, ODBC, MS IIS -> problem! ANDREAS STEINBACH <ANDREAS.STEINBACH@INF.OEBB.AT>
2000-11-09 16:25 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox