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:sybaseinisql.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

asked 01 Jul '11, 04:43

Arun%20Lekshman's gravatar image

Arun Lekshman
15111
accept rate: 0%

edited 15 Mar '13, 17:14

Mark%20Culp's gravatar image

Mark Culp
22.6k9129265

Please note, this is a forum on Sybase SQL Anywhere, not Sybase ASE, which is a different database product.

I would suggest to have a look at on one of Sybase's ASE newsgroups - see http://www.sybase.com/detail?id=1012843.

(01 Jul '11, 06:39) Volker Barth
Replies hidden
2

Part of the problem might be that "SQL Anywhere" doesn't look like a brand name. Perhaps it should always appear as "SQL Anywhere (tm)"... I am seriously thinking about doing that on my blog... even though I put "YES, "SQL ANYWHERE" IS AN ACTUAL PRODUCT" in the title box, folks still get confused. One even thought it was about MySQL.

(01 Jul '11, 13:53) Breck Carter
2

... what the heck, the blog is now called SQL Anywhere® ...I hope I don't get in trouble with SAP legal :)

(01 Jul '11, 14:02) Breck Carter

The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 01 Jul '11, 18:52

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×48
×20

question asked: 01 Jul '11, 04:43

question was seen: 1,355 times

last updated: 15 Mar '13, 17:14