HI,

I have database on local machine which I am trying to sync . 

localhost\sqlexpress
database - items
username- xx | password xxx
table - quickcapture
primarykey - recordid
column to sync - Task

This is 100% working connection string , tested via powershell

$connectionString = "Server=localhost\SQLEXPRESS;Database=items;User ID=xx;Password=xxx;Trusted_Connection=False"
$connection = New-Object System.Data.SqlClient.SqlConnection $connectionString

try {
   $connection.Open()
   Write-Output "Connection successful!"
}
catch {
   Write-Output "Connection failed: $($_.Exception.Message)"
}
finally {
   $connection.Close()
}

• I tried the following script below , but when i try to run with below I get the error 1 fields found for mapping but database connection OK but sql query failed
• Sometimes I get the errro recordid field not found in databaes , I can 100% confrim I have created a custom field (text) for the same
• SELECT recordid, Task AS Item FROM dbo.quickcapture -> This 100% confirm works

<ConnectionString>PROVIDER=MSOLEDBSQL;PASSWORD=xxx;PERSIST SECURITY INFO=TRUE;USER ID=xx;INITIAL CATALOG=items;DATA SOURCE=localhost\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096</ConnectionString>

<FieldMap>
[recordid] recordid
[Task] Item
</FieldMap>
<Source>
SELECT recordid, Task AS Item FROM dbo.quickcapture
</Source>
<RecordIDField>recordid</RecordIDField>
<RecordStatus>IDStatusSQL ADD UPDATE</RecordStatus>