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

  • : 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.

Howdy, Stranger!

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

Categories

In this Discussion