-
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
-
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é
-
-
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.