DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Access Denied

  1. #1
    Maya Guest

    Access Denied


    Hello,everybody!
    I have a question!
    I have a VB programm that runs on my machine, but not on the other's. It
    gives the following Run-time error:
    [DBNMPNTW]Access denied after hits the line
    ADO Connection.Open . It has to open up connection to the Dataabse located
    on the server. I figured that DBNMPNTW is MDAC dll.
    I read about MDAC. I found that it works with DCOM together and have to be
    installed on the users machine before runing the programm. But they are installed
    there properly. Also, I noticed that if I install mssql7 on the user's computer
    - it start working. Do you know which dll I haven't include in my setup?
    Or , if you do know anything about that , please, please let me know.

    Thank you very much in advance

    Sincerely,

    Maya

  2. #2
    Giuseppe Solino Guest

    Re: Access Denied


    Hello Maya,

    You can try to install in the client machine this files:

    1. NTWDBLIB.DLL (DB-Library components must be included with the component
    vbsql.ocx)
    2. DBMSSOCN.DLL (for the TCP/IP connection)
    3. DBNMPNTW.DLL (Pipe connection)
    4. DBMSSPXN.DLL (IPX/SPX connection)
    5. DBMSADSN.DLL (Applke Talk connection)
    6. DBMSDECN.DLL (Dec-Net connection)
    7. DBMSRPCN.DLL (Multi-protocol connection)
    8. DBMSVINN.DLL (Banyan Vines connection)


    Giuseppe Solino

    "Maya" <mayablank@hotmail.com> wrote:
    >
    >Hello,everybody!
    >I have a question!
    >I have a VB programm that runs on my machine, but not on the other's. It
    >gives the following Run-time error:
    >[DBNMPNTW]Access denied after hits the line
    >ADO Connection.Open . It has to open up connection to the Dataabse located
    >on the server. I figured that DBNMPNTW is MDAC dll.
    >I read about MDAC. I found that it works with DCOM together and have to

    be
    >installed on the users machine before runing the programm. But they are

    installed
    >there properly. Also, I noticed that if I install mssql7 on the user's computer
    >- it start working. Do you know which dll I haven't include in my setup?
    >Or , if you do know anything about that , please, please let me know.
    >
    >Thank you very much in advance
    >
    >Sincerely,
    >
    >Maya



  3. #3
    Maya Guest

    Re: Access Denied



    Thank you, Giuseppe for your response.
    I've checked those dlls on user's computers and they've been already installed.
    Do you know which dll would DCOM install on user's machine?

    Thank you very much


    Maya



    "Giuseppe Solino" <gsolino@teseosistemi.it> wrote:
    >
    >Hello Maya,
    >
    >You can try to install in the client machine this files:
    >
    >1. NTWDBLIB.DLL (DB-Library components must be included with the component
    >vbsql.ocx)
    >2. DBMSSOCN.DLL (for the TCP/IP connection)
    >3. DBNMPNTW.DLL (Pipe connection)
    >4. DBMSSPXN.DLL (IPX/SPX connection)
    >5. DBMSADSN.DLL (Applke Talk connection)
    >6. DBMSDECN.DLL (Dec-Net connection)
    >7. DBMSRPCN.DLL (Multi-protocol connection)
    >8. DBMSVINN.DLL (Banyan Vines connection)
    >
    >
    >Giuseppe Solino
    >
    >"Maya" <mayablank@hotmail.com> wrote:
    >>
    >>Hello,everybody!
    >>I have a question!
    >>I have a VB programm that runs on my machine, but not on the other's. It
    >>gives the following Run-time error:
    >>[DBNMPNTW]Access denied after hits the line
    >>ADO Connection.Open . It has to open up connection to the Dataabse located
    >>on the server. I figured that DBNMPNTW is MDAC dll.
    >>I read about MDAC. I found that it works with DCOM together and have to

    >be
    >>installed on the users machine before runing the programm. But they are

    >installed
    >>there properly. Also, I noticed that if I install mssql7 on the user's

    computer
    >>- it start working. Do you know which dll I haven't include in my setup?
    >>Or , if you do know anything about that , please, please let me know.
    >>
    >>Thank you very much in advance
    >>
    >>Sincerely,
    >>
    >>Maya

    >



  4. #4
    PAdams Guest

    Re: Access Denied


    Microsoft's was at least kind enough to tell you which DLL
    is encountering the error. The DLL or service that has the
    error will be in brackets. Therefore, the code in DBNMPNTW.dll
    is generating an error when it is attempting to open your
    connection. I would suggest that you check your COM/DCOM
    permissions by running DCOMCNFG on all pertinent machines.

    The reason that it works after installing SQL7 tools on a
    machine is because you have set that machine as a 'admin'
    or 'dev' box (if you will) and the DCOM and DB access
    permissions are being set for you.

    Now, with that said, Examine your connection string thoroughly.
    Are you using the latest ADO?


    "Maya" <mayablank@hotmail.com> wrote:
    >
    >
    >Thank you, Giuseppe for your response.
    >I've checked those dlls on user's computers and they've been already installed.
    >Do you know which dll would DCOM install on user's machine?
    >
    >Thank you very much
    >
    >
    >Maya
    >
    >
    >
    >"Giuseppe Solino" <gsolino@teseosistemi.it> wrote:
    >>
    >>Hello Maya,
    >>
    >>You can try to install in the client machine this files:
    >>
    >>1. NTWDBLIB.DLL (DB-Library components must be included with the component
    >>vbsql.ocx)
    >>2. DBMSSOCN.DLL (for the TCP/IP connection)
    >>3. DBNMPNTW.DLL (Pipe connection)
    >>4. DBMSSPXN.DLL (IPX/SPX connection)
    >>5. DBMSADSN.DLL (Applke Talk connection)
    >>6. DBMSDECN.DLL (Dec-Net connection)
    >>7. DBMSRPCN.DLL (Multi-protocol connection)
    >>8. DBMSVINN.DLL (Banyan Vines connection)
    >>
    >>
    >>Giuseppe Solino
    >>
    >>"Maya" <mayablank@hotmail.com> wrote:
    >>>
    >>>Hello,everybody!
    >>>I have a question!
    >>>I have a VB programm that runs on my machine, but not on the other's.

    It
    >>>gives the following Run-time error:
    >>>[DBNMPNTW]Access denied after hits the line
    >>>ADO Connection.Open . It has to open up connection to the Dataabse located
    >>>on the server. I figured that DBNMPNTW is MDAC dll.
    >>>I read about MDAC. I found that it works with DCOM together and have to

    >>be
    >>>installed on the users machine before runing the programm. But they are

    >>installed
    >>>there properly. Also, I noticed that if I install mssql7 on the user's

    >computer
    >>>- it start working. Do you know which dll I haven't include in my setup?
    >>>Or , if you do know anything about that , please, please let me know.
    >>>
    >>>Thank you very much in advance
    >>>
    >>>Sincerely,
    >>>
    >>>Maya

    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center