Re: [cobalt-users] MS Access ODBC

["E.B. Dreger" <eddy+public+spam@xxxxxxxxxxxxxxxxx>]

AW> Date: Tue, 28 May 2002 12:37:57 +0100
AW> From: Andrew Watson


AW> I want to be able to retrieve information from an M$ Access
AW> database on my RaQ4 using Perl and then convert it to
AW> MySQL.  If this were a one time only thing it would be
AW> relatively straight forward to do but the Access file will be
AW> updated daily locally and then uploaded online.  I understand
AW> I need an NT server to host the Access database and I read
AW> the How To at http://pkgmaster.com/howto/casp_access_howto.shtml
AW> but this relates to ASP, will the ODBC link work with Perl
AW> and if so has anyone done this before?

How big is the database?  How much bandwidth separates it from
the server?

The above might be painful if you do it on a daily basis.  What I
usually do in your situation is install the appropriate ODBC
driver (PostgreSQL, MySQL, etc.) on the Windows machine, create a
DSN that points to the Unix DBMS, and have Access be a pretty
front-end for the Unix DBMS.

I'll warn you, though, it's annoyingly slow over DSL, Cable, or
T1.  Ethernet and T3 are fine.  Dialup is outright torture.

You can always dump Access tables to CSV or TAB files, then feed
those to your Unix DBMS.

If you really want to have your RAQ talk to a Windows machine
running Access, install an ODBC driver such as the one from
iodbc.org.  I can't recommend a Perl module for ODBC access,
because I always use C for this sort of thing.

Please give some more details or indicate any preferences, and I
can explain a bit more concretely.


--
Eddy

Brotsman & Dreger, Inc. - EverQuick Internet Division
Phone: +1 (316) 794-8922 Wichita/(Inter)national
Phone: +1 (785) 865-5885 Lawrence

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Date: Mon, 21 May 2001 11:23:58 +0000 (GMT)
From: A Trap <blacklist@xxxxxxxxx>
To: blacklist@xxxxxxxxx
Subject: Please ignore this portion of my mail signature.

These last few lines are a trap for address-harvesting spambots.
Do NOT send mail to <blacklist@xxxxxxxxx>, or you are likely to
be blocked.