Re: [cobalt-developers] Interbase 6 SQL server & Cobalt

["William L Thomson Jr" <webmaster@xxxxxxxxxxxxxxxxxxxx>]

Look Down for comments:


From: "Richard Abrams"


> > Well looks like the guys at Cobalt are trying to make things sound
better
> > than they really are.  Yes, Interbase 6 is installed on RaQ 4's but does
> > work properly.  NO!  Cobalt basically told me the proper way to start
the
>
> Let me see if I can help... no guarantees!
>
> NOTES:
> Interbase is installed as standard on the RaQ4, and *should* start up
> without you doing anything.
> You will need to download a beta .pkg from the Chili!Soft website to add a
> driver to ChiliSoft.
> The patch is available from
http://www.chilisoft.com/beta/linux/default.asp

Thanks for the heads up on that patch. I was looking for an ODBC driver for
Chili.  Now worst case I can develop my databases using the Interbase
Console on my PC.  I will just have to FTP the database onto my server, &
then connect to it through ASP.   This was my end purpose for the database
so at least I now can do that.

> 1) Download and install the patch (it adds a new driver and also fixes the
> "test" function).
> 2) Telnet into your RaQ and use "su -" to log on as root.
> Change your directory to "/opt/interbase/bin"
> Type "./isql" to start... ISQL!

When I do that it does start ISQL.  But that's not really what I am looking
for.  I prefer the GUI that comes with the IB console instead of using
command lines from telnet.  I wan to be able to use the IB Console to
connect remotely to my sever to create, modify & administer databases from
my PC where ever it & I may be.  I need IB to listen on Port 3050 for a
connection or request without blocking or interrupting all other ports.  See
its not that the other ports do not work, it's that you get disconnected
within seconds of connecting FTP, Telnet, POP3, IMAP, & etc.

> You can then use isql commands to create tables and database etc. etc.
They
> aren't particularly friendly, and I am still trying to find a way of
getting
> Workbench to happen (http://www.interbaseworkbench.com)... This aside, I
> have managed to create a database with several different tables and an
> "AutoNumber" function through ISQL though - it can be done!
>
> Use the ASP Admin webpage to create a DSN for the database.
> Make sure that you specify the full path in DbName (i.e.
> /home/sites/www.domain.com/..../mydb.gdb

This will be no problem now since I have the ODBC drivers.  I've created
DSN for other types of Databases.

> Sorry if this is teaching you to suck eggs :-)
>
>         -Richard Abrams
>         -Artejano Design and Marketing
>

I do appreciate the input & especially the link.  I Workbench similar to the
IB console?

Thanks,
William L. Thomson Jr.
CEO
Obsidian-Studios Inc.