Re: [cobalt-users] Accessing a Separate Database Server

["Nico Meijer" <nico.meijer@xxxxxxxxx>]

Hi Jamie,

> I am sorry if this has been answered before, but I couldn't find an answer
> in the archives.  I am setting up a Windows 2000 database server attached
to
> our RaQ4r and assigning it a private IP address to keep it hidden from the
> world..  Both boxes will be at a Co-Location facility..

Apart from the "Windows 2000" bit, that kind of setup sounds okay.

> We are only setting this up because several of
> our clients are stubborn and want to use MS Access databases because
that's
> what they know.

Sorry if you have already thought this over well, but why don't you give
them their Access database through MySQL/MyODBC? You can link Access dbs to
a MySQL source if you'd like.

MyODBC installs in less than five minutes, works like a charm and if you
didn't know any better, you wouldn't think there's a real database running
on the background. Oh yeah, it's a lot cheaper than a new box (you'd have to
run nifty hardware), a W2000 license *and* another copy of Access...

Punch it up @ http://www.mysql.com and definitely look for licensing costs.
;-)

Just my two cents, but I just hope you hadn't overlooked this part.

> I don't want to have to drive to the co-location facility
> every time we need to add a new database and setup ODBC through the
control
> panel.

The thought horrifies me, stop! ;-)

Have a great day... Nico