User Profile

Collapse

Profile Sidebar

Collapse
Ajaxx
Ajaxx
Last Activity: Jan 29 '10, 10:51 PM
Joined: Jan 8 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ajaxx
    replied to Parametrized ADO Stored Procedure from C++
    in SQL Server
    I don’t know the details of why but I was able to get it working using the following code without a VARIANT instead:
    Code:
    CommandPtr->Parameters->Append(CommandPtr->CreateParameter(_bstr_t("@Email"), ADODB::adVarChar, ADODB::adParamInput, 50, "test@email.com"));
CommandPtr->Parameters->Append(CommandPtr->CreateParameter(_bstr_t("@Password"), ADODB::adVarChar, ADODB::adParamInput, 50, "1
    ...
    See more | Go to post

      Leave a comment:

    • Ajaxx
      replied to Parametrized ADO Stored Procedure from C++
      in C
      I don’t know the details of why but I was able to get it working using the following code without a VARIANT instead:
      Code:
      CommandPtr->Parameters->Append(CommandPtr->CreateParameter(_bstr_t("@Email"), ADODB::adVarChar, ADODB::adParamInput, 50, "test@email.com"));
CommandPtr->Parameters->Append(CommandPtr->CreateParameter(_bstr_t("@Password"), ADODB::adVarChar, ADODB::adParamInput, 50, "1
      ...
      See more | Go to post

        Leave a comment:

      • Ajaxx
        started a topic Parametrized ADO Stored Procedure from C++
        in SQL Server

        Parametrized ADO Stored Procedure from C++

        I posted this in the C++ section but didn’t get any responses so I thought it might be more appropriate here.

        I’m trying to call a stored procedure on my SQL 2008 server with the below code. When I look at the query with the SQL profiler I get the following:
        Code:
        exec GetUserID @Email='test@email.com',@Password='@Email'
        What I expect to get is:
        Code:
        exec GetUserID @Email='test@email.com',@Password='123456'
        ...
        See more | Go to post
        • Ajaxx
          started a topic Parametrized ADO Stored Procedure from C++
          in C

          Parametrized ADO Stored Procedure from C++

          I’m trying to call a stored procedure on my SQL 2008 server with the below code. When I look at the query with the SQL profiler I get the following:

          Code:
          exec GetUserID @Email='test@email.com',@Password='@Email'
          What I expect to get is:

          Code:
          exec GetUserID @Email='test@email.com',@Password='123456'
          Can someone explain what is going on please?

          Code:
          #include "stdafx.h"
          ...
          See more | Go to post
          No activity results to display
          Show More
          Working...