Function to insert values in a MS SQL Table

[9252Survive]

Hello guys! 

I am having some difficulty in achieving a very simple task here. I have gone through the forums and tried some examples and UDFs but I can't seem to work it out. I would really appreciate if someone could help me out. 

Problem:

Currently, I am logging the required feedback from the script into a log file in a simple way ... get the info in the var >> write it in the file 

But now I am in need to perform some analysis and need some of the values to go into an MSSQL table  in the attached format

Also, I need to be able to use Integrated Security" or "Trusted_Connection set as true or use the logged in windows credentials to connect to the server/database

any help will be much appreciated!!!  

Thanks! 

Edited June 29, 2018 by 9252Survive

[mLipok]

Did you try my ADO.au3 udf ?

 

[9252Survive]

Hello mLipok! 

I did try your UDF but I am very certain that I might not have done it correctly, I also tried the ADO_API.au3 but did not work.
Could you show me an example to enter above given data or anything rather using integrated Security" or "Trusted_Connection?

[mLipok]

Q1:
Did you read about inserting here:

Q2:

What you get from COM ERROR Handler in console ?