Connecting to a database

Results 1 to 2 of 2

Thread: Connecting to a database

  1. #1
    Sharon Guest

    Default Connecting to a database

    I am trying to connect to a database. I have a website on one server and a DSN on another server. How would I write the path to connect to the database.<BR><BR>The book I have tells me to this:<BR><BR>Provider=MSDASQL; DSN=Contact; UID=DavidS; PWD=<BR><BR>So how would I convert this<BR><BR>strDSN ="driver={microsoft access driver (*.mdb)}; dbq=e:www_privateInsadb.mdb" <BR><BR>to what it says upabove.<BR><BR>Thanks<BR>Sharon

  2. #2
    Join Date
    Dec 1969

    Default RE: Connecting to a database

    strcn = "Provider=Microsoft.Jet.4.0(Jet.3.51 for Access97);User ID=Admin;Password=;Data Source=e:www_privateInsadb.mdb"<BR><BR>Good Luck!

Posting Permissions

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