Im getting an error on this part of my (server side database )
in form_load
highlights: Conn.Open ' which opens the connection of course
Printable View
Im getting an error on this part of my (server side database )
in form_load
highlights: Conn.Open ' which opens the connection of course
The connection string is invalid or required dlls have not been installed.
Post your code.
this is part of my form load.VB Code:
'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
btw never did any ADO stuff before, talk to me like an oompa loompa
:p
Resolved it. Thanks for letting me know what the error meant lol
changed to this ( was connection string error )
VB Code:
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