| Author |
Failed to execute SQL Statement
|
|
| Helios 2004-07-09, 3:30 pm |
| Hello there,
I've got a development station with Biztalk 2004 and SQL Server 2000 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 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 last line is in dutch but it m
eans 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.
What going on...and how can i solve this?
Thanks in advance.
Greetings Erik
| |
|
| 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:
> Hello there,
>
> I've got a development station with Biztalk 2004 and SQL Server 2000 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 re
mote 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.
>
> What going on...and how can i solve this?
>
> Thanks in advance.
>
> Greetings Erik
| |
| Helios 2004-07-09, 3:30 pm |
| Hello x5,
I applied the update to the SQL server but nothing changed. Note that the 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.
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 biztalk error message (like a lo
t of them) ain't telling me nothing to help me solve this problem.[vbcol=seagreen]
| |
| Darrin Curtis [MSFT] 2004-07-09, 3:31 pm |
| 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
| |
| Helios 2004-07-09, 3:31 pm |
| 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 checkbox.
On my client machine (WXP-prof) in can set these settings but on the SQL Server (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 machines?
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 Configuration.
>
> 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 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.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
>
>
|
|
|
|