Log Device from Citect Client PC

Have you specify which type processes for this log device? Here is the instruction from Help. In your case, bind the device with the client process.

There was no any type.

I specify the IO server and client one by one. and test. 

unsuccessful

It appears to be a problem with SQL access from a remote client. Try to create

• A text file from Desktop on a remote client machine
• Rename its extension to udl (you need to deselect "Hide extensions for known file types" from File Explorer Options)
• Double click on the udl file as shown below (if a desirable SQL provider is available, you will have to download and install SQL drivers pack)

• Select the same SQL provider as used on the server site.
  • Select the server name
  • Provide the SQL logon detail (recommend to use Windows integrated)
  • Select database
• Test connection.

If test connation fails, you need to consider updating the SQL security and SQL connection string.

You can save the connection details and open the udl file with Notepad where you can find the connection string. This connection string should be the same as used in the project. 

Thanks fpr reply ,,,,Test connection is OK....

But log from client to server is unsuccessful.

I think, trigger for log is independent.I need to create device for each client and install sql server on client PCs...

Am i right ?

Ideally, there should be a central SQL server, which will reduce the load on SQL server maintenance. For logging from each client, it is possible to use Cicode function - ServerInfo("Client", 0) for obtaining the current node name. You could use this information to differentiate similar messages from different clients. I am not sure how the logging trigger is implemented and what messages are logged in SQL server in your project. 

As configured in Example project, the operation log is triggered by Entry and Exit commands, as shown below. As for logging other messages, you have to implement an event to trigger their logging.

You are right...I have a central sql database on server computer.and i set the button graphic objects to log.For example, i select a log device by right click on start/stop button.

On server computer, i can see the log record in SQL databade as follows;

UserName    Date    Time    MsgLog

But when operator push any button on client computer, sql can not record from client computer...

You are right...I have a central sql database on server computer.and i set the button graphic objects to log.For example, i select a log device by right click on start/stop button.

On server computer, i can see the log record in SQL databade as follows;

UserName    Date    Time    MsgLog

But when operator push any button on client computer, sql can not record from client computer...

What is the SQL connection string you used in the Header field of SQL_DEV? It should be from the UDL file.

It looks like you have to debug the operation log code on a remote client to determine if it is a trigger or SQL access related issue.