MTS jambore

[msdnexpert]

Hi all,
Anyone using MTS. I have encountered some strange problems with MTS and SQL-Server. My transactional component registered with MTS fails to connect with my SQL-Server database. It gives an error code which is as follows

-2147467259 [DBNMPNTW] Connection Open (CreateFile()) Microsoft OLEDB Provider for SQL-Server

Any ideas suggestions

[André]

Hi there,
I've had this error and for my situation it was beacause I was calling a SQL server outside our LAN.

You need to run cliconfg and then on the generals tab Network library choose TCP/IP.

This solved my problem.

Good luck,

André

[André]

Did it help?

André

[msdnexpert]

Dear Andre,
Actually I was getting this problem as there were problems in my LAN. I have resolved this by re networking my LAN.
Thanks for the repsonse.