RE: [INTERFACES] Postgres (NT), ODBC and DBTools

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Cc: "'Tim(dot)Teulings(at)materna(dot)de'" <Tim(dot)Teulings(at)materna(dot)de>
Subject: RE: [INTERFACES] Postgres (NT), ODBC and DBTools
Date: 1999-11-03 15:21:07
Message-ID: 8568FC767B4AD311AC33006097BCD3D60142C9@woody.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> -----Original Message-----
> From: Teulings, Tim [mailto:Tim(dot)Teulings(at)materna(dot)de]
> Sent: 03 November 1999 14:34
> To: 'pgsql-interfaces(at)postgresql(dot)org'
> Subject: AW: [INTERFACES] Postgres (NT), ODBC and DBTools

<Snip>
>
> After looking at it again, I'm not sure if it is a problem with the
> colon. The "?" in the statement looks supicious (itis near the
> 'where'
> stated in the error message). AFAIK ODBC does allow binding of
> variables
> (bind variable, bound expresion) and DBTools uses this. Is the "?"
> legal
> at this point (it references the value bound to a variable) or is it
> a
> error?
>
> Perhaps it is a problem with the ODBC driver settings?

I am sure that the ? is the problem. I've never heard of binding variables
with ODBC, but then I'm not an ODBC expert - I tend to let ADO/DAO deal with
that side of things!

Perhaps Byron or someone else can provide a definate answer?

Regards,

Dave.

--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!

Browse pgsql-interfaces by date

  From Date Subject
Next Message stuart 1999-11-03 15:32:39 sequences
Previous Message Teulings, Tim 1999-11-03 14:33:56 AW: [INTERFACES] Postgres (NT), ODBC and DBTools