RE: [cobalt-users] Connecting and creating tables

["Simon Watts" <simon@xxxxxxxxxxx>]

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Todd Kirk
Sent: 07 May 2001 09:16
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: [cobalt-users] Connecting and creating tables


> Hi, I'm back again.

> 	This is my first attempt to connect to an Interbase database. I have
> created the DSN in the cobalt menu system, pretty straight forward there
> (dsn name, db filename, user, password), this is on a RAQ4r.

I have a RAQ4i so the setup should be identical.
We have also set up Interbase to use via ASP and ourminitial test has been
successful, although with a bit of messing around!
In your SDN you need to specify the full path to your database under DbName,
not just the name of the database

>
> 1. Where do the .gdb database file locate themselves? Have I even got the
> file extension correct? (so I can create the correct path for my DSN
setup)

You can place your .gdb anywhere within the virtual site structure.
we opted to create an additional folder "database" at the same level as the
www folder for the site, ie out of the web path
Yes the file will be a .gdb

> 2. The client ODBC driver to connect either macromedia UltraDev and/or Ms
> Access 2000? (I assume the server is already setup correctly, I am
currently
> trying to use Easysoft trial ODBC driver)

Sorry can't help you with this one, we did hand coded ASP, and it wasn't me!
I just did the server side setup of the DSN etc

> 3. The client software to create tables and set field defaults etc? (GUI
> interface if possible please)
>
Check out the Interbase site http://www.interbase.com/ There's a windows
client and server interface.
We also managed to find a site which had a neat program which could take
your interbase database and
convert it to interbase and subsequently synchronise it to your web one.
Look for "mdb2gdb or sql2gdb"

> Sorry if I have repeated myself from previous posts but I am confusing
> myself now I think ;-).
>
>
>
> regards,
>
> Todd Kirk

Hope this all helps!

Regards

Si Watts
Owner; SiWIS
http://www.siwis.com

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