Using MsAccess with Perl on a UNIX system

L

linux

Hello,

I am trying to build a script that creates and fills an MsAccess
database (.mdb) in the right format on a UNIX-system (solaris).

The script needs to retrieve information from an existing MySQL
database and put it in an MsAccess database on the UNIX-platform, so
no connection can be made to a Windows machine. Later the will be FTP-
ed to a windows machine, which can only load the data. ODBC is not
possible.

The script is a perl script, but the solution to this prolbem, doesn't
necessarily need to be with Perl.

Does anyone have experience in how to solve this problem?

Best regards,
Gilian
 
L

Lambik

Hello,

I am trying to build a script that creates and fills an MsAccess
database (.mdb) in the right format on a UNIX-system (solaris).

The script needs to retrieve information from an existing MySQL
database and put it in an MsAccess database on the UNIX-platform, so
no connection can be made to a Windows machine. Later the will be FTP-
ed to a windows machine, which can only load the data. ODBC is not
possible.

The script is a perl script, but the solution to this prolbem, doesn't
necessarily need to be with Perl.

Does anyone have experience in how to solve this problem?


You are not the first one. There is the ODBC Socket Server
(http://odbcsock.sourceforge.net/) where you still need a MS OS or there is
the UniverSQL (http://www.sidespace.com/products/universql/) where you need
to pay for but has a trail version. Then there is the ODBC ODBC bridge from
http://www.easysoft.com/.

All are plasters, not real solutions. Real solution: export the db using a
mysql odbc from a windows machine into a mysql db.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,754
Messages
2,569,516
Members
44,983
Latest member
BuyX10BoostKeto

Latest Threads

Top