ADO Connection Error

Results 1 to 3 of 3

Thread: ADO Connection Error

  1. #1
    Join Date
    Dec 1969

    Default ADO Connection Error

    While using ADO and SQL Server 7.0 I&#039;m getting the Error<BR>Provider error &#039;80020005&#039; <BR>Type mismatch. <BR>The code I&#039;m using is givenh below.<BR>Dim oConn<BR>Dim oRsDetails<BR>Dim oCmdFetchDetails<BR>Dim strConn<BR>strConn = "PROVIDER=SQLOLEDB.1;DRIVER={Sql Server};SERVER=Ws-186;UID=benchboard;PWD=TaPProS;DATABASE=BenchBoard "<BR><BR>set oConn = Server.CreateObject("ADODB.Connection")<BR>set oCmdFetchDetails = Server.CreateObject("ADODB.Command")<BR>set oRsDetails = Server.CreateObject("ADODB.Recordset")<BR>oConn.Op en strConn<BR><BR> with oCmdFetchDetails<BR> .CreateParameter()<BR> .ActiveConnection = cn&#039;oConn<BR> .CommandType = adCmdStoredProc<BR> .CommandText = "bprFetchCompMasHdrTemp"<BR> .Parameters.Append .CreateParameter("@CompName",adVarChar,adParamInpu t,"RPMSystems")<BR> .Parameters("@CompName") = "RPMSystems"&#039;Request.querystring("compname")< BR>End with<BR><BR>set oRsDetails = oCmdFetchDetails.Execute<BR><BR>Is there any remedy for this?<BR><BR>Giri.V

  2. #2
    Join Date
    Dec 1969

    Default RE: ADO Connection Error

    error line??

  3. #3
    NPKumar Guest

    Default RE: ADO Connection Error

    strConn = "PROVIDER=SQLOLEDB.1; SERVER=Ws-186;UID=benchboard;PWD=TaPProS;DATABASE=BenchBoard "<BR><BR>Try with the above line.

Posting Permissions

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