Hello there,

I've got a development station with Biztalk 2004 and SQL Server 2000 on it a
nd when i want to generate a schema for a SQL stored procedure in the local 
database i don't get problems but when i want to generate a schema for a SQL
 stored procedure on a remo
te server (Windows 2000 with SQL server 2000) i get this message 'Failed to 
execute SQL Statement. Please ensure that the supplied syntax is correct. De
 transactie is al impliciet of expliciet doorgevoerd of afgebroken'. The las
t line is in dutch but it m
eans something like 'The transaction is already implicitly or explicitly app
lied or terminated'. I'm 100% sure the SQL is correct. The connection is tes
ted by Biztalk itself so it should be good???...what's wrong? This biztalk e
rror message (like a lot of
them) ain't telling me nothing to help me solve this problem.

What going on...and how can i solve this?

Thanks in advance.

Greetings Erik

[ Post a follow-up to this message ]

Hi Helios, I had problem like this before and I fix it by installing a SQL S
erver 2000 update… The path is

http://support.microsoft.com/?kbid=838166

Hope it will be helpfully

Regards

"Helios" wrote:

> Hello there,
>
> I've got a development station with Biztalk 2004 and SQL Server 2000 on it and whe
n i want to generate a schema for a SQL stored procedure in the local database i don
't get problems but when i want to generate a schema for a SQL stored procedure on a
 re
mote server (Windows 2000 with SQL server 2000) i get this message 'Failed t
o execute SQL Statement. Please ensure that the supplied syntax is correct. 
De transactie is al impliciet of expliciet doorgevoerd of afgebroken'. The l
ast line is in dutch but it
means something like 'The transaction is already implicitly or explicitly ap
plied or terminated'. I'm 100% sure the SQL is correct. The connection is te
sted by Biztalk itself so it should be good???...what's wrong? This biztalk 
error message (like a lot
of them) ain't telling me nothing to help me solve this problem.
>
> What going on...and how can i solve this?
>
> Thanks in advance.
>
> Greetings Erik

[ Post a follow-up to this message ]

Hello x5,

I applied the update to the SQL server but nothing changed. Note that the pr
oblem is not the database that BizTalk is installed to (BizTalk is running f
ine on my local machine) but the problem is another (remote) SQL server that
's used as a datastore from
which i wish to generate schema's for stored procedures for.

Thanks anyway,

Erik


"x5" wrote:
[vbcol=seagreen]
> Hi Helios, I had problem like this before and I fix it by installing a SQL
 Server 2000 update… The path is
>
> http://support.microsoft.com/?kbid=838166
>
> Hope it will be helpfully
>
> Regards
>
> "Helios" wrote:
> 
remote server (Windows 2000 with SQL server 2000) i get this message 'Failed
 to execute SQL Statement. Please ensure that the supplied syntax is correct
. De transactie is al impliciet of expliciet doorgevoerd of afgebroken'. The
 last line is in dutch but
it means something like 'The transaction is already implicitly or explicitly
 applied or terminated'. I'm 100% sure the SQL is correct. The connection is
 tested by Biztalk itself so it should be good???...what's wrong? This bizta
lk error message (like a lo
t of them) ain't telling me nothing to help me solve this problem.[vbcol=seagreen] 

[ Post a follow-up to this message ]

Hello,

This could be a DTC issue. Please make sure the DTC is running and has
network access permissions on both machines. You can do this by running
dcomcnfg and selecting Properties on My Computer. There will be an MSDTC
tab where you can start/stop the service and set the Security Configuration.

Thanks,
Darrin
--------------------[vbcol=seagreen] 
<4B1B0481-DB99-460D-8AAD-2DE835DD87E1@microsoft.com>[vbcol=seagreen] 
problem is not the database that BizTalk is installed to (BizTalk is
running fine on my local machine) but the problem is another (remote) SQL
server that's used as a datastore from which i wish to generate schema's
for stored procedures for.[vbcol=seagreen] 
SQL Server 2000 update… The path is[vbcol=seagreen] 
on it and when i want to generate a schema for a SQL stored procedure in
the local database i don't get problems but when i want to generate a
schema for a SQL stored procedure on a remote server (Windows 2000 with SQL
server 2000) i get this message 'Failed to execute SQL Statement. Please
ensure that the supplied syntax is correct. De transactie is al impliciet
of expliciet doorgevoerd of afgebroken'. The last line is in dutch but it
means something like 'The transaction is already implicitly or explicitly
applied or terminated'. I'm 100% sure the SQL is correct. The connection is
tested by Biztalk itself so it should be good???...what's wrong? This
biztalk error message (like a lot of them) ain't telling me nothing to help
me solve this problem.[vbcol=seagreen] 

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

EBusiness Server Team

[ Post a follow-up to this message ]

Hallo Darrin

DTC is running on both machines. While browsing the internet for more clues 
i found some articles that advised to set the following settings:

select the Network DTC Access checkbox and select the Network Clients checkb
ox.

On my client machine (WXP-prof) in can set these settings but on the SQL Ser
ver (Windows 2000 sp4) i can't find an equivalent to these settings???

Thanks

Erik

Is there a way to test that communications are working between these machine
s?


Network DTC Access

"Darrin Curtis [MSFT]" wrote:

> Hello,
>
> This could be a DTC issue. Please make sure the DTC is running and has
> network access permissions on both machines. You can do this by running
> dcomcnfg and selecting Properties on My Computer. There will be an MSDTC
> tab where you can start/stop the service and set the Security Configuratio
n.
>
> Thanks,
> Darrin
> -------------------- 
> <4B1B0481-DB99-460D-8AAD-2DE835DD87E1@microsoft.com> 
> problem is not the database that BizTalk is installed to (BizTalk is
> running fine on my local machine) but the problem is another (remote) SQL
> server that's used as a datastore from which i wish to generate schema's
> for stored procedures for. 
> SQL Server 2000 update… The path is 
> on it and when i want to generate a schema for a SQL stored procedure in
> the local database i don't get problems but when i want to generate a
> schema for a SQL stored procedure on a remote server (Windows 2000 with SQ
L
> server 2000) i get this message 'Failed to execute SQL Statement. Please
> ensure that the supplied syntax is correct. De transactie is al impliciet
> of expliciet doorgevoerd of afgebroken'. The last line is in dutch but it
> means something like 'The transaction is already implicitly or explicitly
> applied or terminated'. I'm 100% sure the SQL is correct. The connection i
s
> tested by Biztalk itself so it should be good???...what's wrong? This
> biztalk error message (like a lot of them) ain't telling me nothing to hel
p
> me solve this problem. 
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> EBusiness Server Team
>
>

[ Post a follow-up to this message ]