sql server connect: I created an event sink on exchange serve using VB.Net. It can fired and add
data into the SQL 2005 when the exchange server has Visual Studio 2005.

When I install the component on the test exchange server in which Visual
Studio 2005 didn't installed, there is time out issue.

I have configured MS DTC on both servers (Exchange and SQL). It seems the
user who is built-in admin can connect the database,but for some unknow
reason, during running the query, there is time out.

Does anyone have any suggestion?

Hi,
I need to correct th information about the error message of SQL. The time
out issues is occured because I openend the table.

There is no error to retrun on my coding.
I used catch exception in my vb.net coding, it didn't catch any error.
Also my table in which input the data with id. The ID is identity increment
by 1. After running two tests successfully to insert data in the table, I
input the data in the table by manually. The order of ID is jumping.
For example : the last ID is 5. after running two tests, the ID jumped to be
8.



[quoted text, click to view]