CODEWITHSUNDEEP
c#.netodbc
powlette
powlette

Reputation: 1800

Mimic MS Access or SQL Server ODBC server from .NET

We want to allow access to our custom back end data store by pretending to be an ODBC server such as Access or SQL Server. In this way, anyone with those ODBC drivers could connect and send us queries (from anything from asp.net to Excel) which we will resolve on the back end and return a result set.

I have the ability to parse SQL and return result set based on a dynamic sql query. What I don't know is how to pretend to be an ODBC or OLEDB server. I don't even care which server we mimic as long as it's a common one that has drivers that ship with windows.

I have searched but could not find a basic implementation that implements authentication and ExecuteQuery() methods. Does such a .net project exist?

Upvotes: 2

Views: 393

Answers (2)

Robert Harvey
Robert Harvey

Reputation: 180777

The System.Data.Sqlite project is an excellent example of how to build an ADO.NET data provider for an arbitrary data store.

Upvotes: 1

John Gardner
John Gardner

Reputation: 25106

You could implement an ADO.NET data provider?

see http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx

Upvotes: 4

Related Questions