Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 85
	Members: 0
	Total: 85

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

Can't see all tables

8 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

Fernando Labrada

Basic Member

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: 3365

New Poster

Engaged Reader

Avid Reader

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

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

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

Posts: 135

7/18/2007 5:49 PM

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

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

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

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: 3365

New Poster

Engaged Reader

Avid Reader

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

Posts: 135

7/19/2007 3:37 PM

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