Hi everyone,

I am trying to create an ODBC interface to a sensor network, which is modelled as a database (using TinyDB, see http://telegraph.cs.berkeley.edu/tinydb/). At the moment SQL queries can be sent through a socket, with results returned back through the socket.

Although there are some differences from standard SQL, I believe that it should be possible to create an ODBC interface to the "database". Do I only need to create an ODBC driver for the "database" or is more work required.

And can anyone give me any help on how to create an ODBC driver. I have searched on the Internet, but havent found much relevant information. I would be grateful for any help anyone could dish out to me (or point me in the direction of a suitable web page).

Thanks for your help,
Adam.

You might want to take a look at http://www.unixodbc.org/ & http://sourceforge.net/cvs/?group_id=1544 for inspiration.