Connecting to SqlCE via Lisp

[StephanKoster]

I'd like to connect to a Microsoft SQL Server Compact 3.5-database.

In VB this works:

Dim oConn As ADODB.Connection
Set oConn = New ADODB.Connection
oConn.Provider = "Microsoft.SQLSERVER.CE.OLEDB.3.5"
oConn.Open "c:\test\test.sdf"

But translated to lisp like that:

(setq oConn (vlax-create-object "ADODB.Connection"))
(vlax-put-property oConn "Provider" "Microsoft.SQLSERVER.CE.OLEDB.3.5")
(vlax-invoke-method oConn "Open" "c:\\test\\test.sdf")

it does not work.

The error message when processing the last line is: 'Zu wenige tatsächliche Parameter' ('To few actual parameters').

Any idea someone?

[StephanKoster]

To answer my own question: I have to change

(vlax-invoke-method oConn "Open" "c:\\test\\test.sdf")

to

(vlax-invoke-method oConn "Open" "c:\\test\\test.sdf" "" password -1)

and that works.

I wrongly thought these additional parameters were optional.