Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 2 of 2 total |
ODBC ver 3 error in VS 2008 |
Tue, Aug 10 2010 10:28 AM | Permanent Link |
jframe | I'm trying to execute an update statement via the odbc driver for a blob record in DBISAM v 3, but I'm getting a error:
cmd = New OdbcCommand("UPDATE LOCAT SET CONGRESS = :Congress WHERE WSN = 1", conn) Dim P As OdbcParameter = New OdbcParameter(":Congress", OdbcType.VarBinary, bTest.Length, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, bTest) cmd.Parameters.Add(P) cmd.ExecuteNonQuery() System.Data.Odbc.OdbcException was unhandled ErrorCode=-2146232009 Message="ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11949 SQL error - Unknown or unexpected symbol ':' found in value expression" Any suggestions? |
Tue, Aug 10 2010 4:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << I'm trying to execute an update statement via the odbc driver for a blob
record in DBISAM v 3, but I'm getting a error: cmd = New OdbcCommand("UPDATE LOCAT SET CONGRESS = :Congress WHERE WSN = 1", conn) Dim P As OdbcParameter = New OdbcParameter(":Congress", OdbcType.VarBinary, bTest.Length, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, bTest) cmd.Parameters.Add(P) cmd.ExecuteNonQuery() System.Data.Odbc.OdbcException was unhandled ErrorCode=-2146232009 Message="ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11949 SQL error - Unknown or unexpected symbol ':' found in value expression" >> You need to use ? for parameters with ODBC. The ODBC.NET data provider does not support named parameters in the form of :Param. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, April 22, 2024 at 04:13 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |