AnsweredAssumed Answered

SQL Query with PI ACE

Question asked by Wunder on Nov 25, 2015
Latest reply on Nov 26, 2015 by Wunder

Hello,

 

I´m trying to create a PI ACE calculation with some SQL queries as followed:

 

   
Dim strSQL As String

Dim rst As New ADODB.RecordSet

Dim PICnn As New ADODB.Connection

      
PICnn.ConnectionString = "Provider = PIOLEDB;Data Source = piserver; Integrated Security = SSPI;"

PICnn.Open()

     
When I try to open the connection, I receive an error like "unable to register..."

 

Do you have an idea why this is happening?

 

Regards,

Michael

 

Outcomes