|
|
Posted by vassone on 09/13/05 11:40
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
>
Navigation:
[Reply to this message]
|