Why the includes dont work with sql? RRS feed

  • General discussion

  • I was'nt sure where to put this question so forgive me, I have a ASP site and since swapping from access to sql server the opendb methos I have is not seen through the site and so I have the place it at the top of every file using a connection, why is this?


    set connTemp=server.createobject("ADODB.connection")
    conntemp.ConnectionString = "Driver={SQL Server};Server=CARILON\SQLEXPRESS;UID=sa;PWD=123456;Database=cq"
    connTemp.ConnectionTimeout = 30

    The above used to be called in a function ie:

    call openDB()

    and the include ontop of each page

    <!--#include file="includes\opendb.asp"-->

    but since swapping required on every page why?
    Sunday, August 16, 2009 10:03 AM