Skip to content

Instantly share code, notes, and snippets.

@NPS-ARCN-CAKN

NPS-ARCN-CAKN/ODBC_SqlServerTimeFieldError

Last active April 22, 2016 16:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save NPS-ARCN-CAKN/287465a658248759da7a747a72af17f1 to your computer and use it in GitHub Desktop.
Save NPS-ARCN-CAKN/287465a658248759da7a747a72af17f1 to your computer and use it in GitHub Desktop.
Download ZIP
TIME field in SQL Server Table causes ODBC Error in Microsoft Access: ODBC --update on a linked table failed Invalid character value for cast specification
Raw
ODBC_SqlServerTimeFieldError
I have a Sql Server 2008R2 database with a table with a TIME field in it. I have a Microsoft Access front end with ODBC linked tables. When I try to add or update a database record using a textfield that is bound to the TIME field I got an error: ODBC --update on a linked table failed Invalid character value for cast specification. After tinkering a bit I changed the text field's Input mask property to 'input mask to 00:00:00;0;_' which solved the problem.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment