[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