| Author |
Different BizTalk Adapter for SQL Problem
|
|
| Alasdair Russell 2004-02-08, 8:41 am |
| I now have BizTalk 2002 and SQL Server 2000 on a different
Server and have again installed the Adapter for SQL on
this. In this system when I attempt to create a receive
function I get the error:
"The system cannot find the file specified."
This happens when selecting NEXT from the SQL Script - Set
Database Task page. When it should run the
script/procedure (I've tried both) and read the XML Schema.
In this case it does progress to the next page of the
wizard (Generate XML Schema). However there is no Schema
in the text box and it cannot save so will not progress
beyond this page.
Any suggestions as to how I might try to resolve this?
Alasdair Russell
| |
| Roger Jerrell 2004-02-08, 8:41 am |
| Do you have SQL Xml SP2 or better installed on the Biztalk Server?
Roger Jerrell
"Alasdair Russell" <BizTalkSupport@cybscape.demon.co.uk> wrote in message
news:0a0b01c3da8b$23b994e0$a301280a@phx.gbl...
> I now have BizTalk 2002 and SQL Server 2000 on a different
> Server and have again installed the Adapter for SQL on
> this. In this system when I attempt to create a receive
> function I get the error:
>
> "The system cannot find the file specified."
>
> This happens when selecting NEXT from the SQL Script - Set
> Database Task page. When it should run the
> script/procedure (I've tried both) and read the XML Schema.
>
> In this case it does progress to the next page of the
> wizard (Generate XML Schema). However there is no Schema
> in the text box and it cannot save so will not progress
> beyond this page.
>
> Any suggestions as to how I might try to resolve this?
>
> Alasdair Russell
| |
| Everett Yang 2004-02-08, 8:41 am |
| What is the SQL statement you are using with the receive function?
Sincerely,
Everett Yang
DSI - Microsoft BizTalk Server
This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
| |
| newsgroup user 2004-02-08, 8:41 am |
|
I installed SQL XML v3 sp1 as this is the listed requirement. Should I upgrade to sp2?
----- Roger Jerrell wrote: -----
Do you have SQL Xml SP2 or better installed on the Biztalk Server?
Roger Jerrell
"Alasdair Russell" <BizTalkSupport@cybscape.demon.co.uk> wrote in message
news:0a0b01c3da8b$23b994e0$a301280a@phx.gbl...[color=blue]
> I now have BizTalk 2002 and SQL Server 2000 on a different
> Server and have again installed the Adapter for SQL on
> this. In this system when I attempt to create a receive
> function I get the error:
> Database Task page. When it should run the
> script/procedure (I've tried both) and read the XML Schema.
> wizard (Generate XML Schema). However there is no Schema
> in the text box and it cannot save so will not progress
> beyond this page.
| |
| newsgroup user 2004-02-08, 8:41 am |
|
I originally tried a stored procedure (containing a simple select from a standard table), but did switch this to the same select statement in the wizard itself. When using the stored procedure I did add "FOR XML AUTO, XMLDATA" to the bottom of the select
statement. I always got the same error.
It's just occurred to me. Could this be some kind of missing write permission on temporary directory problem? I'm not sure how to test this though.
Alasdair Russell
----- Everett Yang wrote: -----
What is the SQL statement you are using with the receive function?
Sincerely,
Everett Yang
DSI - Microsoft BizTalk Server
This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
| |
| Everett Yang 2004-02-08, 8:42 am |
| Does this fail for every select statement? Does the tutorial work for SQL
Adapter? What is the SQL service pack level and MDAC version?
Sincerely,
Everett Yang
DSI - Microsoft BizTalk Server
This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
|
|
|
|