Forum Discussion

AngelaIp's avatar
AngelaIp
Ideator I
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
Ideator I
6 years ago

Has anyone found a resolution to this problem?

AngelaIp's avatar
AngelaIp
Ideator I
6 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.