Hi,
Can someone give me a definitive set of rules as regards what is the best strategy when using ADO. i.e. Do I use:

1. Connection strings to execute
2. command strings to execute.
3. Recordset object to execute.

I presumed the first two were relevant for doing things that did not return a recordset, and vice versa the third. however I always seem to get the syntax wrong, and have a headache searching for exactly what I want. for example to simply insert a record using a DSN, I thought the following should work, but I get a "Two Few Parameters" error, and CANNOT see the issue. Can some please advise.


Dim lcon_conn As ADODB.Connection
Dim lc_command As ADODB.Command
Dim ls_SQL As String

Set lcon_conn = New ADODB.Connection

lcon_conn.Open "DSN=test1"

ls_SQL = "Insert into customer(name) values(""gerry's"")"
Set lc_command = New ADODB.Command
lc_command.ActiveConnection = lcon_conn
lc_command.CommandText = ls_SQL
lc_command.CommandType = adCmdText

lc_command.Execute


Also the same error with the connection string.