AnsweredAssumed Answered

PI JDBC SQLException

Question asked by mrai on May 28, 2015
Latest reply on May 29, 2015 by mrai

I am trying to query AF using PI JDBC.

 

Here is the URL

String url = "jdbc:pisql://localhost/Data Source=AF Server; Integrated Security=SSPI";

 

PI DAS is running fine. I was able to use PI JDBC to connect to the PI Server and get data.

Also, I am able to connect to AF using "PI SQL Commander" and execute queries.

 

However, connecting to AF gives me the below SQL Exception.

 

java.sql.SQLException: [PIOLEDB] [PI SDK] Unable to open a session on a server. [1225] The remote computer refused the network connection.

Outcomes