SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Comunication SQL Server 2019 (ODBC)- TIA Portal 15

7/16/2022 12:25 AM	Rate (0)
aumation_matheus Member Joined: 6/28/2022 Last visit: 2/5/2024 Posts: 2 Rating: (0)	Hello everyone, I am tring to salve some data (SP,PV,OUT_PID) in a data base (SQL Server 2019) using the protocol ODBC, but I am not having sucess. I am using WINCC Professional to visualize the data in a IHM and using this code VB to salve in the data base, but it's not working. Can you hepl me? Thanks. Name ODBC conection : DATA_BASE_TCC Name Table: Table1 Dim objConnection Dim strConnectionString Dim SP Dim PV Dim OUT_PID Dim strSQL Dim objCommand strConnectionString = "Provider=MSDASQL;DSN=DATA_BASE_TCC;UID=;PWD=;" SP = HMIRuntime.Tags("SP").Read PV = HMIRuntime.Tags("PV").Read OUT_PID = HMIRuntime.Tags("OUT_PID").Read strSQL = "INSERT INTO Table1 (SP,PV,OUT_PID) VALUES (" & SP & "," & PV & "," & OUT_PID & ");" Set objConnection = CreateObject("ADODB.Connection") objConnection.ConnectionString = strConnectionString objConnection.Open Set objCommand = CreateObject("ADODB.Command") With objCommand .ActiveConnection = objConnection .CommandText = strSQL End With objCommand.Execute Set objCommand = Nothing objConnection.Close Set objConnection = Nothing

Suggestion To thank Quote Answer

7/29/2022 10:29 AM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 1/22/2026 Posts: 16658 Rating: (1944)	Hello aumation_matheus do you have created the ODBC datasource in Windows OS? check also this example (its for Advanced but the general way is the same -> slightly different syntax) https://support.industry.siemens.com/cs/ww/en/view/61883659 Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer