INSERT into sql server table

[sal21]

Code: Select all

...
  Set CNN = New ADODB.Connection

    strCnString = "Provider=SQLOLEDB;" & _
                  "Data Source=DESKTOP-TQPVR2M\SQLEXPRESS;" & _
                  "Initial Catalog=CPO;Integrated Security=SSPI;"
    CNN.Open strCnString
    ...

how to insert value into the fields of table1 of CPO database via sql insert?

[HansV]

Code: Select all

    Dim SQL As String
    SQL = "INSERT INTO TABLE Table1 (Field1, Field2, Field3) VALUES ('Sal21', 'Napoli', 123456)"
    CNN.Execute CommandText:=SQL, Optiobs:=adExecuteNoRecords

[sal21]

Code: Select all

    Dim SQL As String
    SQL = "INSERT INTO TABLE Table1 (Field1, Field2, Field3) VALUES ('Sal21', 'Napoli', 123456)"
    CNN.Execute CommandText:=SQL, Optiobs:=adExecuteNoRecords

ohhhhh....
similar access database....
i'm stupid

[sal21]

Code: Select all

    Dim SQL As String
    SQL = "INSERT INTO TABLE Table1 (Field1, Field2, Field3) VALUES ('Sal21', 'Napoli', 123456)"
    CNN.Execute CommandText:=SQL, Optiobs:=adExecuteNoRecords

Hi bro, (no good exerience with SqlServer and ado) how to integrate ID and PASSWORD, if the server have?
If is possible with my conn string in post.
Tks

Note:
Please use ID and PASSWORD in a dim string

ID="sal21"
PASSWORD ="123456"

for example

[HansV]

Code: Select all

    strCnString = "Provider=SQLOLEDB;" & _
                  "Data Source=DESKTOP-TQPVR2M\SQLEXPRESS;" & _
                  "Initial Catalog=CPO;Integrated Security=SSPI;User Id=sal21;Password=123456;"

[sal21]

Code: Select all

    strCnString = "Provider=SQLOLEDB;" & _
                  "Data Source=DESKTOP-TQPVR2M\SQLEXPRESS;" & _
                  "Initial Catalog=CPO;Integrated Security=SSPI;User Id=sal21;Password=123456;"