Server.mappath to MySQL

Results 1 to 2 of 2

Thread: Server.mappath to MySQL

  1. #1
    Join Date
    Dec 1969

    Default Server.mappath to MySQL

    I have been using a DSN, but would prefer to use a direct connection. What does server.mappath look like when you are trying to connect to MySQL. There is no discrete file name to look for like in access right?

  2. #2
    Join Date
    Dec 1969

    Default RE: Server.mappath to MySQL<BR><BR>&#060;%@ LANGUAGE="VBSCRIPT" %&#062;<BR>&#060;% <BR>strConnection = "driver={MySQL};server=;uid=YOUR_ID;p wd=YOUR_PWD;database=YOUR_DB;option=NUM"<BR>Set adoDataConn = Server.CreateObject("ADODB.Connection") <BR>adoDataConn.Open strConnection <BR><BR>strQuery = "SELECT * FROM your_table;"<BR>Set RS = adoDataConn.Execute(strQuery) <BR>%&#062;

Posting Permissions

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