• 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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 277
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
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