how do i declare a parameter for a ODBC provider


for instance i have the following for a update statement


UPDATE [Table1] SET [Col1]=@p1, [Col2]=@p2 WHERE [Col3]=@p3


however when i try and run the code i get an error about declaring @p1. so how exactly do i set up parameters for ODBC do i just use a question mark or what? is it data provider specific meaning do i have to use something different it the ODBC is for MSSQL compared to that of say Oracle or MySQL.

Thanks in advance