Hello,
After I altered a table in my database I am not able to connect the
Database with the postgresql-odbc-driver (v.6.40.00.09)
What I get is:
ODBC--call failed.
The Access-Table only shows col-names but nothing else.
It is a RH6.1Linux with PostgreSQL 6.5.2
Because I am new to SQL it is a very simple db music1 with 2 tables
(artist, volumes).
artist has 2 col. (name1, name2)
volumes has 3 col. (vname1, vname2, vname3)
What I did was
ALTER TABLE artist ADD (refno1 INTERGER) ;
ALTER TABLE artist RENAME refno1 TO aref1 ;
Is there something else to do with the db?
Any hints?
TIA
C.