Hello,

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
Conn.Open
Set myCommand = CreateObject("ADODB.Command")
Set myRS = CreateObject("ADODB.Recordset")

I appreciate if someone can help me in this.

Thanks & Regards,
Arun