Solved

Activex Compoenets cannot be created : SAP.Functions

Posted on 2009-05-18
1
2,827 Views
Last Modified: 2013-12-08
HI
I am working on one VB script where i have to get data from SAP RFC Function.
Here is my code to test the SAP connection....i get the following error whenever i try to run the beloe program. Can anyone tell me the DLL's i need to have inorder to test my SAP connection .
Note: I dont have SAP GUI in system, but i want to connect to SAP.
Public theFunc
Public con
Public sapObj
Dim returnFunc

Set sapObj = CreateObject("SAP.Functions")
Set sapConnection = CreateObject("SAP.Logoncontrol.1")
Set sapConnection = sapConnection.NewConnection

sapConnection.System = "00"
sapConnection.ApplicationServer = "xx.xx.xx.xxx"
sapConnection.client = 300
sapConnection.user = "TMRAHIL"
sapConnection.Password = "ENGLAND1"
sapConnection.language = "EN"

'**************************************
'Log On to the SAP System
'**************************************
Set functionCtrl = server.CreateObject("SAP.Functions")
retcd=sapConnection.Logon(0,true)
If RetCd = False Then
Response.write "SAP Logon Failed."
Response.End
else
Response.write "SAP Logon Succeeded."
end if

Thank You so much!!!

0
Comment
Question by:keerthimothukuri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 39

Accepted Solution

by:
abel earned 500 total points
ID: 24419705
What you need is the wdtfuncs.ocx. It comes with the SAP frontend, I understand from posts on the internet. That means that you at least need to buy/download/install the SAP frontend for this to work.

This post is about how to set some references
This post gives some examples
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month3 days, 15 hours left to enroll

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question