Database type not supported Error

[kennedy_shabola]

Hi, Experts 

I have  developed a VB.net  Application      currently  on Debug mode X86      i have 

• Added   sapbobsCOM.dll  located in this location C:\Program Files (x86)\SAP\SAP Business One DI API\DI API 90
• I have  a Business  one  Client   that is able   to  connect   to   HANA  server  Databases  sucessfully
• I  have  installed   both    32 bit and 64 bit   Hana  Database Client ( the   one for  Drivers   JDBC,  ODBC,etc)

Below  is   code  on Button click  Event 

       vCompany = New SAPbobsCOM.Company

        vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_HANADB

        vCompany.Server = Trim(Me.txtserver.Text)

        vCompany.LicenseServer = Trim(Me.txtlicenseserver.Text)   ' on the  textboxes   SERVERNAME:30015

        vCompany.UserName = Trim(Me.txtusername.Text)       ' on the  textboxes   SAPB1USERNAME

        vCompany.Password = Trim(Me.txtpassword.Text)         ' on the  textboxes   SAPB1PASSWORD

        vCompany.CompanyDB = Trim(Me.txtcompany.Text)     ' on the  textboxes   SAPBONEDATABASE

        vCompany.language = SAPbobsCOM.BoSuppLangs.ln_English

        vCompany.DbUserName = Trim(Me.txtsaphanausername.Text)      ' on the  textboxes   SAPHANAUSERNAME

        vCompany.DbPassword = Trim(Me.txtsaphanapassword.Text)    ' on the  textboxes   SAPHANAPASSWORD

        vCompany.UseTrusted = False

        If (0 = vCompany.Connect()) Then

            MsgBox("success")

        Else

            Dim errcode As Long

            Dim erMsg As String

            vCompany.GetLastError(errcode, erMsg)

            MsgBox(erMsg)

        End If

Note:  My  Hana   DB  version  is   - revision 85.3  and  SApB1 9.1 PL 08

Kindly Help

[kennedy_shabola]

Hi Atila,

I was using   SAPBOBSCOM.dll  9.0  (X64 bit )  found  under  C:\Program Files   and   not  C:\Program Files\SAP\SAP Business One DI API\DI API 90       my   Comp windows  operating  system is  64 bit   the Correct  version . It will  be   good   to Remind   guys  that  this  is an external VB.NET  application   and   not  an  .ARD addon .   I    finally changed  the Debug   Mode to  AnyCPU  and  compiled   it  and  it succesfully  connected  to SAP HANA Database 

[former_member183373]

Hi Kennedy,

Only reason I can think of is that you are using one of the older "SAPbobsCOM.dll" versions which doesn't have an index for HANA in the BoDataServerTypes list. Make sure the ".dll" you are adding to your project is one of the later versions. I don't remember when they added HANA but later than 8.8 should be okay.

Kind Regards,

Atilla