RT error , help [ resolved ]

[ice_531]

Im getting an error on this part of my (server side database )

in form_load

highlights: Conn.Open ' which opens the connection of course

[brucevde]

The connection string is invalid or required dlls have not been installed.

Post your code.

[ice_531]

'close database port if open already
'and start database listening on port 5657
dbase.Close
dbase.LocalPort = "5657"
dbase.Listen
 
Set cn = New ADODB.Connection 'declared it as a ADODB connection 
    cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "DataSource= C:\Documents and Settings\ice_531\Desktop\valeo-system-project\valeo.mdb" 'this is the connection string 
    cn.Open
    Set rs = New ADODB.Recordset 'as with the connection
    rs.Open "valeo", cn, adOpenKeyset, adLockPessimistic, adCmdTable

this is part of my form load.
btw never did any ADO stuff before, talk to me like an oompa loompa

[ice_531]

Resolved it. Thanks for letting me know what the error meant lol

changed to this ( was connection string error )

Set cn = New ADODB.Connection 'we’ve declared it as a ADODB connection lets set it.
    cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
    App.Path & "\" & "valeo.mdb;Mode=Read|Write" 'this is the connection string explained in the notes section.
    cn.Open
    Set rs = New ADODB.Recordset 'as we did with the connection
    rs.Open "valeo", cn, adOpenKeyset, adLockPessimistic, adCmdTable 'opening the recordset