ADONetSource - permitted connection string keywords

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 

0

Comments

1 comment
  • 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>" />

    0
    Comment actions Permalink

Please sign in to leave a comment.