OLE DB network suggestions
-
Hi all, I'm embarking on a fairly complex project (I know. Please don't say simply "Google for it". I already did). What I want is to implement an OLE DB layer between a physical DB (connection via standard OLE DB interface) and a client application. The aim is to implement row level security and additional functions (such as logging) in the OLE DB layer. So the architecture should be like this (top-down):
Client Application <- Ole DB consumer application (MFC, .NET, Excel...) ----------------------- OLE DB Provider <- On the client. Dumb connection to my service via the Network layer ----------------------- Network layer <- I really don't know how to pass through this ----------------------- OLE DB Consumer/Provider service <- This should be on a network server. Here I'm implementing row level security. This service acts as an OLE DB consumer for the DB and exposes data to the client. ----------------------- Physical DB <- Any OLE DB-compliant database (mainly SQL Server or Oracle) -----------------------My question is: what is the best way to implement the Network layer? I found an OLE DB Remoting Provider by Microsoft, but seems outdated and not supported ATM. If using this, I should implement OLE DB Provider interfaces into the Service on the server. Any suggestions? (cross posted on the COM forum)