Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ppuar
Starting Member
28 Posts |
 Posted - 2001-12-18 : 17:32:12
|
| I am calling a stored proc from asp:set dbCommandSP = server.CreateObject("ADODB.Command")dbCommandSP.ActiveConnection = dbConnection dbCommandSP.CommandText = "test"dbCommandSP.CommandType = 4dbCommandSP.Execute,,16The 16 in the execute means the proc will be called in asynchronous mode. The stored proc should send a MAPI email to my account using xp_sendmail. This will work fine if I use:dbCommandSP.Executebut will not work when I usedbCommandSP.Execute,,16I have tested this in SQL 2000 and it will work in both asyn and syn mode (dbCommandSP.Execute and dbCommandSP.Execute,,16). However, the asyn mode will not work in SQL 7. I would love to use SQL 2000 but since this is a production server, I can't change. I suspect there is a work around for this and I just have to find the MS KB doc. Can someone please help me on this?ThanksPardeep |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-18 : 17:39:29
|
| This could be related to the MDAC/ADO version you're using. Anything earlier than 2.6 might not work (meaning it's causing the problem on the SQL 7 server). If you update the MDAC drivers it might fix it. You can get them here:http://www.microsoft.com/data/download.htmDownload and install MDAC 2.6 RTM or SP1 on the SQL Server. Even if it doesn't ask you to reboot, you should do it anyway. |
 |
|
|
|
|
|
SQL 7 Problem - Please help