[ic] ic msaccess and dbmaker
marco
m.mescoli at omnib.it
Fri Jul 9 07:59:13 UTC 2010
Perl beginner, an hand to make the best choice :-)
I need to read data from msaccess and dbmaker and let be avaliable at
the request to interchange, max 20 times a day.
I think the best way to get not large amount of data few times a day is
to put it into mysql db at the request only when is needed.
1) msaccess: one table, about 2 MB of data:the idea is put the mdb file
in smb sharing, read data with DBI (ic tag, possible ?), put only new
record to mysql, process them as need with ic pages.
2) dbmaker: two table, max 20 MB of data: the source database is a
remote (lan) host
I cannot understand what way can i take:
a) from dbmaker.com jdbc driver (java ??).
b) from dbmaker.com
ftp://www.dbmaker.com/pub/DBMaker/driver/Perl/DBD/0.15/DBD-DBMaker-0.15.tar.gz
(550 Failed to change directory: wrong url ?)
d) from cpan:
http://search.cpan.org/~dbmaker/DBD-DBMaker-0.13/DBMaker.pm (ok for
remote lan host ?)
c) from cpan: http://search.cpan.org/~vizdom/DBD-JDBC-0.71/JDBC.pod ? (
seems complicated )
e) UNIXODBC ?
f) IODBC ?
g) smb sharing of the dbmaker files and d) ?
Thanks
--
Marco "Fino alla bara sinpara"
Marco "Up to demise we rise"
More information about the interchange-users
mailing list