Hi Jakob, I meant accessing MarkLogic Server through an HTTP App Server, addressing some mycustom.xqy which returns whatever you like (perhaps based on some request params) in zipped format using xdmp:zip (and related functions).
It is zip format though, not gzip.. Kind regards, Geert > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > Jakob Fix > Sent: dinsdag 27 april 2010 16:22 > To: General Mark Logic Developer Discussion > Subject: Re: [MarkLogic Dev General] MarkLogic and MS > Accessdatabasecommunication > > Geert, by custom query do you mean the use of gzip > compression over the wire? > > cheers, > Jakob. > > > > On Tue, Apr 27, 2010 at 16:15, Geert Josten > <[email protected]> wrote: > > Hi Jacob, > > > > It might be more tricky to parse from Access side, but it > is not difficult to compress the returned data with a custom > xquery from MarkLogic Server side. That could significantly > decrease the total number of bytes sent across (and could > also serve as some security as well).. > > > > Kind regards, > > Geert > > > >> -----Original Message----- > >> From: [email protected] > >> [mailto:[email protected]] On Behalf > Of Jakob > >> Fix > >> Sent: dinsdag 27 april 2010 16:11 > >> To: General Mark Logic Developer Discussion > >> Subject: Re: [MarkLogic Dev General] MarkLogic and MS > >> Accessdatabasecommunication > >> > >> Thanks Geert, > >> > >> that sounds like a feasible solution. We just might to have to run > >> some tests to see whether this is appropriate for the transfer of > >> large amounts of data. > >> > >> cheers, > >> Jakob. > >> > >> > >> > >> On Tue, Apr 27, 2010 at 15:37, Geert Josten > >> <[email protected]> wrote: > >> > Hi Jacob, > >> > > >> > It might be more straight forward to just access MarkLogic > >> through HTTP. If I'm not mistaken it shouldn't be > difficult to plug > >> an HTTP Client into your Access code. You might also be > able to use > >> MSXML library to parse XML output to extract what you > need. If not, > >> you could have MarkLogic return data as comma-separated (with a > >> custom xquery) and do some string parsing from Access side.. > >> > > >> > Kind regards, > >> > Geert > >> > > >> >> > >> > > >> > > >> > drs. G.P.H. (Geert) Josten > >> > Consultant > >> > > >> > > >> > Daidalos BV > >> > Hoekeindsehof 1-4 > >> > 2665 JZ Bleiswijk > >> > > >> > T +31 (0)10 850 1200 > >> > F +31 (0)10 850 1199 > >> > > >> > mailto:[email protected] > >> > http://www.daidalos.nl/ > >> > > >> > KvK 27164984 > >> > > >> > P Please consider the environment before printing this mail. > >> > De informatie - verzonden in of met dit e-mailbericht - is > >> afkomstig van Daidalos BV en is uitsluitend bestemd voor de > >> geadresseerde. Indien u dit bericht onbedoeld hebt ontvangen, > >> verzoeken wij u het te verwijderen. Aan dit bericht kunnen geen > >> rechten worden ontleend. > >> > > >> >> From: [email protected] > >> >> [mailto:[email protected]] On > Behalf Of Lee, > >> >> David > >> >> Sent: dinsdag 27 april 2010 15:27 > >> >> To: General Mark Logic Developer Discussion > >> >> Subject: RE: [MarkLogic Dev General] MarkLogic and MS Access > >> >> databasecommunication > >> >> > >> >> 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 > >> >> > >> > _______________________________________________ > >> > 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 > _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
