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
