ASP database connect string

Results 1 to 2 of 2

Thread: ASP database connect string

  1. #1
    Paul Hudson Guest

    Default ASP database connect string

    This code was produced by using IDC2ASP:<BR><BR>&#060;%@ LANGUAGE="VBScript" &#037;&#062;<BR>&#060;!--#include file="ADOVBS.inc"--><BR>&#060;!--#include file="IASUtil.asp"--><BR><BR>&#060;%<BR>Set Connection = Server.CreateObject("ADODB.Connection")<BR><BR>Con nection.Open "DSN=Courses"<BR><BR>SQLStmt = "SELECT COURSE_TITLE, "<BR>SQLStmt = SQLStmt & "COURSE_CODE, "<BR>SQLStmt = SQLStmt & "LOCATION, "<BR>SQLStmt = SQLStmt & "START_DATE, "<BR>SQLStmt = SQLStmt & "END_DATE, "<BR>SQLStmt = SQLStmt & "START_TIME, "<BR>SQLStmt = SQLStmt & "END_TIME, "<BR>SQLStmt = SQLStmt & "LEAFLET, "<BR>SQLStmt = SQLStmt & "DAYS, "<BR>SQLStmt = SQLStmt & "PLACES_LEFT "<BR>SQLStmt = SQLStmt & "FROM t_courses "<BR>SQLStmt = SQLStmt & "ORDER BY COURSE_TITLE, COURSE_CODE; "<BR><BR>Set RS = Connection.Execute(SQLStmt)<BR>&#037;&#062;<BR><BR >...before the &#060;html> tag. What have I got to change or add to enable connection to the database without using ODBC?<BR><BR>Many thanks, Paul.<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    168

    Default RE: ASP database connect string

    FYI: I posted a reply in the other forum to this inquiry

Posting Permissions

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