 Forum main
page
Most
active member
Login page
Register
Log out
Search page
View our event calendar
Add general event such as an upcoming
software release or conference
View all birthdays
Public image gallery
Upload your images in your profile
Profile editing page
Subscription list page
Address book page
Member list page
View the
most active member
User groups listing
Private message page
|
|
Users viewing this topic: none
|
|
Login  | |
|
BizTak server 2006 SQL adapter problem - 23 March 2007
|
|
|
Shreyas
Posts: 26
Score: 0
Joined: 1 November 2006
Status: offline
|
Hi,
I'm trying to use the Adapter Metadata Wizard in Visual Studio 2005, but am
not able to get anything generated. The Wizard closes without any warning and
without generating anything.
I'm doing the following steps:
- Start wizard (Add Generated Items / Add Adapter Metadata)
- Select SQL server Name / BizTalkMgmtDb
- Specify the DataLink connection string; Test connection succeeded; Next
- Target Namespace = http://samplesendport/
- Port Type = Send Port
- Gives names to Request Respond port.
- Select stored procedure from drop down.
- Generate Script
-Ok.
After this step the problem occurs. When I click Next, the dialog gets
frozen for a few seconds and then closes, without any warning and also
without generating anything.
My stored procedure is simple inserting data into single table having field type of ntext, int.
I'm using Visual Studio 2005, BizTalk 2006 and SQL server 2005.
Any ideas how to generate schemas, Orchestartion? Does adapter generate any log to check this out?
Thanks and Regards
|
|
|
|
|
RE: BizTak server 2006 SQL adapter problem - 25 March 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Can you send us a screenshot when yu select the SP?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: BizTak server 2006 SQL adapter problem - 6 April 2007
|
|
|
Jay
Posts: 21
Score: 0
Joined: 16 November 2006
Status: offline
|
Hello Shreyas,
when attempting to create a schema via the stored procedure or update gram try to do it on your local computer instead of connecting to the remote SQL server. Some of the ERP package would not let you connect via the SQL adapter to create schema. But once you have created schema you will be able to use it. Let me know if you need any help on it.
Thank you
Jay
|
|
|
|
|
RE: BizTak server 2006 SQL adapter problem - 17 May 2007
|
|
|
nikeng
Posts: 5
Score: 0
Joined: 10 January 2007
Status: offline
|
Are you using XMLAUTO, XMDDATA tag in your select query which is sending the results back . If not use it and then try generating the schema using SQL server wizard.
|
|
|
|
|
RE: BizTak server 2006 SQL adapter problem - 6 June 2007
|
|
|
Ryan Lee
Posts: 4
Score: 0
Joined: 23 December 2006
Status: offline
|
Shreyas,
I ever encountered the same issue as you, but the same develop environment on anohter computer can generate successfully.
I do not know why, but I think it might be caused by an environment issue.
|
|
|
|
|
RE: BizTak server 2006 SQL adapter problem - 14 June 2007
|
|
|
Shreyas
Posts: 26
Score: 0
Joined: 1 November 2006
Status: offline
|
hi,
i am using xml auto,xmldata in query no problem regarding that
i am not using a remote sql server the sql server is on same server as biztalk development machine
it works fine for biztalk 2004 but not for 2006
|
|
|
|
|
RE: BizTak server 2006 SQL adapter problem - 12 March 2008
|
|
|
d99joper
Posts: 1
Score: 0
Joined: 12 March 2008
Status: offline
|
Hi,
I'm having the same (or similar problem- I can't get to the part where you choose the stored procedure). Did you ever get the problem resolved?
Thanks,
Jonas
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version
Email TopXML