ERROR [HY104] [Microsoft][ODBC Microsoft Access Driver]Invalid precision value

  • Thread starter Thread starter jwtulp
  • Start date Start date
J

jwtulp

Hello all,

I receive the following error when updating MSAccess2003 Memo fields
using an ODBC connection in ASP.Net 1.1 when the length of the text to
be updated exceeds 255 characters. Everything works fine when the
length of the text stays below 255 characters. Does anyone have a
clue?:

ERROR [HY104] [Microsoft][ODBC Microsoft Access Driver]Invalid
precision value

ConnectionString used:
PageTimeout=5;FIL=MS
Access;MaxBufferSize=2048;DSN=mydb;UID=admin;DBQ=C:\\Inetpub\\wwwroot\\mysite\\DB\\mydb;DriverId=25

Code with OdbcParameter:
this.PersonUpdateCommand.Parameters.Add(new
System.Data.Odbc.OdbcParameter("description",
System.Data.Odbc.OdbcType.NText, 2147483647, "description"));

The field in the MSAccess2003 database is called description, and is of
type Memo

Code used for updating:
PersonUpdateCommand.Parameters["description"] = new
OdbcParameter("description", person.Description);
PersonUpdateCommand.ExecuteNonQuery();
 
Back
Top