By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,384 Members | 845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,384 IT Pros & Developers. It's quick & easy.

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

P: n/a
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();

Jan 1 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.