AndrejP

MrPLC Member
 View profile  See their activity

  • Content count

    37

  • Joined

  • Last visited

Posts posted by AndrejP

  2. Posted

    Hello.

    I'm trying to comunicate to Siemens S7-300 using Citect S7NT driver.

    I haven't done this so far so I'm asking you for help.

    What software do I need to successfully comunicate with S7?

    How do I set S7NT CITECT driver (Board, port, device,...)?

    Thanks.

    Best regards.

  3. Posted

    But now I have another problem.

    In Citect Nexa 6.1 I'm using conn string:

    hSQL = SQLConnect(" Driver={SQL Server};Server=PC_NAME\SQLEXPRESS;Database=MyDatabase;Uid=User;Pwd=Password)

    It connects without problems.

    If I use Querystring: SELECT * FROM MyDataTable it works. I've got values from table.

    BUT!!!

    If I use more complicated Querys like Queriing a Subquery (IT WORKS IN SCADA 2016 and in SQL SERVER MANAGEMENT STUDIO):

    SELECT *
    from (
        SELECT * 
        from mytable
    ) subquery

    I've got error: 4501Unexpected text at end of SQL query 'FROM'

    Does someone have any advise?

    Thanks.

    Best regards.

     

     

  4. Posted

    Hello.

    The Citect Nexa 6.1 is running on WIN7 machine.

    The Citect 2016 is on different machine using WIN10

    If you are using MSSQL-Wxpress, The connection string using CITECT 2016 is:

    hSQL = SQLConnect("SCADA Data Provider=SQLClient;Persist Security Info=False;Integrated Security=true;Initial Catalog=mydatabase;User ID=User;Password=Password;server=PC_NAME\SQLEXPRESS;")


     

  6. Posted

    Hello. 

    Wasan Thanks for answer.

    I helped myself with "Database Exchange Controll" to build connection string.

    The result for successfull connection was (almost the same as yours):

    hSQL = SQLConnect("DSN=SQLDatabase_Name;UID=UserName;PWD=Password;APP=CITECT;WSID=ComputerName;DATABASE=SQLDatabase_Name;")

    Best regards, Andrej.

        
        

  7. Posted

    Hello.

    I'm trying to connect to Microsoft SQL Server (2008 EXPRESS), but the connection is not working.

    I have done this in Citect SCADA 2018 without any problems using connection string:

    hSQL = SQLConnect("SCADA Data Provider=SQLClient.....)

    How can I connect to MS SQL Server using Citect 6.1?

    Thanks.

    Best regards.

  10. Posted

    Thanks for answer.

    I have allready figured out I can use reminder.

    Problem is that I need to do this in Function Block.

    I declare variable as UDINT. The program automatically assign address to this variable.

    The sollution would be assigning fixed memory allocation.

    But I would like to avoid using fixed memory allocation (when declaring variable). 

    How can it be done this by looking at the R+1 (reminder) of declared variable?

    Best regards.