01-28-05 10:49 PM
I assume that the connection string works... I'd drop the PS* from the stri
ng since it shouldn't be required for what you're doing. You might also be
explicit and add Integrated Security=false;
Rob
"Matt Nield" <matt@mattnield.com> wrote in message news:%23NL7U2FBFHA.2540@T
K2MSFTNGP09.phx.gbl...
Hi,
I am attempting to create a .Net Windows Application to connect to my Profil
e Service in order to be able to be a bulk import of users from a legacy com
erce solution. I seem to ba having some trouble connecting to the Profile S
erivce itself. The error I receive is as follows:
"Unspecified Error" (From the caught exception)
and
"In BindArgs::OpenDataSrc(), failed initializing data source (-2147467259)"
in the event log raised from "Commerce Server 2002"
The code that I am using references ActiveDSLib, CommerceLib and MSCSUPSLib
from the Commerce Server 2002\Assemblies folder and reads as follows (the li
ne in bold and underline contains the error):
Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass psc = new Mic
rosoft.CommerceServer.Interop.Profiles.ProfileServiceClass();
string connection = "Provider=CSOLEDB;Data Source=MyServer;Initial Catalog=C
S2002StarterSite_Profiles;User Id=sa;Password=*****;PsSchemaCacheSize=1
28;Ps
ObjectAgeoutPeriod=8";
psc.Initialize(connection, "Adventure Works Catalog");
Microsoft.CommerceServer.Interop.Profiles.IProfileObject ipo = psc.CreatePro
file("bob@bob.com", "UserObject");
If anyone can shed some light on this, I would be most grateful.
Regards
Matt Nield
[ Post a follow-up to this message ]
|