No results depending on the Pc's

[akinia]

Hi everybody,

I've created a report that is a little bit complex which use a query Access as Table. This query is an union of other queries.
I have separated all the subqueries to see in which one the problem was and it seems that it is with the following SQL:

SELECT MAFLT_MANACHNAME.BEZEICHNER_F, MAFLT_MANACHNAME.SUCHMUSTER, Mitarbeiterstammdaten.[_MANR]
FROM Mitarbeiterstammdaten, MAFLT_MANACHNAME
WHERE (((Trim$([Mitarbeiterstammdaten].[NACHNAME])) Like Trim$([MAFLT_MANACHNAME].[SUCHMUSTER]) & "*&quot);
As you can see, there is no direct link between the two tables. One table comes from Access and the other one from Oracle.
Then I've created a report with only this query. On one Pc it works fine but I've tried on other ones and I get no datas.:-(
I always get results on all the Pc's when I run the query from Access.

Any suggestion will be appreciated.:-9

Thanks in advance.

 

[Naith]

Check the connection drivers on the PC which works via ODBC administrator, and compare it to those on the other PCs.

 

[akinia]

Hi Naith,

Thanks for your quick answer, but all the drivers are the same. :-(
I'm using CR V7 on all the computers. Is there may be something I didn't check in the options for example ?

Any others suggestions ?

Thanks

 

[dgillz]

The issue is not necessarily if the drivers are the same, it is if the drivers are pointed to the same database. You can have identical drivers pointed at any number of databases.

Please check this and report back your findings. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[akinia]

Hi,

The drivers are pointed to the same database, but I've seen that the version of the Microsoft Access driver and the Microsoft ODBC for Oracle driver are different.
For the Pc where it works I have the version (4.00.6019) for MS Access and (2.573.6019) for MS ODBC for Oracle; for the others I have (4.00.4403.02) and (2.573.4403.00).
May be is it the problem ?
I've tried to get the last drivers from Microsoft web site, but for the moment I haven't succedeed.
Do they come from Office service pack, Ms Access, Data acces component ?

Thanks for your answers.

 

[Naith]

The version difference between the drivers is definitely the issue.

I don't know where you initially got the driver for the PC that works, but bear in mind that you also need to copy the Oracle driver too - not just the Access one.

Naith

 

[akinia]

You are right, that was the problem.
The version are different depending on the OS.
The Pc where it works uses Win 2000, the others use NT 4.0.
To solve the problem you need to download the MDAC 2.5 from Microsoft

Thanks again.