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
