ERROR [42000] [Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only.

Discussion in 'Drivers' started by Satya Senapati, Jan 8, 2016.

  1. Satya Senapati

    Satya Senapati

    Joined:
    Jan 8, 2016
    Messages:
    1
    Likes Received:
    0
    When I tried to setup an ODBC data source to a text file the connection and read the file perfectly.
    when tried to set up an ODBC data source other then text file (Eg. *.p05), I am reciving an error that says, ‘ERROR [42000] [Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only.’.
    I read some where this is a security feature of the Microsoft Jet ODBC Text driver. The ODBC driver only allows you to read files with the following extensions txt, csv, tab, asc, htm, html.
    My question is: How can I configure the ODBC where it can read other then above mentioned extension file (Eg. *.p05) .
    Quick reply is appreciable.
    Thanks,
    Satya
     
    Satya Senapati, Jan 8, 2016
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Robert Elliott

    SOLVED Word automatically goes 'read only'

    Robert Elliott, Feb 17, 2010, in forum: Windows 7 Support
    Replies:
    8
    Views:
    5,845
    Robert Elliott
    Feb 18, 2010
  2. bugmenot

    Read only protection / Standard editor

    bugmenot, Oct 16, 2010, in forum: Windows 7 Support
    Replies:
    2
    Views:
    1,774
    davehc
    Oct 16, 2010
  3. Mark Blain

    Read-only files.

    Mark Blain, May 10, 2011, in forum: alt.windows7.general
    Replies:
    9
    Views:
    1,393
    Mark Blain
    May 12, 2011
  4. Multex
    Replies:
    45
    Views:
    18,746
    TrainableMan
    Nov 11, 2013
  5. delar
    Replies:
    0
    Views:
    1,644
    delar
    Apr 25, 2012
  6. delar
    Replies:
    4
    Views:
    2,912
    Dave-UK
    Apr 26, 2012
  7. Mr. Walnuts

    Hardware AND Software Driver Database?

    Mr. Walnuts, Mar 8, 2014, in forum: Crashes, BSODs and Debugging
    Replies:
    4
    Views:
    874
    Shintaro
    Mar 10, 2014
  8. marcosdipaolo

    Cannot update framework nor MSE due to error 0x80070643 or 643

    marcosdipaolo, May 18, 2015, in forum: Installation, Setup and Updates
    Replies:
    1
    Views:
    1,305
    marcosdipaolo
    May 18, 2015
Loading...