| Ravi Shankar 2004-05-06, 4:35 am |
| I think you need to provide the provider string in your
connection string "Provider=SQLOLEDB;......."
As an example you could copy the "Transaction" connection
string from the Commerce Server Manager and try the init
with that.
HTH
>-----Original Message-----
>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.OrderGroupManager
FreeThreaded
>oOrderGroupManager = new OrderGroupManagerFreeThreaded();
>
>object oConnSting = connectionString;
>
>oOrderGroupManager.Initialize(ref oConnSting);
>
>I keep getting the error: could not connect to
datasource.
>
>-Randy
>
>
>
>
>
>
>.
>
|