Great Article. I am currently trying to tackle the same issue. However, when I query the SQLite ODBC, it will not recognize any text fields...only Numeric. Ever encounter this problem?
I didn't notice any such issues. Text fields appeared to come back correctly.
It could be a version issue between the SQLite database and the ODBC driver? Or there are some options in the ODBC DSN Configuration that you might play with. I didn't change any of them for my database to work though.
5 comments:
Great Article. I am currently trying to tackle the same issue. However, when I query the SQLite ODBC, it will not recognize any text fields...only Numeric. Ever encounter this problem?
I didn't notice any such issues. Text fields appeared to come back correctly.
It could be a version issue between the SQLite database and the ODBC driver? Or there are some options in the ODBC DSN Configuration that you might play with. I didn't change any of them for my database to work though.
Very very helpful.. I had been scratching my head over this and this fixed my issue... Thanx a ton...
It was a very very useful post.. Thanks Dave... How do I contact you?
Thanks for sharing this wonderful thing SQL Lite Database Integration Service
Post a Comment