I have installed Crystal Report 9.2.0 from CD.
VCL CRPE from Crystal Decision Download area: only work with version 9.2.2!
So I downloaded service pack for CR9 and it becomes 9.2.3!
VCL CRPE doesn't function!!!
How can I get all these work? where is version 9.2.2 of CR9 OR where is VCL CRPE for...
OK, it doesn't work anyway!
1. AFERDEF0 and MFFFARF0 are in the same database; if I do this:
EXEC sp_tables_ex 'AS400'
I get all the tables and views in AS400 linked server, and there are both AFERDEF0 and MFFFARF0.
2. I've tried
SELECT * FROM EPFILC1.AFERDEF0.ANNO02
and
SELECT * FROM...
This query is OK, I mean it returns all rows from the table:
SELECT * FROM OPENQUERY(AS400, 'SELECT * FROM EPFILC1.MFFFARF0 WHERE FRNDO$ = 51504')
This one returns no rows, even if I known there are records in the table:
SELECT * FROM OPENQUERY(AS400, 'SELECT * FROM EPFILC1.AFERDEF0')
I...
I've succefully set up a linked server to an as 400. I can do such thing as retrieving all record from tables through the OPENQUERY statement. However, when I query some table (that I need, NOW) the result set contains zero record. I known that it's a problem of specifying the MEMBER of that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.