| Randy Jeppesen 2004-05-04, 11:38 am |
| 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
|