Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

wincc 62 SQL ActiveX

Created by: Sergey_Lotvin at: 2/4/2008 1:14 PM (1 Replies)

Rating (1)

Thanks 0

2 Entries

2/4/2008 1:14 PM	Rate (0)
Sergey_Lotvin Posts: 30 Rating: (0)	Hi, everybody! I have to to insert data from ms sql server to my wincc *.pdl. I know what I have to write in query, but: 1 - i haven't an ActiveX like DBGrid Control 2 - DBGrid control or MS Flexgrid I can't use because WinCC writes-->"License information not found. You do not possess a valid license for the design mode"... But I need to write data from sql server to smth table in WinCC, can you help me please?
Sergey_Lotvin Posts: 30 Rating: (0)
Suggestion To thank Quote Answer

2/4/2008 3:43 PM	Rate (1)
ateam Bronze Member Joined: 12/8/2006 Last visit: 11/27/2023 Posts: 170 Rating: (26)	hi, (1)after the installation of ms visual studioyou will have the the valid license for design mode of ms activex controls. (2)On theother handit is not necessarytousemicrosoft controls like dbgrid or flexgrid toselect, update, insert or delete data. you can use standard odbc-functions (odbc32.dll)in (2.1) global script C: - SQLAllocEnv() - SQLAllocConnect() - SQLConnect() - SQLAllocStmt() - SQLExecDirect() - ( SQLBindCol() ) - ( SQLFetch() ) (2.2) global script VBS http://support.automation.siemens.com/WW/view/en/16514261 (3) using sqlcmd.exe (microsoft sql server command line tool) Attachment sql_odbc_example_c.zip (401 Downloads)

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on