That seems like you'd need an ODBC to MarkLogic adaptor. I don't have an answer for that, sorry. Maybe one exists, but my suspicion (and quick googling) suggest it doesn't.
Can your Access apps be converted to use .NET or COM to access the DB ? It might be easier to write a .NET or COM adaptor specific to application needs then ODBC. MarkLogic supports direct connections with .NET, or you could write a DCOM service. I think writing an ODBC connector would be very difficult. -David ---------------------------------------- David A. Lee Senior Principal Software Engineer Epocrates, Inc. [email protected] 812-482-5224 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jakob Fix Sent: Tuesday, April 27, 2010 9:04 AM To: General Mark Logic Developer Discussion Subject: Re: [MarkLogic Dev General] MarkLogic and MS Access databasecommunication Hi David, thanks for your answer and sorry for not being more precise. Our problem is that our Access databases connect to our "master" SQL Server database via ODBC for read-only access. Once our "master" database migrated to MarkLogic, how can we connect the Access databases to the MarkLogic database, again for read-only access of the data? So, to answer your question, your first scenario corresponds to our problem. cheers, Jakob. On Tue, Apr 27, 2010 at 14:40, Lee, David <[email protected]> wrote: > Could you describe the issue in more detail ? > What I'm confused about is this > > "The SQL database of today has a large number of Access databases > accessing it via ODBC to retrieve" > > So are you saying you have *code* in an Access Database (client) that > currently accesses your SQLServer (DB / server) and you want that *code* > (in access) to start accessing the data in MarkLogic from within Access > ? > > Or do you want code in MarkLogic to access data from an Access database > ? > > -David > > ---------------------------------------- > David A. Lee > Senior Principal Software Engineer > Epocrates, Inc. > [email protected] > 812-482-5224 > > > > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Jakob Fix > Sent: Tuesday, April 27, 2010 3:06 AM > To: General Mark Logic Developer Discussion > Subject: [MarkLogic Dev General] MarkLogic and MS Access > databasecommunication > > Hi everybody, > > how would one go about connecting an Access database to a MarkLogic > database for the purpose of retrieving information (read-only, no > insertion nor updates)? Is this feasible, a crazy idea, or actually > trivial? > > The background behind this question is this: We currently plan the > move of an MS SQL Server database to MarkLogic. (Of course, this means > that the data model will change considerably, from row-based data to a > hierarchical structure.) The SQL database of today has a large number > of Access databases accessing it via ODBC to retrieve data for > specialized purposes. We need to continue to provide some kind of > access to these MS Access databases. > > Thanks in advance for your help! > > cheers, > Jakob. > _______________________________________________ > General mailing list > [email protected] > http://xqzone.com/mailman/listinfo/general > _______________________________________________ > General mailing list > [email protected] > http://xqzone.com/mailman/listinfo/general > _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
