- Joined
- Jan 8, 2016
- Messages
- 1
- Reaction score
- 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
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