Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2011

    Question Unanswered: Problem executing stored procedure


    I am executing a stored procedure in VB Script to export the data from the SP to an excel file. While executing the SP in ASE ISQL gives me exact result but while executing the SP in VBScript returns 0 value for certain columns in the excel file and in the script itself.

    When I checked the SP, it contains many more sub SPs and it seems the fields which are shown as 0 in the excel file are stored in a temporary table.

    My connection string is as follows

    sCon = "driver={SYBASE ASE ODBC Driver};" & _
    "srvr=MyServer;" & _
    "uid=uName;pwd=uPwd; database=" & DBName & "; InterfacesFile=k:\sybase\ini\sql.ini"

    Set Conn = CreateObject("ADODB.Connection")
    Conn.Provider = "MSDASQL.1"
    Conn.ConnectionString = sCon
    Conn.CommandTimeout = 300
    Set myCommand = CreateObject("ADODB.Command")
    Set myRS = CreateObject("ADODB.Recordset")

    I appreciate if someone can help me in this.

    Thanks & Regards,
    Last edited by arunslekshman; 06-28-11 at 06:51. Reason: Changing to apt icon

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts