Conexión to SQL 2012

[Former Member]

Hello experts.

I have installed the 2012 version of SQL and connect using the DI API, sends me the following error: "Database server type not supported".

The code I use is:

          oCompañia = New SAPbobsCOM.Company

          oCompañia.Server = Me.txtServidor.Text.Trim

          oCompañia.DbServerType = BoDataServerTypes.dst_MSSQL2012

          oCompañia.DbUserName = Me.txtUsuarioBD.Text.Trim

          oCompañia.DbPassword = Me.txtPassBD.Text.Trim

          oCompañia.CompanyDB = Me.txtBase.Text.Trim

          oCompañia.UserName = Me.txtUsuarioSBO.Text

          oCompañia.Password = Me.txtPassSBO.Text.Trim

          oCompañia.UseTrusted = False

          iError = oCompañia.Connect

Will I be missing something else?

Thank you!

Mario.

[former_member201110 · Accepted solution]

Hi Mario,

You don't mention what version and patch of SBO you are running. SBO only supports SQL 2012 from SBO 8.82 patch 11 or SBO 9.0. If you are running an older version then you'll need to upgrade before you can use SQL 2012.

Assuming that you are already running on a valid patch, one possible cause is that the SM_OBS_DLL temp folder still contains an older version of the DI API temp files which is why you are getting the error message. Try deleting the SM_OBS_DLL folder in your Windows profile's temp directory and then restarting the DI API connection.

Kind Regards,

Owen

[Former Member · Accepted solution]

Hi Owen.

Thanks for your reply.

I am sorry for the missing data. I am using SBO 8.82 patch 11. Do I need upgrade my SBO version to SBO 9?

Let me try the thing that you told me and then i will tell you the results.

Thanks again and regards.

Mario.

[Former Member · Accepted solution]

Hi Owen.

Thanks for your help.

I am not having problem anymore.

Mario.