Read up on MSDN documentation on System.Data.Odbc.OdbcCommand property
CommandText
The Odbc provider uses question mark placeholders. It does not support
named parameters. You have to use a SQL statement like:
SELECT * FROM SOME_TABLE WHERE SOME_ID = ?
In your parameters, it is positional,
(@PKey, cPKey);
oCommand.ExecuteNonQuery()
Sébas
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Daniel
Morgan
Sent: August 17, 2005 8:13 AM
To: [EMAIL PROTECTED]
Cc: mono-devel-list@lists.ximian.com
Subject: Re: [Mono-dev] URGENT: Odbc-Exception-Error
Read up
PROTECTED]
Gesendet: Mittwoch, 17. August 2005 17:11
An: [EMAIL PROTECTED]
Cc: mono-devel-list@lists.ximian.com
Betreff: RE: [Mono-dev] URGENT: Odbc-Exception-Error
Jan,
I am using the ODBC .NET Provider to access a Sybase database.
On Linux, I am using unixODBC and freeTDS.
And yes, it works