Skip to Content
author's profile photo Former Member
Former Member

Connecting using ASP.net

Hi there,

I know there is sample code which uses vb.net to connect to a SAP DB but I am having trouble connecting using ASP.net. Anyone out there have some sample code for me pleeeeeeeeeez?

Kind regards,

Greeshma

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2009 at 10:09 AM

    I am gettin Error 111 - failed to connect to SBOCommon when i run the following code :-

    Err.Clear

    On Error Resume Next

    Dim oCompany

    Dim lRetCode

    Dim sErrMsg

    SAP_SERVER = "ip"

    SAP_LICENSE = "ip:30000"

    SAP_DB = "dbname" 'company database name

    SAP_DB_U = "username"

    SAP_DB_P = "password"

    SAP_U = "username1" 'user name and passwrd for SAP

    SAP_P = "password1"

    SAP_UT = false

    SAP_DATAPATH = server.mapPath("SavedData/SAP/")

    Set oCompany = Server.CreateObject("SAPbobsCOM.Company")

    oCompany.Server = SAP_SERVER

    oCompany.LicenseServer = SAP_LICENSE

    oCompany.CompanyDB = SAP_DB

    oCompany.UserName = SAP_U

    oCompany.Password = SAP_P

    oCompany.UseTrusted = SAP_UT

    'user name and passwd for a DB user in SAP

    oCompany.DbUserName = SAP_DB_U

    oCompany.DbPassword = SAP_DB_P

    lRetCode = oCompany.Connect

    Please can someone help me?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 07:45 AM

    Dear Greeshma Gulab,

    What the sql server type? is SQL Server 2005?

    Please try to use sa as DbUserName and corresponding sa's password for DbPassword.

    Best Regards

    Jane Jing

    SAP Business One

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.