Connection problem? Microsoft VBScript runtime er

Results 1 to 2 of 2

Thread: Connection problem? Microsoft VBScript runtime er

  1. #1
    Join Date
    Dec 1969

    Default Connection problem? Microsoft VBScript runtime er

    &#039Here is my problem:<BR><BR>&#039I get the following error:<BR><BR>Microsoft VBScript runtime error &#039 800a01a8&#039 <BR>Object required: &#039Provider=SQLOLEDB.1;&#039 <BR>/filename.asp, line 194 <BR><BR>&#039line 194 reads as follows:<BR><BR>ConnectionString.Close<BR><BR>&#03 9More specifically, the full code around that sections looks like this:<BR><BR>allRs.Close<BR>Set allRs = Nothing <BR>Set allSQL = Nothing<BR>ConnectionString.Close<BR>Set ConnectionString = Nothing <BR><BR>&#039As you can see, I am trying to close the DB connection. My connection string (that I use to open the database connection earlier in the page) is as follows:<BR><BR>ConnectionString = "Provider=SQLOLEDB.1; Network Library=dbmssocn;Password=password;User ID=username;Initial Catalog=dsnname;Data Source=;"<BR><BR>&#039Hope this is sufficient information. Can anybody tell me what I am doing wrong? Some other coding from my page:<BR><BR>allSQL = "SELECT Feeder.ID, "<BR>allSQL = allSQL & "Feeder.Title, "<BR>allSQL = allSQL & "Feeder.ListMonth, "<BR>allSQL = allSQL & "Feeder.ListDay, "<BR>allSQL = allSQL & "Feeder.NewsLocation "<BR>allSQL = allSQL & "FROM Feeder "<BR>allSQL = allSQL & " WHERE Feeder.ID=&#039 1&#039;"<BR><BR>Set allRs = Server.CreateObject("ADODB.Recordset")<BR>allRs.Op en allSQL, ConnectionString, 3, 3 <BR><BR>&#039Thank you!<BR><BR>ty -

  2. #2
    Join Date
    Dec 1969

    Default ***CROSSPOST*** see ASP forum

    PLEASE do NOT CrossPost! It is *VERY* bad "netiquette"!<BR><BR>

Posting Permissions

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