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