From: Carolyn Lu Wong <carolyn@greatpacific.com.au>
To: Dave Page <dpage@vale-housing.co.uk>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: need help with errors in ODBC log
Date: Wed, 08 Nov 2000 09:22:19 +1100
Message-ID: <3A08809B.6C78778C@greatpacific.com.au> (raw)
References: <8568FC767B4AD311AC33006097BCD3D61A2719@woody.vale-housing.co.uk>
Dave Page wrote:
>
> > -----Original Message-----
> > From: Carolyn Lu Wong [mailto:carolyn@greatpacific.com.au]
> > Sent: 07 November 2000 04:03
> > To: pgsql-interfaces@postgresql.org
> > Subject: [INTERFACES] need help with errors in ODBC log
> >
> >
> > This problem is regarding VB5 application connection to postgreSQL
> > V6.5 via PsqlODBC V6.5. I'm not sure if the problem is related to ODBC
> > or the database. Please let me know if I should direct the question to
> > another discussion group.
> >
> > When I try to open a record set from VB with a simple select
> > statement, results are retrieved if I connect to database on a local
> > server. However, if I try to retrieve data from remote server (via
> > internet) with the same code, I get the following error: '3669:
> > Execution Cancelled' (source - DAO.Connection).
> >
> > The statement I try to open the record set with is 'select * from
> > accounts where account_no = 3;' I have included extractions from the
> > ODBC log files for both cases. The only difference I can see is in the
> > case where error arises, it has additional 'select * from select *
> > from....' in the log. I don't know where the 'select *' that comes
> > before the select statement comes from.
> >
>
> The additional 'SELECT * FROM' is probably caused by having the command type
> set to table rather than text in the data control. This causes the control
> to assume that the recordsource is a tablename so it sticks SELECT * FROM in
> front of it to create a complete query.
>
> HTH,
> Regards, Dave.
The thing is, when I run the same application accessing database from
the local server (LAN), I don't have the VB 3669 error, and the
additional 'Select * from' does not exist in the log file. However, if
i'm accessing database from remote server (WAN), it causes the VB
error and there's additional 'select * from' in the log file! Apart
from the differences in the data, both database table definitions are
identical.
FYI, the source of the recordset in VB is SQL statement.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: carolyn@greatpacific.com.au, dpage@vale-housing.co.uk
Subject: Re: need help with errors in ODBC log
In-Reply-To: <3A08809B.6C78778C@greatpacific.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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