Login / Signup

Execute stored procedure

 
Archive Data mgt
Last Post by AD 8 years ago
5 Posts
3 Users
0 Likes
31 Views
RSS
ACHT
 ACHT
(@a-chaverotarcinfo-com)
Posts: 161
Reputable Member
Topic starter
 

Hello

Do you know how to execute a SQL stored procedure from PcVue?

I know from maintenance plan but I wish execute manually from a mimic.

Thanks

 
Posted : 18/05/2018 12:17 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

HI Anthony,

Scada Basic or VBA

 
Posted : 18/05/2018 2:23 pm
ACHT
 ACHT
(@a-chaverotarcinfo-com)
Posts: 161
Reputable Member
Topic starter
 

Thanks Nico but I hope another answer.

Vba, I don't like because it is not Web compliant.

Scada, I don't like because it is necessary to create ODBC source .And login, password are not encrypted into the Scada script...

 
Posted : 18/05/2018 5:00 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hi Anthony, Except if you go to V12 using DBConnect I am afraid you don't have another choice. About the password, if you use a Windows user you don't have to enter any password. Another idea: What you could do is to run a SQLcmd tool from Scada Basic ( https://docs.microsoft.com/en-us/sql/relational-databases/scripting/sqlcmd-start-the-utility?view=sql-server-2017 ). No ODBC here but note you have the same password issue here... Nico

This post was modified 2 years ago by LM
 
Posted : 21/05/2018 6:59 am
AD
 AD
(@a-degrearcinfo-com)
Posts: 34
Trusted Member
 

It's the perfect job for "Universal Data Connector". B)

 
Posted : 12/06/2018 12:28 pm
Forum Jump:
  Previous Topic
Next Topic