topic Linking with VB in Application Development and Automation Discussions

Linking with VB

Former Member — Fri, 26 Dec 2008 04:18:59 GMT

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

Re: Linking with VB

Former Member — Fri, 26 Dec 2008 09:48:14 GMT

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.

Re: Linking with VB

Former Member — Fri, 26 Dec 2008 10:32:01 GMT

could u explain it briefly

Devalla T Kr

Re: Linking with VB

Former Member — Fri, 26 Dec 2008 10:58:34 GMT

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

Re: Linking with VB

Former Member — Wed, 14 Jan 2009 11:03:55 GMT

answered

thanks to all