Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI
This Document is not yet Rated  Rate this Document

Updates Fail When Using the "ORDER BY" Keywords with the MS ODBC Single-Tier DLL Access Data Source

Primary Software: LabWindows/CVI Add-ons>>Enterprise Connectivity Toolset
Primary Software Version: 1.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem: When I specify the Access data source in the Microsoft ODBC Single-Tier DLL (SIMBA.DLL) and the DBActivateSQL() function uses the "ORDER BY" keywords, the following message is returned when I try to update a column value with DBPutRecord():

"You cannot change this column's value. The column's data type does not permit updating."

Solution: You should not use the "ORDER BY" keywords if you plan to update the table during run-time.

This appears to be a limitation of the Tier Driver itself. The error message will not appear when you use the Access datasource installed with the 32-bit MS ODBC Desktop Driver Pack 2.0 (ODBCJT32.DLL)

Related Links:

Attachments:





Report Date: 09/06/1995
Last Updated: 12/06/2004
Document ID: 0D59P6TL

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
  1 2 3 4 5
Please Contact NI for all product and support inquiries.submit