Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

hie programmers

i am trying to connect to a database using this code but am failing pliz help me
dim stuADO as ADODB.connection
stuADO= new ADODB.connection
stuADO.open("provider= microsoft.jet.OLEDB.4.0; & _
"Dat source = 'C:\Program files microsoft visual studio vb98 lithabile.mdb
stuADO.close.
pliz help me on this one.
where is the problem.
thank you.

Comments

  • rashid83rashid83 Member Posts: 11
    : i am trying to connect to a database using this code but am failing
    : pliz help me
    : dim stuADO as ADODB.connection
    : stuADO= new ADODB.connection
    : stuADO.open("provider= microsoft.jet.OLEDB.4.0; & _
    : "Dat source = 'C:\Program files microsoft visual studio vb98
    : lithabile.mdb
    : stuADO.close.
    : pliz help me on this one.
    : where is the problem.
    : thank you.
    try to use this one
    this part is in declaration
    Public db As New ADODB.Connection
    Public rs As New ADODB.Recordset

    in form load
    Set db = New ADODB.Connection
    Set rs = New ADODB.Recordset
    db.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.path & "lithabile.mdb;"
    db.Open


    there is some spell mistake too in your post so be ware next time


Sign In or Register to comment.