Accessing SQL-database from wincc

[Csar1985]

Hi,

i was wondering,

we are currently connecting to a database from wincc flex lik described on the siemens site:

https://support.automation.siemens....extranet=standard&viewreg=WW&load=treecontent

Now, we are switching onto regular wincc, and those scripts doesnt seem to work. Has anyone got experience with connecting to a sql database from wincc?

We use the database for storing info on our clearing conditions.
Tnx in advance
Nico

 

[LestatZA]

I do quite a bit of data logging to SQL.
Siemens uses the ODBC route, I do not.
I use the generic OLEDB provider, and a stored procedure that resides on the SQL DB.

Example

On Error Resume Next
'Variable for server connection
Dim strProvider, strServer, strDatabase, strUID,strPWD
Dim objConn, objCMD, objParams

'Variable for server connection
strProvider = "SQLOLEDB"
strServer = "YourServerName"
strDatabase= "ME"
strUID ="UserName"
strPWD ="password"

'Create connection with SQL server
Set objConn = CreateObject("ADODB.Connection") 'Create object for sql connection
objConn.ConnectionTimeout = 5
objConn.Open "Provider="+ strProvider+";Server="+ strServer+";DataBase="+ strDatabase+";UID="+ strUID+";PWD="+ strPWD+";"

'Create the command send to server
Set objCMD = CreateObject("ADODB.Command") 'Create cammand object for stored procedure call from SQL
Set objCMD.ActiveConnection = objConn 'Pointer to show cammand which connection to use
objCMD.CommandText = strProcName 'Name of the stored Procedure
objCMD.CommandType = 4 'adCmdStoredProc

'Parameters for the stored procedure (name,type,direction,size,value)
'Input parameters for procedure

Set objParams = objCMD.CreateParameter("@YourParameter",3,1,1,Parameter)
objCMD.Parameters.Append objParams
objCMD.Execute

'Returned Values
' Transfer returned Values
'Close connection and Release variables
objConn.close
Set objConn = Nothing
Set objCMD = Nothing
Set objParams = Nothing


One thing to remember if your WinCC PC is not getting a DNS from a DNS server, you will have to at the server name and IP address to the host file.
Or you could use the server IP address insted of the servers actual name.

Hope this help.