RE: need help with errors in ODBC log

> -----Original Message-----
> From: Carolyn Lu Wong [mailto:carolyn(at)greatpacific(dot)com(dot)au]
> Sent: 07 November 2000 04:03
> To: pgsql-interfaces(at)postgresql(dot)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.