ASP & DSN-Less

• dc_again

  i'm having trouble connecting to a Access 2003 db using ASP and a DSN-Less connection on my IIS on Windows XP. anyone got some code to open the connection please? thanks

  dc_again

  Flag

• richsteph0

  Try this

  CODE//

  Set datachannel = Server.CreateObject("ADODB.Conne...
  datachannel.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("/data/RugbyClub...

  //CODE

  richsteph 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel

• dc_again0

  thanks richsteph but i sorted it. i made a schoolboy error - my db was open in access in another window and i didn't notice. no wonder i couldn't connect. doh.

  dc_again 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel