Posted Thu, 22 Oct 2020 22:52:44 GMT by Ryan Cox

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 Thu, 22 Oct 2020 22:55:22 GMT by Ryan Cox

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.