Re: VB6 ADO Sql2000 Extended Stored Procedure

From: Val Mazur (group51a_at_hotmail.com)
Date: 02/25/04

  • Next message: Val Mazur: "Re: Transactions" 
    Date: Tue, 24 Feb 2004 22:13:26 -0500

    Hi,

    Could you post your code? 

    -- 
Val Mazur
Microsoft MVP
"AndyDunning" <andy.dunning@fmg.co.uk> wrote in message 
news:4039f71d$0$7065$ed9e5944@reading.news.pipex.net...
> Folks
>
> I have a SQL 2000 Stored Procedure that uses xp_aes_encrypt and decrypt to
> Insert and return data from a table.
>
> I now wish to call this Stored Procedure from my Vb 6 Client.
>
> I can successfully pass data from my client via an ADODB Connection, 
> append
> the parameters and executes the stored procedure.
>
> However the moment I reference some UDF's and Extended Stored procedures 
> to
> do the encryption the only data that is correctly inserted into my table 
> are
> the fields that are not encrypted. The encrypted fields show all Null
> values.
>
> As far as I can tell no error messages are returned as the insert is 
> infact
> successful.
>
> If I pass in the same data string from Query Analyzer the insert and
> encryption works just fine.
>
> It appears that ADO can't handle calls to extended Stored Procedures. Has
> any one else experienced a similar proble?
>
> Comments /Suggestions welcome
>
> Thanks
>
>
  • Next message: Val Mazur: "Re: Transactions"

    Relevant Pages

    • Re: Security violation by my host
      ... WITH ENCRYPTION ... This will encrypt the SP in the database so if anyone opens it will be ... my stored procedure codes and tables structures. ... skillful SQL Server admin can access what he wants in a DB like this. ...
      (microsoft.public.sqlserver.security)
    • VB6 ADO Sql2000 Extended Stored Procedure
      ... I now wish to call this Stored Procedure from my Vb 6 Client. ... do the encryption the only data that is correctly inserted into my table are ... The encrypted fields show all Null ... It appears that ADO can't handle calls to extended Stored Procedures. ...
      (microsoft.public.vb.database.ado)
    • Some analysis of Microsoft SQL Server 2000 stored procedure encryption
      ... It's well known that the stored procedure encryption in SQL Server ... algorithm used and what its weaknesses are. ... CREATE PROCEDURE bob ...
      (Bugtraq)
    • Re: Questions about WITH ENCRYPTION
      ... There were 3rd party tools available that could decrypt on earlier versions. ... But I think the encryption is stronger on 2k. ... Because it wont work unless you have the clear text of the stored procedure. ...
      (microsoft.public.sqlserver.security)
    • Re: Encryptin stored procedures
      ... Search google for "decrypt SQL stored procedure" ... Specifying WITH ENCRYPTION for ... the script itself is plain text. ... Jasper Smith (SQL Server MVP) ...
      (microsoft.public.sqlserver.security)
    Loading