No data extracted on some machines - CR 9 Runtime

[Cadette]

Trying to extract my "codes" from our database. We have a structure where "codes" are columns in each table and inserted as GUIDs. E.g. I have a table called Activity that contains the code ActivityTypeCODE.To get the description of the code I have to perform a JOIN to another table called CodeDescription in which one key is CodeID i.e. the GUID from ActivityTypeCODE.
My problem is that on some machines the description of the code doesn't get extracted. When comparing the query from one working-machine to a non-working-machine I can see that different queries are sent to the SQL server. And the JOIN to the CodeDescription table is missing in the "non-working" machine's SQL query.
The tables like the Activity table described above contain several Codes, so if I want to extract all codes I have to perform a JOIN to the CodeDescription table for each code, meaning that I end up having a lot of aliases e.g. CodeDescription_1, CodeDescription_2 etc. I am running the run-time version of Crystal Reports 9 (the merge modules from 20/2 2004). The run time is delivered together with our CRM system and launched using a .dll through a button in the application.
Please advise!

 

[synapsevampire]

Since you've determined that the queries are different, I would suspect that the connectivity is different.

How are you connecting to the database? ODBC or OLE DB?

I would check this first, and if you're using ODBC (which I'd guess), and some users have the CR ODBC driver and some have the Microsoft ODBC driver, I can understand why you might experience different results.

Make sure that you have the same driver.

You might also consider using OLE DB.

-k

 

[Cadette]

Hi! Thank you for taking the time to look into my issue!
I'm using OLE DB to connect to the SLQ Server, and I've checked all OLDEDB-related files and they are all of the same version. The files I checked are the following: OLE32.DLL
OLEPRO32.DLL
OLEAUT32.DLL
OLEDB32.DLL
OLEDB32R.DLL
OLEDLG.DLL
SQLOLEDB.DLL
SQLOLEDB.RLL
This is a great mystery to me...