on 11-06-2010 6:25 PM
Dear SAP Experts,
I created a query using many temp tables. When I run the query in SQL it works fine. However, when I bring the query into Crystal Reports XI, I receive the following error message:
Database Connector Error: '07009': [Microsoft][ODBC SQL Server Driver] Invalid Descriptor Index'
Has anyone ever come across this error or know how to fix it?
Thank in advance,
Zack H.
When you test the SQL directly against the MS SQL server are you sure that you are using the ODBC driver?
Which version of the MS SQL server are you accessing?
Regards,
Stratos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There were some field names that were the same. Once I made each field unique, the invalid descriptor index error was not produced any longer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Zack,
Have you installed any patches for CR XI?
When you say you are bringing them into CR how are you doing that? Are you using a Command Object or trying to run the SQL Query directly? CR doesn't support "queries" in that context. What it can do though is use a Stored Procedure. So create a SP and copy your query into it. Also note CR only see's the last SELECT statement in the SP so if you use more than one it's the last one CR can see.
Depending on how you wrote your query it may work as is, be sure to use a Cursor also, CR requires a cursor to be able to read the data set.
If you search our knowledge base system you'll find examples of how to write a SP so CR can see and use it.
And if you are using MS SQL Server 2008 you will need to upgrade to CR XI R2, for free, so it is supported.
I suggest you upgrade to XI R2 anyways, use your XI keycode when you install.
This is the link to get the full vuild:
https://smpdl.sap-ag.de/~sapidp/012002523100011802732008E/crxir2_sp4_full_build.exe
Then get SP 5 and SP 6:
https://smpdl.sap-ag.de/~sapidp/012002523100013876392008E/crxir2win_sp5.exe
https://smpdl.sap-ag.de/~sapidp/012002523100015859952009E/crxir2win_sp6.exe
Thank you
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.