I have had some success runig d2r Map generator and d2r Server directly
over access.
See (Generate Mapping (limited) over ODBC) and (DatabaseSchemaInspector
Quessing the PrimaryKey) both posted today for code changes required.
Then use the jbdc string like "jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=c:/temp/RIVPACS.mdb";
Strangly enough it works when I run the code from within Netbeans but
fails if I run it from the comman line (all vaules hard coded in so no
typos there.)
Let me know if you can think why!
Tested with Access 97 database.
I had to manulay remove some special symbols from the column names
including "?" greek letters and the degree sign.
On 09/01/2011 12:48, Christian Brenninkmeijer wrote:
> Hi,
>
> I have a number of MSAccess files and would love to run GenerateMapping
> directly over them.
>
> Up until now the solution has been to dump the database to MYSQL and run
> it over that using JDBC.
>
> I intended to adapt GenerateMapping to run directly over an ODBC
> connection to MSAccess.
>
> This will cause a problem as functions like getPrimaryKeys are not
> supported.
>
> Before I write my Hack the question to the group is has anyone else
> already done that?
> If so can I have you solution?
>
> If not I will have a go and let you guys know how far I got.
>
--
Dr Christian Brenninkmeijer
Department of Computer Science
University of Manchester
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
