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
