Database connectivity

Results 1 to 2 of 2

Thread: Database connectivity

  1. #1
    sorna Guest

    Default Database connectivity

    objconn.connectionstring="Provider=Microsoft.Jet.O LEDB.3.51; Data Source="<BR><BR>objconn.ConnectionString="DRIVER ={Microsoft Access Driver (*.mdb)};" & "DBQ="<BR><BR>What is the error on the above line. I tried both and not working.<BR><BR>kindly help.

  2. #2
    Join Date
    Dec 1969

    Default RE: Database connectivity

    The mistake is in using the http path.<BR><BR>You must use either an absolute path (for which you must know where the file is on your server), such as:<BR><BR>"....; Data Source=d:/website/database/login.mdb"<BR><BR>or preferably use server.mapPath() to locate your web root:<BR><BR>"....; Data Source="&server.MapPath("database/login.mdb")<BR><BR>Incidentally, if you opt for OLEDB, try 4.0 instead of 3.51.

Posting Permissions

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