Invalid Descriptor Index! 1

[Antzz]

Hello Everyone,
I am using Crystal Reports communicating with SQL Server via ODBC. I get an ODBC error everytime I try to load a report - Invalid Descriptor Index.

I have tried the same client with 3 different database servers. It works perfectly with 2 servers but not the third which of course is the Production. The Report App., is developed in a Client/Server configuration.

Any help is appreciated.

Antz

 

[vidru]

I get that error when the report is expecting a field from a stored procedure, but the procedure in the current database doesn't return that field. If you're using stored procedures, run them on each db to make sure they're all returning the same fields (in the same order). If you're using tables/views, check and compare the table definitions in each db.

-dave

 

[Antzz]

vidru, the report is using a stored procedure. The unusual thing is that the same report(same desktop client) works with two other databse servers but fails on the third. I am just wondering it has got anything to do with any ODBC libs.
Past posts on this forum has failed to get a clear solution to the problem.

Hopefully, this time someone who has come across this problem will post.

Thx vidru. I appreciate your input.

 

[vidru]

Not saying this is a solution, but what happens if you attempt to design the report pointing to the procedure on the Production database?

Here's a whitepaper:

http://support.businessobjects.com/library/kbase/articles/c2013544.asp

-dave

 

[Antzz]

dave, still give me the same problem. I am going to create a new report and update this thread tomorrow if I have it up and running

 

[Antzz]

Dave,
Finally got this one working. This error is rather a more generic one which might be a caused by one or a combination of different issues.

The one that broke mine :
1)The store procedure returns a recordset with columns A, B, C, D, etc.
2)The report uses the columns in the order A, D, C, B
3)Once I modifed the stored procedure to return the columns in the order used by the report, everything worked fine.

Thanks for all your help and hope this is useful to everyone who might come across it.

Have a safe 4th

Roopam