Invalid Descriptor Index on running CR7 report

[cheerfulskeptic]

Hello,
I am joining an SQL Server Table to a Pervasive SQL table in a report, and am consistently getting an invalid descriptor index error.

Here's the structure
SQL Server tables:
tbl_accounts
all fields are nvarchar and fld_MAXID is char(7)

tbl_territory
all fields are nvarchar
fld_territoryID is joined to tbl_accounts.fld_territoryID

tbl_regions
all fields are nvarchar
fld_regionID is joined to tbl_territory.fld_regionID

Pervasive SQL (2000) Fields:
Table Invoice Detail
fields vary, but CUSTID_23 is joined to fld_MAXID in tbl_accounts.

When I just have tbl_accuonts, then the report works fine. But when I add the tbl_territory and tbl_regions, I get the invalid descriptor index error (or sometimes I dont get the error, but I dont get any records from Invoice Detail either).
What could the problem be?
thanks!

 

[synapsevampire]

You're definitely pushing poor widdle CR 7...

Consider creating an Access database and linking (not importing) the tables within, and then creating a Query within Access to provide the data.

It will be faster and more readily maintained, plus other processes can leverage the Query.

-k

 

[cheerfulskeptic]

would you know why I'm getting the error in the first place?
thanks

 

[synapsevampire]

I've had it appear on occasion in the distant past, but I don't link different data sources in CR anymore.

You might try setting up just the SQL Server tables first, run the report, and then add in the Pervasive table last.

Not getting data isn't too surprising, the data types may be slightly different.

Access is generally much more generous, and it is a real database engine so you'll get better performance.

The only other thing I might try is to turn off the File->Report Options->Use Indexes or Server For Speed.

-k