Hi Harry, and thanks so much for your response.
It confirms what we have seen through our initial investigations.
What we are not clear on is how to progress from here.
Our existing application makes use of an ActiveX (ocx file) which installs along with the SAP client.
I had expected that the .NET Connector 3.0 would also be installed as part of the SAP client.
Do you know if that is the case … or is this a separate installation requirement?
If so, we should be able to obtain it ok through our IT group.
We had found associated files (sapnco.dll and sapnco_utils.dll) on our installations.
So if these are the required files, what we are lacking is the correct method of connecting with SAP.
We have been trying to use our original coding … but I suspect this may not be suitable.
An example of our coding (for obtaining a confirmation balance) is outlined below in case it offers you any insight.
Could we expect this coding to work correctly if the .NET Connector is installed … or is the .NET coding totally different?
The code currently fails at the first hurdle …. Set MyFunc = oBAPICtrl.add(“SAP_transaction_name”)
The code below works fine within our current application.
Any advice you can provide on .NET requirements will be appreciated.
If what we are missing is the .NET Connector 3.0, we will be able to resolve this through our IT group.
Thanks again,
Greg Shearer
Dim oBAPICtrl
Dim MyFunc
Dim CONFIRM_NO
Dim PLANT
Dim RECORD
Dim Results
'logon Parameters Set For SAP.Functions
'*********************************************
$STRUCT_SAP.User = “XXXX”
$STRUCT_SAP.Pass = “XXXX”
$STRUCT_SAP.Client = “XXXX”
$STRUCT_SAP.Lang = “en”
$STRUCT_SAP.System_Id = “XXXX”
$STRUCT_SAP.HostName = “XXXX”
'*********************************************
'Connection Logon
Set oBAPICtrl = CreateObject(“SAP.Functions”)
oBAPICtrl.Connection.Client = $STRUCT_SAP.Client
oBAPICtrl.Connection.User = $STRUCT_SAP.User
oBAPICtrl.Connection.Language = $STRUCT_SAP.Lang
oBAPICtrl.Connection.Password = $STRUCT_SAP.Pass
oBAPICtrl.Connection.Hostname = $STRUCT_SAP.HostName
oBAPICtrl.Connection.Logon 1, True
'**********************************************
$SAP_response = “Logged on OK!!!”
Set MyFunc = oBAPICtrl.add(“SAP_transaction_name”)
Set CONFIRM_NO = MyFunc.exports(“CONFIRM_NO”)
Set PLANT = MyFunc.exports(“PLANT”)
CONFIRM_NO.value = confirmation
PLANT.value = $mach.plant
$Balance.LMNGA = 0
$Balance.WERKS = “”
$Balance.RUECK_1 = “”
$Balance.RUECK_2 = “”
$Balance.MEINH = “”
Set RECORD = MyFunc.Tables(“RECORD”)
Results = MyFunc.Call
If Results <> True Then
$SAP_response = MyFunc.exception
Else
$SAP_response = “Success”
$Balance.LMNGA = RECORD(1,“LMNGA”)
$Balance.WERKS = RECORD(1,“WERKS”)
$Balance.RUECK_1 = RECORD(1,“RUECK_1”)
$Balance.RUECK_2 = RECORD(1,“RUECK_2”)
$Balance.MEINH = RECORD(1,“MEINH”)
$Balance.MATNR = RECORD(1,“MATNR”)
$Balance.MAT_DESCR = RECORD(1,“MAT_DESCR”)
End If
oBAPICtrl.Connection.logoff
Set oBAPICtrl = Nothing