My bad, I was scanning the emails and misunderstood the question. You are correct in that MLSQL is intended for querying a SQL database from within marklogic.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jakob Fix Sent: Tuesday, April 27, 2010 11:51 AM To: General Mark Logic Developer Discussion Subject: Re: [MarkLogic Dev General] MarkLogic and MS Access database communication Hi Mark, reading through the tutorial, it seems that it's possible to emit SQL statements from MarkLogic using MLSQL, but not the other way around, i.e. MarkLogic receiving SQL statements from a third party application and returning results (in XML or any other format). Please correct me if I misunderstood. I'd love to avoid reinventing any existing wheels. cheers, Jakob. On Tue, Apr 27, 2010 at 17:20, Mark Helmstetter <[email protected]> wrote: > Another option might be to use MLSQL: > http://developer.marklogic.com/howto/tutorials/2006-04-mlsql.xqy. > > MLSQL uses JDBC. There is a JDBC-ODBC bridge driver that ships with the JDK > that you could use. > > -----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 database > communication > > 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
