RE: [cobalt-users] Database on RaQ4r

["Neil Stringer" <neil@xxxxxxxxxxxxxxx>]

Richard wrote

> Up to know, all virtual sites that I have are nice and 
> simple. There had to be a time when someone wants a bit more. 
> This is the request I've
> had:
> 
> "Can you set up a Data Source Name for an access database 
> called fly.mdb using the DSN "Fly"?  Where should it be 
> uploaded to and how secure will it be?"
> 
> How do I do this please?

This can't be done on the Raq4r, at least not with the access DB hosted
on the Raq.  I do not know of a way to setup a DSN on a Raq and point to
a Wintel box running the Access database, but then  1) I am no expert,
2) I wouldn't do it if I could!

I would suggest installing MySQL on the Raq, installing the MySQL ODBC
client on the wintel box and exporting the Access DB up to MySQL on the
RAQ.  You can then create a DSN and use the database via that, or
directly access the DB in ASP code (or other).

I am sure others will kick in on this, but this is my 2p worth.
--Neil