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

["Ervin Tarkhanian" <ervin@xxxxxxxxxx>]

Hi Guys,

I was in the same boat, and here's what I did.  There are several GUI tools
that can be used with MySQL to import data.  I use MySQL Front
(www.mysqlfront.de), and I allows you to import from ODBC datasources.  You
can view a list of GUI's for mysql at
http://www.mysql.com/portal/software/html/software-35-1.html

I've had no problems at all with MySQL.  I'm a little weary about using the
PostGres Database as it houses a lot of the Cobalt's GUI config settings &
sites/user info

HTH

Best regards,
Ervin Tarkhanian

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Si Watts
Sent: Tuesday, September 18, 2001 11:04 AM
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: RE: [cobalt-users] [RAQ4r] ASP, MySQL, and Microsoft Access

        > 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!

_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users