Hallo,
we connect to a MS SQL server using this connectionstring:
"sdbc:ado:Provider=SQLOLEDB.1;Persist Security Info=True;Initial
Catalog=DobbitMulti;Data Source=000.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 = "INSERT INTO DobbitMulti.pmgMiuCode(basis, nummer ,taal)
VALUES(?,?,?)"
oInsStmt = 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: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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 deleted