12-26-2008 4:18 AM
Hi Friends,
My requirment is as i have to link SAP with VB reason is as users are filling data in only for sale related so next data is updating in VB so any output like paking list or any thing else we need to update the sales data also in VB .
So how can i link these two systems they want some automations also.
please suggest me .
Thanks & Regards,
Devalla Tarun Kumar
12-26-2008 9:48 AM
REPORT ZDBCONN.
INCLUDE Ole2incl.
DATA: Con TYPE Ole2_Object,
Rec TYPE Ole2_Object.
DATA : SQL(1023).
DATA: BEGIN OF SPL OCCURS 0,
VAL(1023),
END OF SPL.
DATA: BEGIN OF I1 OCCURS 0,
F1 TYPE I ,
F2(10),
F3(10),
END OF I1.
data : pemcode type c .
IF Con-Header IS INITIAL OR Con-Handle = -1.
CREATE OBJECT Con 'ADODB.Connection' .
IF NOT Sy-Subrc = 0.
EXIT.
ENDIF.
CREATE OBJECT REC 'ADODB.Recordset' .
IF NOT Sy-Subrc = 0.
EXIT.
ENDIF.
ENDIF.
12-26-2008 10:32 AM
12-26-2008 10:58 AM
Hi,
If you want to access/use activeX components developed in VB through ABAP code then
you can do it by OLE (Object Linking and Embeding) using CREATE OBJECT statement as mentioned by Kripa Jani. For this you should have knowledge of that activeX component.
If your requirement is to call BAPI/RFC from VB code then you should have DCOM Connector or Dot Net Connector for VB6.0 or Dot Net respectively provided by SAP.
Regards,
Vishal
01-14-2009 11:03 AM