AnsweredAssumed Answered

Urgent: regarding PI Server connection using C++ ODBC

Question asked by VasanthS on Apr 6, 2017
Latest reply on Apr 7, 2017 by VasanthS

Hi Team,

 

I am new to this PI Server, Wanted to execute sql query's in PI Sql commander part of migration project.

What I have done is written a C++ application using ODBC where its connecting to my local MS Sql server using windows authentication and fetches data.

 

Same application i'm trying to use to connect PI Server and execute query's. But, the connection is failed with below connection string. I do not have Pi server credentials like UID, Password so I am trying with windows authentication to login.

Connection String:

CONSTR=Driver={PI ODBC Driver};Server=[10.64.19.15];Provider Type=PIOLEDBINT;Initial Catalog=piarchive;Provider String ={Data Source=PI Servers;Integrated Security=SSPI;};

Error:

Message: [PIODBC] System.UriFormatException: Invalid URI: The hostname could not  be parsed.

SQLSTATE: 08004

 

Please let me know what i'm doing wrong here.

 

Is it possible to connect PI Server using C++ ODBC which i coded for MS Sql Server? Or I need any specific SDK's to connect to PI Server?

 

Please help me out.

 

Thanks,

Vasanth

Outcomes