RE: Trouble with SQL Adapter Metadata Wizard in BizTalk Server 2006

Erik - I'm actually having the exact same problem at the moment. The only
exception is that I'm using a stored procedure. I expect that the issue has
something to do with the Adapter not generating the proper SQL statements
with regards to the default database
The first suspicious behavior is setting the connect string. I'm using a
local SQL server 2005 bit when I put a . (dot) or (local) I gent an internal
error about enumerating he servers. However when I type the SQL Server name
in, it works fine and then I can select the default database. Funny.

Then I continue and run into the same behavior you see, I get to the end
expecting to see the schema and orchestrations and noting happens.

I suspect the default database because when I take the generated SQL
statment out of the wizard and try to run it directly in SQL query I get an
error that the stored procedure does not exisit. I also notivce that the dbo
is snot prepended to the name that gets generated.

I have worked with the SQL adapter for another customer and not seen this so
I suspect it is an install thing.

Let's keep in touch on this one and see if we can't figure it out.

--
Michael Krok
President
Mallard Solutions LLC
Microsoft Certified Partner


"Erik" wrote:

Hi all,

I'm getting in trouble with SQL Adapter Metadata Wizard in BizTalk 2006.
When I click next on Statement Information screen, the Wizard closes without
any warning or error message and without generating anything,

I do all the steps in the same way like in BizTalk article "Working With
BizTalk Adapter for SQL Server"
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp):

- Add Generated Items / Add Adapter Metadata
- Select SQL; Specify BizTalk server name and database BizTalkMgmtDb
(defaults!)
- Specify the connection string to SQL server; Test connection - succeeded;
Next
- Write target namespace ; Chose Port Type Send Port ; Write document root
element name; Next
- Choose Statement Type 'Updategram'; Next
- Seleting Type 'Insert'; Chosing database

After I chosed the database the Wizard closes without generating anything or
giving any warning or error message.

My database is quite simple, having only serval colums of type int or
nvarchar(max), a primary key 'ID' that has type int and is an identifying
colum.

Another table in this database works fine with the wizards and is quite
similar to the one which cause the trouble.

My BizTalk Server 2006 runs on Windows server 2003 Standard Edition SP1, and
uses MS SQL Server 2005.

Any help urgently appreciated and urgently needed.
Thanks and Regards

Erik
.

Loading