BizTalk Server Applications Integration - Use SQL Adapter with MSDE and Express?

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > February 2006 > Use SQL Adapter with MSDE and Express?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Use SQL Adapter with MSDE and Express?
Jan Eliasen

2006-02-21, 7:47 am

Hi

I am using BizTalk 2004.

Can I use the SQL Adapter with MSDE 2000 and SQL Server 2005 Express
edition? Are there any limitations I should be aware of? Can I run
queries, run stored procedures, use updategrams, etc.?

Thanks in advance!

--
Eliasen Jr. representing himself and not the company he works for.

Private email: jan@eliasen.dk
WenJun Zhang[msft]

2006-02-22, 2:47 am

Hi Jan,

As I know, SQL adapter can communicate with MSDE and SQL2005 Express with
no problem. The main limitation of these 2 versions are on database size
and concurrent connection volume, which doesn't impact BizTalk usage.

Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no rights.



Jan Eliasen

2006-02-22, 2:47 am

On Wed, 22 Feb 2006 06:22:40 GMT, wjzhang@online.microsoft.com
("WenJun Zhang[msft]") wrote:

>As I know, SQL adapter can communicate with MSDE and SQL2005 Express with
>no problem. The main limitation of these 2 versions are on database size
>and concurrent connection volume, which doesn't impact BizTalk usage.

Thanks.

Is it supported, or will it just run?

--
Eliasen Jr. representing himself and not the company he works for.

Private email: jan@eliasen.dk

"Ford," he said, "you're turning into a penguin. Stop it."
WenJun Zhang[msft]

2006-02-23, 7:51 am

Jan,

Yes, using BizTalk 2004 SQL Adapter with MSDE or SQL 2005 Express is
supported. Let me know if you have further question. Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no rights.



Jan Eliasen

2006-02-23, 7:51 am

On Thu, 23 Feb 2006 09:51:10 GMT, wjzhang@online.microsoft.com
("WenJun Zhang[msft]") wrote:

>Yes, using BizTalk 2004 SQL Adapter with MSDE or SQL 2005 Express is
>supported. Let me know if you have further question. Thanks.

Hi

No further questions... for now :-)

Thanks for your answers!

--
Eliasen Jr. representing himself and not the company he works for.

Private email: jan@eliasen.dk

"Ford," he said, "you're turning into a penguin. Stop it."
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com