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

ODBC work on LBI 10.5?

 4 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
ISO_Dan
New Member
Posts: 2
New Member
3/17/2015 8:53 PM
I heard that in LBI 10.5 that all Crystal reports have to be OLE DB. Can someone confirm this? We have many reports using SQL and Views and to convert all of them would be very time consuming. Hoping ODBC will work with 10.5

Thank you,
Dan
ISO_Dan
New Member
Posts: 2
New Member
3/18/2015 2:26 PM
Infor responded, and ODBC does work on LBI 10.5, we are having issues and cannot get it to run. Has anyone gotten ODBC to run on 10.5?
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
3/18/2015 2:34 PM
Are you having ODBC connectivity issues with Oracle, SQL Server, or DB2? Is this a new install or an upgrade? Are you able to run a report via the Crystal Reports Designer on the LBI 10.5 server?
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!
3/18/2015 2:41 PM
Remember to create your data sources using the 32-bit version of the data sources app - located C:\Windows\SysWOW64\odbcad32.exe
ISO Dan
Basic Member
Posts: 18
Basic Member
3/19/2015 4:09 PM
Issue has been resolved, we had both the 64 bit and 32 bit DNS with the same name, we deleted the 64 bit and it worked