RE: Failed to execute SQL Statement
From: Helios (Helios_at_discussions.microsoft.com)
Date: 07/08/04
- Next message: BenW: "RE: Deploying a schema in a separate assembly"
- Previous message: Oscar F: "SQL Adapter distributed transaction"
- In reply to: Darrin Curtis [MSFT]: "RE: Failed to execute SQL Statement"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 8 Jul 2004 03:35:01 -0700
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
> --------------------
> >>Thread-Topic: Failed to execute SQL Statement
> >>thread-index: AcRkGukeq1WRqVcnSxOfsAybDzDe9w==
> >>X-WBNR-Posting-Host: 217.117.230.34
> >>From: =?Utf-8?B?SGVsaW9z?= <Helios@discussions.microsoft.com>
> >>References: <586ED25D-8DF1-4820-885E-D2108B092D81@microsoft.com>
> <4B1B0481-DB99-460D-8AAD-2DE835DD87E1@microsoft.com>
> >>Subject: RE: Failed to execute SQL Statement
> >>Date: Wed, 7 Jul 2004 05:07:01 -0700
> >>Lines: 30
> >>Message-ID: <1C785F64-30E5-44DD-A21B-12B639BA06C3@microsoft.com>
> >>MIME-Version: 1.0
> >>Content-Type: text/plain;
> >> charset="Utf-8"
> >>Content-Transfer-Encoding: 8bit
> >>X-Newsreader: Microsoft CDO for Windows 2000
> >>Content-Class: urn:content-classes:message
> >>Importance: normal
> >>Priority: normal
> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >>Newsgroups: microsoft.public.biztalk.general
> >>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> >>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:16936
> >>X-Tomcat-NG: microsoft.public.biztalk.general
> >>
> >>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:
> >>
> >>> 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 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.
> >>> >
> >>> > What going on...and how can i solve this?
> >>> >
> >>> > Thanks in advance.
> >>> >
> >>> > Greetings Erik
> >>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
>
>
- Next message: BenW: "RE: Deploying a schema in a separate assembly"
- Previous message: Oscar F: "SQL Adapter distributed transaction"
- In reply to: Darrin Curtis [MSFT]: "RE: Failed to execute SQL Statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
