RE: [cobalt-users] [RAQ4r] ASP, MySQL, and Microsoft Access

["Si Watts" <simon@xxxxxxxxxxx>]

        > Ok, here's the deal.  I have and maintain a Microsoft
        > Access Database
        > on a web site.  I cannot however figure out how to
        > convert my Access
        > database to MySQL (or any other format other than Dbase
        > 5) so that I can
        > use that database directly with ASP.  I know that I
        > cannot use the .mdb
        > Access file directly and since I don't have access to an
        > NT server to
        > put the database on I have to convert to a database
        > format that can be
        > accessed on the RAQ4 server.
        >
        > What is my best course of action to take here, and does
        > anybody have any
        > links to information on this subject they can forward?
        >
We pondered the same problems after having plumped for a Cobalt over an NT
box, and eventually (after many different ideas) settled for the use of
Interbase. There are various tools available for interbase and there is a
conversion tool to recreate your access db into a .gdb interbase db. Works a
treat, the driver for chilli is already installed and really there hasn't so
far been a negatives that we have found to using Interbase over MySQL. You
can get full Windows based client and server tools for Interbase initially
and then use a tool called IBaccess if you wish to create new IB db's
directly, or use sql2gdb to convert between IB and Microsoft SQL or Access.


Kind Regards

Si Watts
SiWIS http://www.siwis.co.uk

Don't just think global. THINK LOCAL!