• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Oracle odbc drivers for RS ODBC on LBI 904 Win 2008 64bit

 6 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
jrbledsoe001
New Member
Posts: 0
New Member
9/14/2011 6:42 PM
We are doing a fresh LBI 904 install on a Windows 2008 64bit server. We will need a Reporting Services ODBC data source for Crystal ODBC reports pointing to an Oracle 11g database (Lawson app server running on AIX 6.1 Oracle 11g). Anyone know what Oracle client we should run on the Win 2008 64 bit server; example Oracle 11g client for 32bit or 64bit?
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
9/14/2011 8:11 PM
See Lawson KB article # 548987
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
9/14/2011 8:12 PM
For the Oracle client, we have both installed here, but I believe that it is only using the 32-bit one. At least that's the only one that seems to matter.
jrbledsoe001
New Member
Posts: 0
New Member
9/14/2011 8:33 PM
Greg,

Thanks for responding to my post. I couldn't find any concrete references or documentation so I installed both Oracle drivers.

Take care

Joanna Bledsoe
Robby
Veteran Member
Posts: 87
Veteran Member
New Poster
New Poster
Congrats on posting!
12/19/2011 11:14 AM
Could someone with an Oracle ODBC/jdbc datasource connection in Reporting Services send a screen shot of the setup screens? The KB Article above helps setup a PC (done that) What I need is to point my IT people (I'm the report writer, not the admin) to the correct datasource connection setup. thanks in advance for your help.
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
12/19/2011 3:29 PM
Here is the way that we have done it here at Genesis Health System. It seems to work.

Note: We have configured the exact same datasource name in our Crystal Designer, to make it easier to cross from developing reports to publishing them.

Cheers,
-Greg
Attachments
Robby
Veteran Member
Posts: 87
Veteran Member
New Poster
New Poster
Congrats on posting!
12/19/2011 5:31 PM
Greg, thanks! I'll send this .doc to the IT guys and make sure the ODBC connection on the LBI server is setup correctly.
-Bob