Error in odbc database connection

[Former Member]

Hi All,

I have created database connection from SAP system to another no sap system (Radar) using the tcode DBCO and maintained the following parameters

DB connection: RADAR_DEV

DBMS : MSS

user Name : RADAR_DVLP

Db password : **********

conn info : msql_server=hostname of SQL server msql_dbname=DB name object_source=DB name

It is gives a below short dump when this db connection (DB connection name) is used in a program by ABAPer

error message

The error occurred in the current database connection "RADAR_DEV".

What can you do?

Print out the error message (using the "Print" function)

and make a note of the actions and input that caused the

error.

To resolve the problem, contact your SAP system administrator.

You can use transaction ST22 (ABAP Dump Analysis) to view and administer

termination messages, especially those beyond their normal deletion

date.

Error analysis

An exception occurred. This exception will be dealt with in more detail

below. The exception, assigned to the class 'CX_SY_NATIVE_SQL_ERROR', was not

caught, which

led to a runtime error. The reason for this exception is:

How to correct the error

Database error text........: "Line 1: Incorrect syntax near '.'."

Triggering SQL statement...: "FETCH NEXT "

Internal call code.........: "[DBDS/NEW DSQL]"

Please check the entries in the system log (Transaction SM21).

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

-

---

"DBIF_DSQL2_SQL_ERROR" CX_SY_NATIVE_SQL_ERRORC

"ZRADAR_EXTRACT" or "ZRADAR_EXTRACT"

"START-OF-SELECTION"

-

---

Can you please help me on resolving this issue

Thanks,

Vadi

[Former Member]

Hello Vadivambal,

Could you please provide the syntax of line, on which the dump occurs.

Is user RADAR_DVLP able to fetch same data without an ABAP program?

Regards,

Ammey Kesarkar

[Former Member]

Dear Ammy,

Thanks for the response.

We could resolve this by creating a cursor an SAP side for retrieving the data from radar.

Earlier we are retrieving redirectly from the wrok area which was causing the error.