SQL Connection Issue!!

Results 1 to 2 of 2

Thread: SQL Connection Issue!!

  1. #1
    Join Date
    Dec 1969

    Default SQL Connection Issue!!

    I wrote a small ASP app, and it works fine on my development server as well as locally, but when I moved it to production, I get an error when I try to write to a SQL DB. (I&#039;m writing to the same db as I was locally and from dev)<BR><BR>I get the following errror:<BR><BR>Object doesn&#039;t support this property or method: &#039;conn.Open&#039; <BR>800a01b6<BR><BR>resulting from this code:<BR><BR>Sub ConnDB<BR>Set conn = Server.CreateObject("adodb.connection")<BR>conn.Op en = "DRIVER={SQL Server};SERVER=SQL096;DATABASE=xxxx;UID=xxxx;pwd=x xxx"<BR>End Sub<BR><BR>I define the variables that I want to submit to the db, write the sql insert statement, then I have this...<BR><BR>conndb &#039;this is the sub<BR>Set Rs = Server.CreateObject ("adodb.recordset")<BR>Rs.open strSQL, conn <BR><BR>Thanks for looking at this...

  2. #2
    Join Date
    Dec 1969

    Default .Open is a method not a property

    Conn.Open "connection string goes here"

Posting Permissions

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