Cool, next time I ask MarkMail myself, promised ;) cheers, Jakob.
On Tue, Apr 27, 2010 at 16:26, Lee, David <[email protected]> wrote: > Here's an example: > > http://markmail.org/thread/b6f77j43ygyujrmk#query:MarkLogic%20HTTP%20Compression+page:1+mid:3nwq4uqzudhvhart+state:results > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Jakob Fix > Sent: Tuesday, April 27, 2010 10:22 AM > To: General Mark Logic Developer Discussion > Subject: Re: [MarkLogic Dev General] MarkLogic and > MSAccessdatabasecommunication > > 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 > _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
