Skip site navigation (1) Skip section navigation (2)

OdbcCommand Parameter

From: "Luca Beretta" <luca(dot)beretta(at)dataelco(dot)it>
To: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: OdbcCommand Parameter
Date: 2004-09-22 07:31:05
Message-ID: 20040922073547.CEA09329D18@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
hi to all,
i'm using C# to write an application based on postgresql 8.0 beta 2 (win32),
and i'm experiencing a problem using .NET Framework OdbcCommand class:
i need to pass some OdbcParameter, but i don't know how kind of name i need
to use for pgsql SQL sentence; with MS SQL Server i call them @param1
@param2, ecc

but if i do this with pgsql odbc 7.05.00.02 i get this error

[OdbcException: ERROR [HY000] ERROR:  operator does not exist: @@ character
varying]

i think it depends by parameters names, so tried @@param,$param,%param but i
get always
the same exception.

which is the right mode ?
 
thanks a lot

Responses

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2004-09-22 11:57:16
Subject: "Operation on non-socket" analysis
Previous:From: Kevin WoolleyDate: 2004-09-21 14:31:53
Subject: Re: XP install problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group