Posted Fri, 23 Oct 2020 02:52:44 GMT by

When connecting to a U2 Universe database (Rocket) through an ADO Net connection, the connection string requires a "ServerType" defined. In this instance, it is 'universe'. However the AdoNetSource cannot connect to the source due to the use of the keyword 'servertype'.

I get the same error when converting a working package to BIML through the 'convert package to BIML' option. When attempting to rebuild the package from the automated BIML script, the same error message occurs with the supported keyword of 'servertype'. 

Any workarounds here? I need to continue to use the ADO Net provider as it is significantly faster than other options. 

Thanks 

Posted Fri, 23 Oct 2020 02:55:22 GMT by

AdoNetConnection for the above ... 

<AdoNetConnection Name="Source" ConnectionString="Server=<server>;User ID=<user>;Database=<database>;ServerType=Universe;" Provider="U2.Data.Client.U2Connection, U2.Data.Client, Version=2.2.2.0, Culture=neutral, PublicKeyToken=<publickeytoken>" />

You must be signed in to post in this forum.