Can't see all tables - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Fernando Labrada

Basic Member Send Private Message

Posts: 14

3/20/2007 7:52 PM

Crystal XI using Oracle ODBC driver. When I create a new ODBC connection to a Lawson environment and I select a data area within that environment, only the tables that start from AC to MM (including all the L_) show up. Anything past MM does not. If I use the same ODBC connection and use Access instead of Crystal, I can see all the tables beyond those that start with MM. Has anyone else had this issue?

John Henley

Posts: 3351

3/20/2007 8:36 PM

Are you using Oracle's ODBC driver or Microsoft's?
Which version ?
Do you get an error message?

I'm assuming that in Crystal you're using ODBC (RDO).
There are a couple of other options:
- use the Oracle Server (native) connection rather than ODBC.
- Use OLEDB -> Microsoft OLEDB provider for ODBC
- Use OLEDB -> Oracle OLEDB Provider

Phil Simon

Veteran Member Send Private Message

Posts: 135

7/18/2007 5:05 PM

It's strange. SQL Server 2005, CRXI, OLEDB - I can't see all of the fields on some of the tables, particularly PRSAGDTL.

Fernando Labrada

Basic Member Send Private Message

Posts: 14

7/18/2007 5:39 PM

OLEDB enforces Lawson security. Is it possible field level security is being used?

Phil Simon

Veteran Member Send Private Message

Posts: 135

7/18/2007 5:49 PM

Possible, but I doubt it. I have carte blanch here.

John Henley

Posts: 3351

7/18/2007 6:49 PM

Do you mean you can't see the fields when designing the report, or that you can't see the data?

Phil Simon

Veteran Member Send Private Message

Posts: 135

7/18/2007 6:51 PM

Can't see all of the fields via OLEDB...

It might be a LSF9 security thing. We're looking into it.

John Henley

Posts: 3351

7/18/2007 7:08 PM

Try using the Excel Add Ins Query Buiider and see if you have the same issue. If you do, it's LSF9. If not, it's Crystal and/or OLEDB.

Phil Simon

Veteran Member Send Private Message

Posts: 135

7/19/2007 3:37 PM

It appears as if the new OLEDB connector (9.0.3) has resolved this. Thanks all.