Results 1 to 4 of 4

Thread: MTS jambore

  1. Nov 9th, 2000, 12:17 AM #1
    msdnexpert
    msdnexpert is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 1999
    Posts
    266
    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
    Reply With Quote Reply With Quote
  2. Nov 9th, 2000, 10:11 AM #2
    André
    André is offline
    Addicted Member
    Join Date
    Jun 1999
    Location
    Los Angeles
    Posts
    186
    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é
    Reply With Quote Reply With Quote
  3. Nov 9th, 2000, 11:19 AM #3
    André
    André is offline
    Addicted Member
    Join Date
    Jun 1999
    Location
    Los Angeles
    Posts
    186
    Did it help?

    André
    Reply With Quote Reply With Quote
  4. Nov 11th, 2000, 01:45 PM #4
    msdnexpert
    msdnexpert is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 1999
    Posts
    266
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width