Connectivity?

Dev Tool: VB6
Server: SQL Server 2000.
Environment: Windows 2000/Windows XP/Windows 2000 Server
I have changed a user connectivity from WINDOWS NT trusted connection to
SQL Server Authentication.
I have granted the same permissions to the new user.
The problem is as follows:
The new user cannot execute stored procedures which contains INSERT staments
.
Having the same connection and user id. When I execute the stored procedure
in the Query Analyzer console I have no problem, but when I execute it in a
Visual Basic 6.0 Application, using ADO, I get the following message:
"Operation is not Allowed when the Object is closed."
Note: I created the table, so I'm the owner, I should have no problems(??)
Any ideas?
RickRick,
Can you send your vb code where you open the ADO connection, execute the
stored proc, and then close the connection?
Thanks,
Yosh
"Rick" <Rick@.discussions.microsoft.com> wrote in message
news:131F18F8-146E-410F-8E84-2610E2871512@.microsoft.com...
> Dev Tool: VB6
> Server: SQL Server 2000.
> Environment: Windows 2000/Windows XP/Windows 2000 Server
> I have changed a user connectivity from WINDOWS NT trusted connection to
> SQL Server Authentication.
> I have granted the same permissions to the new user.
> The problem is as follows:
> The new user cannot execute stored procedures which contains INSERT
> staments.
> Having the same connection and user id. When I execute the stored
> procedure
> in the Query Analyzer console I have no problem, but when I execute it in
> a
> Visual Basic 6.0 Application, using ADO, I get the following message:
> "Operation is not Allowed when the Object is closed."
> Note: I created the table, so I'm the owner, I should have no problems(?)
> Any ideas?
>
> --
> Rick|||I get an error with the debugger.
Rick
"Yosh" wrote:

> Rick,
> Can you send your vb code where you open the ADO connection, execute the
> stored proc, and then close the connection?
> Thanks,
> Yosh
> "Rick" <Rick@.discussions.microsoft.com> wrote in message
> news:131F18F8-146E-410F-8E84-2610E2871512@.microsoft.com...
>
>