• Replies 2 replies
  • Subscribers 581 subscribers
  • Views 222 views
  • Users 0 members are here
Options
Related

Citect and x64 OLEDB

Paul

Does anyone know way for Citect 2018 to connect to x64 OLEDB providers using SQLCreate() function?

For example:
hOLEDBHandle = SQLCreate("SCADA Data Provider = OleDb; Provider = Microsoft.ACE.OLEDB.12.0; Data Source = D:\TestReport.xlsx; Extended Properties = ^"Excel 12.0 Xml;HDR=YES;IMEX=1^";");

Parents
  • I reckon there are 2 options :

    - The alarm process can be run as a 64-bit application by setting the extended memory to true, so if you call the code from the alarm process it will work

    - Install the 32-bit OLE DB in parallel (https://stackoverflow.com/questions/37710776/how-to-install-microsoft-ace-oledb-32-bit-with-office-64-bit) and use that one.
Reply
  • I reckon there are 2 options :

    - The alarm process can be run as a 64-bit application by setting the extended memory to true, so if you call the code from the alarm process it will work

    - Install the 32-bit OLE DB in parallel (https://stackoverflow.com/questions/37710776/how-to-install-microsoft-ace-oledb-32-bit-with-office-64-bit) and use that one.
Children
No Data