Post reply

sql sqlsever/outlook

  • October 2, 2003 at 2:52 am

    #81219

    Hi!!! Could someone tell me if is posiible to join a sql server database to an outlook application (built by using VBA).

    I need to query a sql db from outlook.

    Thanks

    regards

  • October 2, 2003 at 1:25 pm

    #476858

    Check sp_processmail and xp_readmail from BOL.

  • October 2, 2003 at 3:38 pm

    #476879

    Sure, just add a reference to ADO ("Microsoft ActiveX Data Object 2.x Library") and you're set. If you don't know ADO, then you'll need to learn it, though.

    --Jonathan



    --Jonathan

  • October 3, 2003 at 2:21 am

    #476921

    Try the following:

    

    Dim cmd as ADODB.Command

    Dim rs as ADODB.Recordset

    

    Set cmd = New ADODB.Command

    With cmd

        .ActiveConnection = "Driver={SQL Server};Server=Svr1;Database=db1;Trusted_Connection=Yes"

        .CommandType = adCmdStoredProc

        .CommandText = "uspMySP"

        .Parameters.Append .CreateParameter("@param1", adVarChar, adParamInput, 50, myVal)

        Set rs = .Execute

    That should give you a recordset returned by uspMySP taking a parameter of myVal.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply