05-18-2006 10:19 PM
Hi abapers.
I've been using a DBCON to a SQL Server DB, i configured the conection in Trx. DBCO and it works just perfect.... however, the DB is being changed to another server, now when i configured this new DB the system can't connect to it. I can access it from the network, from the SQL Server admin tool, everything seems to be just fine, but i can't access it from SAP.
I repeat, the original configuration works perfect, when i change to the other server is when it breaks down.
some ideas what might be the problem?
thanx
Jesus
05-19-2006 9:13 PM
Hi Jesus,
have a look at SAP Note 738371 where you can find the following report to check your connection:
REPORT ZTESTDBCON.
data: DBN(128).
EXEC SQL.
CONNECT TO 'TST'
ENDEXEC.
EXEC SQL.
SET CONNECTION 'TST'
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / 'current database name', DBN.
Best regards,
05-01-2009 8:42 AM
Hi ..
for that wirte 1 small ABAP program
*Native SQL command
EXEC SQL.
set connection 'Connection_string'
ENDEXEC.
IF sy-subrc 0.
EXEC SQL.
connect to 'Connection_string'
ENDEXEC.
ENDIF.
*here use any table and work area to transfer data
EXEC SQL.
SELECT CUST_CODE FROM CUSTOMER_MAP@IMPSCONN
INTO :ZIMPSCTCODE
WHERE SAP_CODE = :IT_IMPS_CUST-CUST_CODE
ENDEXEC.
Salil ....