Call Stored Procedure in MS SQL Server

[vincentius]

Hi all,

How to call a stored procedure in MS SQL Server from an ASP. I try this code, but it's generate an error.

Code:
set rs = conn1.execute("TEMaster.dbo.CP_PtBrg " & qqakh & "," & usr)

Error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '.'.

What code should I add so I can free from this error?

Thanks,

Vincent.

 

[link9]

set rs = conn1.execute("Exec TEMaster.dbo.CP_PtBrg " & qqakh & "," & usr)

 

[vincentius]

link 9,

I try the code you give to me, but it still generates the same error. Why?

Thanks,

Vincent.