topic BODataServerType enumeration for MS SQL Server 2019 in Application Development and Automation Discussions

BODataServerType enumeration for MS SQL Server 2019

former_member705539 — Fri, 02 Oct 2020 20:29:11 GMT

Hi,

I have the DI API 10.0 and in the SDK help I do not see the dbtype enumeration for MSSQL 2019 as shown below.

Would appreciate it if anyone helps me to know the dbtype value of MSSQL 2019.

Thank you in advance.

- Bhagyashree

Re: BODataServerType enumeration for MS SQL Server 2019

gustavopy — Fri, 02 Oct 2020 22:27:13 GMT

The documentation is out of date. If you are programming in .net, just press F12 on an instance of 'SAPbobsCOM.BoDataServerTypes' to get the metadata. I would think the value is 12.

Best regards,
Gustavo

Re: BODataServerType enumeration for MS SQL Server 2019

former_member705539 — Fri, 02 Oct 2020 23:51:38 GMT

Hi Gustavo Arriola,

Thank you very much.

Yes, the document seems to be not updated. Its 15.

Thank you.

Regards

- Bhagyashree

Posted onPosted on

Re: BODataServerType enumeration for MS SQL Server 2019

former_member705539 — Fri, 02 Oct 2020 23:56:27 GMT

Above are the values

Re: BODataServerType enumeration for MS SQL Server 2019

former_member705539 — Fri, 02 Oct 2020 23:57:49 GMT

dst_MSSQL = 1, dst_DB_2 = 2, dst_SYBASE = 3, dst_MSSQL2005 = 4, dst_MAXDB = 5, dst_MSSQL2008 = 6, dst_MSSQL2012 = 7, dst_MSSQL2014 = 8, dst_HANADB = 9, dst_MSSQL2016 = 10, dst_MSSQL2017 = 11, dst_MSSQL2019 = 15

Above are different values

Thank you.