Connecting using ASP.net

[Former Member]

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

[Former Member]

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

[Former Member]

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?

[Former Member]

use

oCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2005

or

oCompany.DbServerType = 4

[Former Member]

thanks, but i tried that and i still get the same error