How do you create a connection

Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: How do you create a connection

  1. #1
    LAJ Guest

    Default How do you create a connection

    plz help.<BR>Thanx<BR>LAJ

  2. #2
    LAJ Guest

    Default Add a bit more spec

    It is to members.mdb

  3. #3
    Tony Soprano Guest

    Default Say the magic words

    "Hocus Pocus" by the light of a full moon, and voila, the connection is made.<BR><BR>Wanna try saying WHAT you&#039;re connecting to and how?

  4. #4
    LAJ Guest

    Default RE: Say the magic words

    sorry iam connecting to a .mdb called members.mdb

  5. #5
    Join Date
    Dec 1969

    Default Isn't

    pretending fun!

  6. #6
    LAJ Guest

    Default HHHHHHHHHHeeeeeeeeelllllllllllllppppppppppp still

    how do i connect to a .mdb called members.mdb

  7. #7
    Join Date
    Dec 1969

    Default Check these out...

    First, the connection string. Tips & Tricks section of<BR><BR>Second, some samples can be downloaded from this ADO article.<BR><BR><BR>This ought to get you started.

  8. #8
    ARGGGHHHH!! Guest

    Default wha?

    There has to be a THOUSAND different places to find out how to write a connection string. Have you tried searching this site? They have example strings for you...check out the FAQs...

  9. #9
    Join Date
    Dec 1969

    Default That was annoying.

    StrConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("yourdbpath/members.mdb")<BR>Set objConn = Server.CreateObject ("ADODB.Connection")<BR>objConn.Open StrConnect

  10. #10
    Join Date
    Dec 1969

    Default OK ya' whiner LOL

    Here ya go (the DSN-less way):<BR><BR><BR><BR>strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("members.mdb")<BR><BR>set conn = server.createobject("adodb.connection")<BR>conn.op en strconn<BR><BR>set rs = server.createobject("adodb.recordset")<BR><BR>Now that you have it open ????

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts