04-19-2006 5:51 PM
Hi,
I am using Native SQL statements between the commands EXEC SQL and ENDEXEC to access the external MS SQL server.
I get short dump syaing that the table doen't exist.
The table does exist in the database and i am getting short dump.
I am connecting to MS SQL server using DBCON multiconnect.
I am getting the return code of 0 for the statements CONNECT TO and SET CONNECTION.
But I am getting short dump on SELECT statment for a table.
Can anyone help me?
Thanks,
Ashok.
04-19-2006 6:02 PM
Ashok,
Take a look here:
http://help.sap.com/saphelp_nw04/helpdata/en/2b/b7b339ff52ff3fe10000000a11402f/frameset.htm
04-19-2006 6:08 PM
04-19-2006 8:48 PM
Here is the code I am using.
EXEC SQL.
CONNECT TO
ENDEXEC.
EXEC SQL.
SET CONNECTION
ENDEXEC.
EXEC SQL.
SELECT CUSTOMERID, COMPANYNAME into :CID, :CNAME
FROM CUSTOMERS
WHERE CUSTOMERID = :F3
ENDEXEC.
write: / CID, CNAME.
04-19-2006 8:54 PM
04-19-2006 9:06 PM
i AM STILL GETTING THE SHORT DUMP SAYING THAT TABLE DOESN'T EXIST
08-14-2007 5:16 AM
Hi Ashok Narra ,
I am facing the same problem here. If your proble is solved please help me out in this.
EXEC SQL.
CONNECT TO 'AAJ' AS 'V'
ENDEXEC.
EXEC SQL.
SET CONNECTION 'V'
ENDEXEC.
The above statement is not giving any error when i activate it but when i execute it is giving me shortdump error .
I already maintan entries in DBCON table or DBCO t-code
Anees
9886358645