Forum Discussion

angela's avatar
angela
Catalyst II
6 years ago

Is it possible to use make a ACE OLEDB connection from a server Method?

Hi community, I want to connector to an OLEDB provider via server Method for loading Excel content into Innovator. (I cannot use the batch loader for my use case). The basic connection is done li...
Excel
ddidonato's avatar
ddidonato
Creator II
5 years ago

Has anyone found a resolution to this problem?

angela's avatar
angela
Catalyst II
5 years ago

Ensure to install the driver on the database server, not the application server. ACE must be present as provider in the "connection server" list in SQL Server Management Studio.