Provider web service won't work with biztalk adapter

[Jesus Salazar]

I have a BizTalk adapter set up to pick up new customers and dump them into a
SQL database via the BizTalk Adapters. However, everytime I create a user, I
get this error on my commerce server! Please help!!! My CSOLEDB connection
string is using a SQL account and not using integrated security but I can't
get it to work either way.

Event Type: Error
Event Source: Commerce Server Web Services
Event Category: None
Event ID: 3
Date: 10/6/2008
Time: 3:57:55 PM
User: N/A
Computer: USATXMDRX34
Description:
An exception occurred in the 'ProfilesWebService' Web service. Exception
details follow:

System.Data.OleDb.OleDbException: Multiple-step OLE DB operation generated
errors. Check each OLE DB status value, if available. No work was done.
at
System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString
constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString
constr, OleDbConnection connection)
at
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at
Microsoft.CommerceServer.Profiles.WebService.ProfilesWebService.get_CsOleDbProvider()
at
Microsoft.CommerceServer.Profiles.WebService.ProfilesWebService.ExecuteSearch(String profileType, XmlElement searchClause, SearchOptions searchOptions)