Posted by vassone on 09/13/05 13:35

should I be using "cmd.CommandType = adCmdStoredProc"



"vassone" <vassone@gmail.com> wrote in message
news:IfwVe.2848$Kk3.1590@fe1.news.blueyonder.co.uk...
> Hi Erland,
>
> Your right, my apologies. The OpenDB code is below.
>
> Sub OpenDB( myRS, myConn, mySQL)
> Execute "Set " & myConn & "=Server.CreateObject(" & chr(34) &
> "ADODB.Connection" & chr(34) & ")"
> Execute myConn & ".ConnectionString =" & chr(34) & "Provider=SQLOLEDB.1;
> Integrated Security=SSPI; Persist Security Info=False;User ID=iusr_ljmu;
> Initial Catalog=HEAPADLive; Data Source=SQLSER2" & chr(34)
> Execute myConn & ".Open"
> Execute "Set " & myRS & "=Server.CreateObject(" & chr(34) &
> "ADODB.Recordset" & chr(34) & ")"
> Execute myRS & ".ActiveConnection = " & MyConn
> Execute myRS & ".Open mySQL," & myConn & ",1,2,1"
> End Sub
>
>
>
> "Erland Sommarskog" <esquel@sommarskog.se> wrote in message
> news:Xns96D06BB49B885Yazorman@127.0.0.1...
>> vassone (vassone@gmail.com) writes:
>>> Thanks for your response. This is the code I'm using from teh ASP page,
>>> I've hard wired the variables for testing purposes.
>>>
>>> Any help would be very much appreciated.
>>>
>>> strSQL= "EXECUTE heasvase.up_insert_address
>>> val1,val2,val3,val4,val5,val6,val7"
>>> Call OpenDB("rs","objDBConn",strSQL)
>>
>> That is still not sufficient for me to say anything. What does this
>> OpenDB do? (I may be a standard routine in ASP, but I don't know ASP.)
>>
>>
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>>
>> Books Online for SQL Server SP3 at
>> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>>
>
>

[Back to original message]