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 |
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.
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.
... what the heck, the blog is now called SQL Anywhere® ...I hope I don't get in trouble with SAP legal :)