PIJDBC Driver 所使用的URL (分别为采用 PI OLEDB Enterprise 或者 PI OLEDB Provider 来实现连接 )
而 连接的认证方式
insert into piarchive..picomp2(tag,time,value) values('ppnie_test','*',101);
[PIOLEDB] Row insertion failed. [PI SDK] Insufficient permission to access or complete operation.[-10401] No Write Access - Secure Object
Hi, from the information you just provided, I'm assuming that you're accessing PI Data Archive system via PI JDBC, PI DQL Data Access Server and PI OLEDB Provider, and I also assumed that you had been connected to PI system with PI JDBC because you had just tried to type insert statement and got the error -10401; in this case you can try select statement to see if you have read permission with PI JDBC access, then you will have to double-check security setting on PI Data Archive server to see if you have enough read/write permission with PI JDBC. Thanks.