Native SQL

[Former Member]

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.

[Former Member]

Ashok,

Take a look here:

http://help.sap.com/saphelp_nw04/helpdata/en/2b/b7b339ff52ff3fe10000000a11402f/frameset.htm

[Former Member]

Can we see the code - both the connect and the select?

Rob

[Former Member]

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.

[Former Member]

Try a SELECT SINGLE (field list) INTO...

[Former Member]

i AM STILL GETTING THE SHORT DUMP SAYING THAT TABLE DOESN'T EXIST

[Former Member]

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