On 12 Jan 2011, at 16:58, Christian Brenninkmeijer wrote:
> 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.
In what way does it fail? Any exception or error message?
Best,
Richard
>
> 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
------------------------------------------------------------------------------
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
