pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle, 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