Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Table "tablename" has no columns or is invalid...

2 posts in PB Infomaker Report Writer Last posting was on 1998-05-05 18:08:44.0Z
Dawn Wisniewski Posted on 1998-05-04 21:22:36.0Z
Newsgroups: sybase.public.infomaker.general
From: "Dawn Wisniewski" <dwisniew@co.clark.wa.us>
Subject: Table "tablename" has no columns or is invalid...
X-Newsreader: Microsoft Internet News 4.70.1155
Date: Mon, 04 May 1998 17:22:36 -0400
Lines: 12
Message-ID: <348_01bd77ab$dbd6ead0$ac07b98d@wisniewd>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7120
Article PK: 243149

Using Infomaker against Oracle. Upgraded from 7.2.3 to Oracle 7.3.4 and no
longer had native database drivers so changed to ODBC. Now, we can create
new reports, but whenever we try to edit an existing report, we get these
errors. I dropped and re-created the 'PB....' tables in the database. I
installed the 5.0.04 upgrade and still no luck. Please help.

Dawn Wisniewski
City of Vancouver/Clark County
(360) 737-6121 x 7628
dwisniew@co.clark.wa.us


Terry Dykstra [TeamPS] Posted on 1998-05-05 18:08:44.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Table "tablename" has no columns or is invalid...
Date: Tue, 5 May 1998 12:08:44 -0600
Lines: 24
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_f6fWzdEe9GA.198@forums.powersoft.com>
References: <348_01bd77ab$dbd6ead0$ac07b98d@wisniewd>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7117
Article PK: 243147

You can still use the native O72 driver with Oracle 7.3. When you use
sqlnet 2.3, make sure you install the 'Required support files 7.2.x'.
Check the DBParm DelimitIdentifier and see if that makes a difference. To
see what is really happening, turn tracing on. In the DB Profile change the
DBMS parameter from 'ODBC' to 'trace ODBC'. This will create a trace file.
You can view that file to see what statements IM is sending to the Oracle
database.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Dawn Wisniewski wrote in message <01bd77ab$dbd6ead0$ac07b98d@wisniewd>...
>Using Infomaker against Oracle. Upgraded from 7.2.3 to Oracle 7.3.4 and no
>longer had native database drivers so changed to ODBC. Now, we can create
>new reports, but whenever we try to edit an existing report, we get these
>errors. I dropped and re-created the 'PB....' tables in the database. I
>installed the 5.0.04 upgrade and still no luck. Please help.
>
>Dawn Wisniewski
>City of Vancouver/Clark County
>(360) 737-6121 x 7628
>dwisniew@co.clark.wa.us