SDN Blogs: B1 DB Profiler is not working with Vista?

Weblog: SAP Business One Test Environment v2.3

Subject: B1 DB Profiler is not working with Vista?

Date: 2009-10-26 08:09:02

From: Maria Trinidad MARTINEZ GEA Business Card

Response to: B1 DB Profiler is not working with Vista?

Hi Harianto,

Can you just try to copy the code into SBO_SP_TransactionNotification instead? This way you will be able to see if there is an error message when calling the stored procedure. To test afterwards please use B1 to add/update an object (BP for example) and you will see if there is an error message.
In case the error message is related to "SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'" then please check section "Enable Ole Automation Procedures using sp_configure" at page: http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx#

Hope it helps
Trinidad.

Previous Message Next Message

SAP, mySAP, mySAP.com, xApps, xApp, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product, service names, trademarks and registered trademarks mentioned are the trademarks of their respective owners.

Weblog:	SAP Business One Test Environment v2.3
Subject:	B1 DB Profiler is not working with Vista?
Date:	2009-10-26 08:09:02
From:	Maria Trinidad MARTINEZ GEA Business Card
Response to: B1 DB Profiler is not working with Vista?

Hi Harianto, Can you just try to copy the code into SBO_SP_TransactionNotification instead? This way you will be able to see if there is an error message when calling the stored procedure. To test afterwards please use B1 to add/update an object (BP for example) and you will see if there is an error message. In case the error message is related to "SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'" then please check section "Enable Ole Automation Procedures using sp_configure" at page: http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx# Hope it helps Trinidad.