Access Denied

[Maya]

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

[Giuseppe Solino]

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

[Maya]

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
>

[PAdams]

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