September 6, 2005 at 1:13 am
hai folks
I encountered a problem while i execute a stored procedure in the sql server which has a tempory table created and inserted some values in it at last it will select the tempory table.
I have a domain user account, and i added that user account in the sqlserver and gave all permission to it.
If I loged in to the sql server in windows authentication mode and execute the stored procedure in query analyzer the stored procedure excutes and retrives the selected records from the tempory table.
If I try to excute the same procedure for the VB coding the recordset is not filled up. please any body help me to get away form this problem.
I connected to the sqlserver in windows authentication in the VB coding.
September 6, 2005 at 4:35 am
If your VB code connects with the same user account as you logged in with when running the proc from Query Analyzer - then the result should indeed be sent to the querying VB app.
Please make sure that you are using the same account in both cases.
If connecting accounts are okay, then the results are returned as they should, the error then likely is with the receiving VB code, not the SQL Server.
One easy way to verify if the procedure is executed or not, is to us Profiler to trace what the VB code is doing.
/Kenneth
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply