What do I need to install to use the PI JDBC driver package?
If you have AF and all, then we definitely recommend you to use PI SQL Client JDBC instead.
But for JDBC, you will need JRE 8,9,10, PI SQL Data Access Server (OLE DB) and PI OLEDB Enterprise/Provider.
And PI System Access license on the server-side.
Thank you very much
My friend, have you ever used Pilog API?
No... PIlog API is very old and is considered to be retired.
Please use AFSDK instead of PI API if you are in new project.
AFSDK CAN be used to connect to PI Data archive server and do everything in 1 package.
I believe it should be replaced by AFTrace Class.
Good!However, I encountered some difficulties in using PI JDBC. It should be because I did not install the required software. Is it necessary to install the above software to use JDBC?
Could you share your error message with us?
JRE is definitely required before installing JDBC.
PI OLEDB products and PI SQL Data Acess Server are not required in the same machine but need to be within the network.
One Correction to my previous comments: If it is PI Login API, then please ignore my previous comments.
In The process of using JDBC, The program error message is The absolute path to RDSAWrapper Library must be provided in The environment variable PI_RDS_LIB, and when I call The PI_login function in Pilog API, I don't know which window handle ID it is
Are you on Windows machine? If so, please see User guide - Installation Results.
There is also versions for Linux installation. But it looks like your environmental variable is not properly set or moved.
Yes, the windoes machine is not PI OLEDB Enterprise/Provider.
PI SQL Data Access Server, and my JDBC only has one driver JRE package...I am very upset
Thank you so much for helping me! thank you!!!
Please feel free to come back for any PI questions. Thank you.
PI OLEDB Enterprise/Provider can be downloaded from the official website.
PI SQL Data Access Server
Brother, I reported an error in using JDBC operation because the target calculator actively refused, unable to connect. What is the reason for this?
Is it similar to below message? Usually the error message is due to the firewall or port issues.
PI SQL DAS Not Running or Port 5461 Blocked by Access Rule
Yes!I found the reason is due to the DNS input error, and it will be better after correction. Thank you very much for your help!thank you
Retrieving data ...