Hey All,

I built a business component that matches shipments in a SQL table to orders
in the CS system.  My component takes a connection string.  I use that
connection string to access the SQL DB and I want to use the same connection
string to Initialize the OrderGroupManager object.  The OrderGroupManager
does not want to initialize with the connection string that I am passing it.
Can you please tell me the compatible versions of connection strings that it
uses and if there is version that I can use with the SQLHelper and the
OrderGroupManager?
My connstring:

" Server=INTERN1;database=Online_commerce;
USER
ID=sa;pwd=password;pooling=false";

I also tried:

"Data Source=INTERN1;User Id=sa;Password=password;Connect Timeout=30;
network library=dbmssocn;Initial Catalog=Online_commerce;"

//Create a new instance of the PIA OrderGroupManager

Microsoft.CommerceServer.Interop.Orders.OrderGroupManagerFreeThreaded
oOrderGroupManager = new OrderGroupManagerFreeThreaded();

object oConnSting = connectionString;

oOrderGroupManager.Initialize(ref oConnSting);

I keep getting the error: could not connect to datasource.

-Randy

[ Post a follow-up to this message ]