[cobalt-users] Interbase/ASP working now..YEAH

["Todd Kirk" <tkirk@xxxxxxxxxxxxxx>]

Hi all,

Ok we have sorted our Interbase/ASP situation here. The thing of it was to
make all databases, tables and field names in uppercase! I have no idea why,
as the process involves this sequence of software below. This is from a
factory standard install of Interbase 6 Classic Server on a Cobalt RAQ4r. We
did add the Interbase server to init on boot upand also check that your
Interbase server is listening for your client s/w to connect.

IBExpert, Client side - to create database and permissions
Cobalt DSN GUI with standard Chilisoft ASP install, Server side - to allow
connections to Interbase database
System DSN with Easysoft ODBC, Client side - to allow connection to
Interbase server
IBExpert, Client side - to create tables, fields, datatypes, triggers and
generators
Macromedia UltraDev, Client Side - to create ASP pages

We did need to purchase Easysoft and IBExpert. Without the uppercase we
could still create or edit databases, and serve read-only ASP pages but
could not use update, insert or delete features using Macromedia's UltraDev.
This was solved by the uppercase rule.

Some sites if you need them:
http://www.easysoft.com (Nick Gorham is very helpful in their newsgroup)
http://www.ibexpert.com




regards,

Todd Kirk