PreparedStatement not working with ADO

Hallo,
we connect to a MS SQL server using this connectionstring:
"sdbc:ado:Provider=3DSQLOLEDB.1;Persist Security Info=3DTrue;Initial =

Catalog=3DDobbitMulti;Data Source=3D000.000.000.000"
  as URL for a  "com.sun.star.sdbc.DriverManager"
as return we optain a  "com.sun.star.sdbcx.AConnection"

who permit us to make normal statements to MS SQL tables.

but a simple "prepared statement" like:

insertSQL =3D "INSERT INTO DobbitMulti.pmgMiuCode(basis, nummer ,taal) =

VALUES(?,?,?)"
             oInsStmt =3D oLCPConn.PrepareStatement(insertSQL)
             oINsStmt.SetString( 1, smiubasis)
             oINsStmt.SetString( 2, smiutomake)
             oINsStmt.SetString( 3, staal)
             oINsStmt.executeUpdate()

return a error:

BASIC runtime error.
An exception occurred
Type: com.sun.star.sdbc.SQLException
Message: Incorrect syntax near ':'..

A bug or ????

Thanks for any hints

Greetz

Fernand


-- =

To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr=
ibe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be dele=
ted