[cobalt-developers] Postgres and ODBC Connectivity

["Geof Lutz" <wyoming@xxxxxxxxxxxx>]

The system I am working with is brand new out of the box.

I am not sure why I did not realized this before but the Chilisoft ASP
software has its own install of postgres (6.5.2) in
/home/chiliasp/odbc/internaldb/bin and the Cobalt system has another version
(7.0) under /var/lib/pgsql.  When I create a database the system uses the
Cobalt installation .  Because the Cobalt version is the active version when
I create a DSN under the Chilisoft configuration it can not see the
databases.

How did other people resolve this double install.  Did you remove one or are
both required because they store their own configuration information in a
special database (like cobalt does).  Can I bring both to 7.0 and not crash
the system.

Who in their right mind thought that two factory installations of a
client/server database system using different versions was a intelligent
idea(sorry for the rant).

Looking for ideas on how to solve this problem.

Geof


*******************

From: "Alex Lee" <alex@xxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Subject: RE: [cobalt-developers] Postgres and ODBC Connectivity
Date: Sat, 31 Mar 2001 13:04:26 +0200
Reply-To: cobalt-developers@xxxxxxxxxxxxxxx

> I am trying to connect to a Postgres database I created vi ODBC.  I have
> created a DSN with the following :
>
> Data Source Name : grow #database name#
> Database type: PostgreSQL 6.5.2
>
> I was able to create and run SQL scripts against the database.  What do I
> need to change on the RAQ4 to allow local database connections.  It would
> also be nice to be able to connect remotely while I am developing.

The ASP driver for pgsql supports up to 6.5.2, the pgsql that is running on
the RaQ4 is 7.0.2


alex

*** Original Message

I am trying to connect to a Postgres database I created vi ODBC.  I have
created a DSN with the following :

Data Source Name : grow #database name#
Database type: PostgreSQL 6.5.2
Driver : /home/chiliasp/odbc/opensource/lib/libodbcpsql.so
Server Name : #left blank#
Port : 5432
Database : grow
User : test
password : test

(this system is not live).

When I try to test the connection from the DSN screen I get the following
error:
"The page cannot be displayed"

I have also tried connecting with a JDBC driver from a WIN2000 machine using
a Openlink driver and I get the following error:

SQLException [OPLJDBC2]Error
java.io.IOException "Crypted packet received"


I was able to create and run SQL scripts against the database.  What do I
need to change on the RAQ4 to allow local database connections.  It would
also be nice to be able to connect remotely while I am developing.

Thanks
Geof Lutz