user JDBC to connect PI. but connection failed.seek help
You might have incorrect Kerberos configuration. Please refer to this KB article.
KB01938 - Configuring Kerberos Delegation with PI JDBC 2018
According to that file, the error looks like this. Why
Is szp indeed your name? If so, I wonder how you spell it.
Edit: Sorry. The spelling is clear. The pronunciation of "szp" is what I am wondering about.
I don't believe the issue you are experiencing is with Kerberos Delegation. You are attempting an explicit login against PI OLEDB Enterprise with user piadmin and an empty password on localhost. There exist many resources explaining why you should not use explicit login but the point here is that this authentication method is not supported with PI OLEDB Enterprise. PI OLEDB Enterprise connects against PI Asset Framework which only supports Windows Integrated Security. Please try removing user ID and password from your connection string and replace them with "Integrated Security=SSPI"
Retrieving data ...