DTS file name to include System Date/Time

We have an application group that wants to pull date from SQL Server and write it to text file on the server. They want the file format to be 12100_YYYMMDDHHMM.fr1 for one set of data, 12100_YYYMMDDHHMM.fr2 for a second set...and so on. The '12100' is fixed, but the rest of the file name will always have to include the system date/time. Is there an easy way to do this within a DTS package (when writing to the output file)?

I would really appreciate help on this. Thank you.Hi

You can set a global variable to the fixed part at the start of the process. This should help http://www.sqldts.com/default.aspx?200 although you want to set a global variable rather than a local one.

John
"steven virnig" <pezguy@.mn.rr.com> wrote in message news:o1ovd.114089$ye4.34831@.twister.rdc-kc.rr.com...
We have an application group that wants to pull date from SQL Server and write it to text file on the server. They want the file format to be 12100_YYYMMDDHHMM.fr1 for one set of data, 12100_YYYMMDDHHMM.fr2 for a second set...and so on. The '12100' is fixed, but the rest of the file name will always have to include the system date/time. Is there an easy way to do this within a DTS package (when writing to the output file)?

I would really appreciate help on this. Thank you.

DTS distribution - LoadLibrary failed - the specified module could not be found

Hi,

i have a VB.net (2005) application that just runs a DTS package. I tried to install my application in a CLEAN XP computer (it means without any SQL2000 tools or DLLs, ONLY the .net framework 2.0).

When i try to register the dtpkg.dll and all the other dlls using regsvr32.exe i receive the error

"LoadLibrary("C:\program files\myapp\dtspkg.dll) failed - the specified module could not be found".

in C:\Windows\system there is the sqlunirl.dll

In C:\program files\myapp folder i have all the following DLLs:

sqlresld.dll

dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll
dtsrun.exe
sqlunirl.dll
custtask.dll

and in C:\program files\myapp\resources\1033 folder the RLLs

dtsffile.rll
dtspkg.rll
dtspump.rll

custtask.rll

axscphst.rll

dtsrun.rll

I followed step by step all the dts redistribution instructions as explained in this article

http://www.sqldts.com/225.aspx

and in the redist.txt contained in the SQL2000 CD.....

Anybody has ideas?

Thx

mcrisf

I am having the same issue. I followed the steps on the site exactly but I still get the "LoadLibrary("C:\program files\myapp\dtspkg.dll) failed - the specified module could not be found". error. Anyone?|||

Copy required .rll files in the binn\resources\1033 folder.

Make sure sqlresld.dll is present in the binn folder.

DTS distribution - LoadLibrary failed - the specified module could not be found

Hi,

i have a VB.net (2005) application that just runs a DTS package. I tried to install my application in a CLEAN XP computer (it means without any SQL2000 tools or DLLs, ONLY the .net framework 2.0).

When i try to register the dtpkg.dll and all the other dlls using regsvr32.exe i receive the error

"LoadLibrary("C:\program files\myapp\dtspkg.dll) failed - the specified module could not be found".

in C:\Windows\system there is the sqlunirl.dll

In C:\program files\myapp folder i have all the following DLLs:

sqlresld.dll

dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll
dtsrun.exe
sqlunirl.dll
custtask.dll

and in C:\program files\myapp\resources\1033 folder the RLLs

dtsffile.rll
dtspkg.rll
dtspump.rll

custtask.rll

axscphst.rll

dtsrun.rll

I followed step by step all the dts redistribution instructions as explained in this article

http://www.sqldts.com/225.aspx

and in the redist.txt contained in the SQL2000 CD.....

Anybody has ideas?

Thx

mcrisf

I am having the same issue. I followed the steps on the site exactly but I still get the "LoadLibrary("C:\program files\myapp\dtspkg.dll) failed - the specified module could not be found". error. Anyone?|||

Copy required .rll files in the binn\resources\1033 folder.

Make sure sqlresld.dll is present in the binn folder.

sql

DTS distribution

i want to distribute the DTS package of microsoft with my application . I have used VB6 as programming platform . But the problem is that i dont know all the dll or other files that need to be copiedvisit this site
www.sqldts.com

DTS deployment issues

Hello!

I'm trying to deploy an application that runs DTS packages from the local machine.

I've read some articles that it would be enough to install the SQL Client Tools on the local machine to make the DTS work . I did this, the package executes a few steps (it shows message boxes and writes data into the database), then (before executing some validation tasks on the data) it throws an exception 'Execution was canceled by user'. I've set the pbCancel flag and the package runs fine on some computers, but on an empty system that only contains my application and the Sql Client Tools I get this exception.

Do I have to install anything else or do I have to make some changes to DTS package to make it work?

Thank you in advance!

this is the wrong forum; Unless your are using SSIS (SQL SERVER 2005).|||sorry, my mistake

DTS And VBScript

I have an application written in C#, which allows the user to load their destination schema (in xml format) and writer their transformation expressions either in VBScript or in T-SQL. It uses DTS to do the ETL job.

Everything works great except with one problem. If there is a hypen ("-") in any of the destination attributes, the transformation fails with syntax error. It happens only with VBScript.

Here is my transformation:

"Function Main()

DTSDestination(\"Field-1\") = #01/01/2004#

End Function"

If I replace the hypen with underscore, it works without any problem.

Does anyone have any idea about this problem?Did you try to put the field name between brackets?
[field-1]|||Tried with \"[Field-1]\" and it did not do the magic|||Perhaps a hyphen is an invalid character for a field name. Use underscores and your problem is solved. You shouldn't be using '-'s in field names, anyway.|||In general hypen ('-'s) are not allowed in a field. But if you enclose in [], it is a valid chr (atleast in SQLServer!).

As my application is a B2B application and schema is maintained by an organization, I don't have any control. Hence I can not modify the field name.

BTW, I tried the same this with Enterprise Manager, it works.

DTS and SQL Server

Is it possible to run Data Transformation Services (DTS) on demand by having a user click on a button in an application with SQl Server?
I am creating a project in vb.net where I want the user to be able to hit an "update" button and data will be updated to my SQL Server table by DTS.

Also is it possible to check for duplicate entries before running DTS? E.g I want to append to my table but exclude duplicate entries UNLESS the data has changed for that entry.>>Is it possible to run Data Transformation Services (DTS) on demand

Yes. http://msdn.microsoft.com/msdnmag/issues/04/01/WebQA/

>>Also is it possible to check for duplicate entries before running DTS

Make this a step in your dts package

DTS and process task - doesnt wait my called exe application finish completely

Hi,

I need to execute a DTS that have a couple of steps and one of them is a process task that simply call an exe file i made that will send an email to warn the user.

What happens here is that the process task executes my exe file but it doesn't wait for it to compete and fires the next task after and finally closes.

There is anyway to make a "while statament" to wait until my exe application finishes?

Any idea?

Thanks in advance,
Tiago TeixeiraI Don't think there is a way to reply to SQL that an executable that it started has now stopped running.

Shame your not using the SQL email service but your prob doing other things as well.

Do you have any contriol over the .exe source code ?

Idea 1. it could possibly create a file in Dos then delete it as a last action before ending. TSQL would then loop (possibly with a while loop) to check if the file still exists notifying you that the .exe has done it's job.

GW|||Why not connect your steps with "On success" workflow/execution paths?
Also, why are you calling another application to send an e-mail when the DTS package designer can send e-mails for you? :D|||I Don't think there is a way to reply to SQL that an executable that it started has now stopped running.

Shame your not using the SQL email service but your prob doing other things as well.

Do you have any contriol over the .exe source code ?

Idea 1. it could possibly create a file in Dos then delete it as a last action before ending. TSQL would then loop (possibly with a while loop) to check if the file still exists notifying you that the .exe has done it's job.

GW

Hi,

Thanks for the help.

I don't use SQL email service because i don't have a MAPI server available to do it, and i don't want create it in IIS just for this purpose.
I found a free dll extension around that sends email without a MAPI account but, the problem is that the DTS aim is export data to excel file and after send this excel file by email, the problem is that when i send the email ( using that dll) an error occurs because the excel file still locked by the precedent task, so i created myself an exe file that frees the xls file and send the email using a .NET library instead of the dll i said, but the erro i reported appears.

About your second idea, can you please be more specific or paste a code snippet abou how to do that Loop. I would appreciate very much.

Thanks in adavance,
Tiago Teixeira|||Hi Teix

I was basically just thinking of something like this


DECLARE @.cnt int
WHILE(@.cnt <= 5)
BEGIN
DECLARE @.result int
EXEC @.result =xp_cmdshell'del Myfile.exe'
IF(@.result = 0)
PRINT'Success'
ELSE
PRINT'Failure'
WAITFORDELAY'00:15'
SET @.cnt = @.Cnt +1
END


Not sure how wise this approach is though

Good Luck

GW|||Hi GWilliy,

I found a way to manage it without code, i tried the code snippet you generously wrote but application behaved in the same way as before.

So, i created by hand a schedule job and inspite of make a single DTS package that would make all the stuff i needed i sliced the main job in 3 parts and i added each one sequentially to the Job and after that all the steps were accomplished correctly and i got the stuff working.

Thanks all for the precious help and ideas,
Best regards,
Tiago Teixeira|||Try windows handler dll, I think every exe program has unique windows handler id, use this id in a loop... Just an Idea...|||thanks i'll investigate that later, but from now i think i've the job done.

thanks
Tiago Teixeira|||Poison Ref Try windows handler dll, how would you access this from TSQL ?

may be handy for future ref

Teix - Glad U got sorted

GW

DTS + .net code

Hi,
My web application take data from excel sheet and store in the
database using dts. it is working fine when i run directly dts package
on sql server 2000 but i call sp ( exec master..xp_cmdshell 'dtsrun /S
/N /E ' ) from dot net code then it gives error
"A severe error occurred on the current command. The results, if any,
should be discarded "
*** Sent via Developersdex http://www.codecomments.com ***Have you tried running the command using Query Analyzer? If that works, try
adding 'no_output' to the statement executed by the application:
exec master..xp_cmdshell 'dtsrun /S /N MyPackage /E', no_output
Hope this helps.
Dan Guzman
SQL Server MVP
"Pooja Sharma" <pooja.sharma@.siliconbiztech.com> wrote in message
news:%23zgue0RSHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Hi,
> My web application take data from excel sheet and store in the
> database using dts. it is working fine when i run directly dts package
> on sql server 2000 but i call sp ( exec master..xp_cmdshell 'dtsrun /S
> /N /E ' ) from dot net code then it gives error
> "A severe error occurred on the current command. The results, if any,
> should be discarded "
>
> *** Sent via Developersdex http://www.codecomments.com ***

DTS (Oracle to SQL Server 2000)

I am trying to convert an application database from Oracle to SQL Server 2000. I am using Data Transformation Services utility provided by SQL Server. I am converting data on table-by-table basis. However, whenever I convert DATE fields (form Oracle) into DATETIME fields (to SQL Server 2000), my tasks fails. Does anyone knows the reason and, more important, a solution to this problem ?Hi

I'm also working with an Oracle Database.

In my configuration it works.
I used a Transform data task and the transformation I used is a copy column.

So

Oracle:
numeric/field1, datetime/field2 >> source in Transform data task

SQL Server 2000:
numeric/field1, datetime/field2 >> destination in Transform data task

Transformations: let SQL Server do automapping, copy column.

Greetings
Jon@.s

DTS & .NET

I have a simple DTS package that is being executed within a .Net application using the MS DTSPackage Object Library. Since I have the SQL Server 2000 desktop tools installed, the package executes with no problems, however, when another user tries to execute it, the following exception is thrown:

Retrieving the COM class factory for component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154

I've tried including all the DTS references, rather than just the Package object reference, and that didn't help.

Thanks in advance for your help. THis is really frustrating.

Hi toneho,

are you using PackageEvents interface?

Can you provide us a sample?

|||0x80040154 is 'class not registered', i.e. DTS is not installed on this machine.
Solution - you need to install it :)

P.S. This is SSIS forum, not DTS.|||

It is my understanding that the DTS forum was changed to the SSIS forum.

So I included the DTS packageobject interop in my application - what more needs to be done to install DTS?

|||

toneho wrote:

It is my understanding that the DTS forum was changed to the SSIS forum.

So I included the DTS packageobject interop in my application - what more needs to be done to install DTS?

Try: http://groups.google.com/group/microsoft.public.sqlserver.dts/topics?lnk=srg|||Interop is just that - interop, that allows you to talk to COM object from .NET code. You need the actual COM object installed - e.g. install DTS from SQL 2000 CD :)

DTS - Invalid Interface String

Hello,
i'm writing an application (using Delphi 7) in which i must use a DTS to
export data from a MSSQLServer database to a Paradox one. I made it up on a
machine where i can have it working properly, but when i try to use the same
application on another computer i get an "invalid interface string" error
right when the DTS is called
Working machine has SQLServer and Delphi 7 installed running on WinXP Pro
SP2, not working machine has only same OS installed. Note that that one is
the only error i get trying to access data that are on a remote server, i
can use properly every table but not using DTS.
Any suggestions on what i forgot?
Tia
Mario
This might help
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?6,105,225,0,1
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mario Cappa" <mario[dot]cappa@.arcott.it> wrote in message
news:uQs5MDA7EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hello,
> i'm writing an application (using Delphi 7) in which i must use a DTS to
> export data from a MSSQLServer database to a Paradox one. I made it up on
> a machine where i can have it working properly, but when i try to use the
> same application on another computer i get an "invalid interface string"
> error right when the DTS is called
> Working machine has SQLServer and Delphi 7 installed running on WinXP Pro
> SP2, not working machine has only same OS installed. Note that that one is
> the only error i get trying to access data that are on a remote server, i
> can use properly every table but not using DTS.
> Any suggestions on what i forgot?
> Tia
> Mario
>

DTS - Dr Watson Error

I had an error crop up with a DTS package which I need some help with.

Error Message :

The application, , generated an application error The error occurred
on 07/20/2004 @. 06:12:28.203 The exception generated was c0000005 at
address 41504E2C (<nosymbols>)

This happened this morning, but the DTS package runs every 10 minutes
and it is the only occurance of this error. Nothing in the DTS package
has changed and there will not have been any users on the network. I'm
as convinced as I can be that the DTS package is fine. Nothing obvious
as to what has caused the error, and it hasn't happened again, but I
would like to understand it more if possible.

The closest answer we found was for a SQL2000 error (
http://support.microsoft.com/defaul...en-us%3BQ290644 ),
but we are running SQL7 (latest sp), so any fix wouldn't apply.

The DTS package does a fair amount of importing data and then various
SP's are run to generate a final table of data. From the timing, it
looks to have happened at the end of the process, so would suggest
something with an SP. Unfortunately, I cannot tell which one. 10
minutes after it failed, it worked again and has since, but no-one was
in to correct anything.

Any ideas ?

Thanks

RyanOn further investigation, it looks to have got to right at the end of
the DTS package and then failed. The second to last task outputs a
date / time value along with a record count, which has worked. After
that is a bit of code to dump the transaction log and the scheduled
task should e-mail if it fails. I'm wondering if an exchange server
problem has caused this ? We do have a few issues with Exchange, but
these should have been sorted.

Is this a likely explanation ?

DTExec stops running without error message

For a client i have built an application to give them the possibility to load packages for their data warehouse.

This application starts a database job in SQL Server, which in turn starts a dtsx package. This package loops over the contents of a table and starts the packages that are marked to be executed.

This all work well most of the time. Sometimes though, DTExec, the process running the packages, just stops running. There are no entries in the event viewer or anywhere else.

I run Windows Server 2003 with SQL Server 2005 SE SP1. The packages are run from the filesystem, not the database.

Has anyone encountered the same problem and know a solution? I can't find any info on the internet.

- Matthijs
Do you have package logging turned on? Enable all of the logging events and see if you can catch something that way. Log to a text file or to SQL Server.|||No logging was active. I'll turn it on and see if the problem occurs again. One of the problems is that it stops randomly so it's not easily reproducable.

Thanks for the quick response. I'll post again when it happens again.

- Matthijs
|||The problem occured again. I checked the log and the last thing in there is the OnPostValidate event of one of the script tasks. Again no error in the windows eventlogger and nop apperant reason why it stopped.

There have been some other problems though. It have been brought to my attention that the server on which the process runs has the tendancy to overheat. It gives a message that it will be shut down due to overheating or the loss of cooling and right after that a message that shutdown was cancelled by the administrator.

Because of this it occured to me that the problems might come from damaged memory. I'm going to have the client's IT support department check the systems memory and see where that gets me. Do you think that this is a possiblity? I would say that when memory is damaged it should't effect just one process, but that other processes would suffer from the same damage. This does not seem to be the case however. So it's a longshot but i'll have them check it anyway.

- Matthijs

|||

If the fault is suspected with DTEXEC, package logging may not help, but the console output from DTEEXEC itself may be of use. Ensure you have set the job step log, in teh Advanced tab of the job step. If DTEXEC itself errors I would expect this to capture it.

If a shutdown started and was then cancelled, it could have started to kill off processes? If it is running hot then you could get all sorts of strange corruptions, but they would probably not manifest themselves under normal conditions.

|||The cancelled shutdown scenario has not happened lately. That was mostly last summer. I thought it might be result of the damage done back then. I will enable logging in the job step and wait until it happens again.

- Matthijs

|||There seems to be no logging option in the advanced tab of the job step. In the general tab there is a loggin tab, but i think this just logs the package log entries, just like the package itself does.

DTExec stops running without error message

For a client i have built an application to give them the possibility to load packages for their data warehouse.

This application starts a database job in SQL Server, which in turn starts a dtsx package. This package loops over the contents of a table and starts the packages that are marked to be executed.

This all work well most of the time. Sometimes though, DTExec, the process running the packages, just stops running. There are no entries in the event viewer or anywhere else.

I run Windows Server 2003 with SQL Server 2005 SE SP1. The packages are run from the filesystem, not the database.

Has anyone encountered the same problem and know a solution? I can't find any info on the internet.

- Matthijs
Do you have package logging turned on? Enable all of the logging events and see if you can catch something that way. Log to a text file or to SQL Server.|||No logging was active. I'll turn it on and see if the problem occurs again. One of the problems is that it stops randomly so it's not easily reproducable.

Thanks for the quick response. I'll post again when it happens again.

- Matthijs
|||The problem occured again. I checked the log and the last thing in there is the OnPostValidate event of one of the script tasks. Again no error in the windows eventlogger and nop apperant reason why it stopped.

There have been some other problems though. It have been brought to my attention that the server on which the process runs has the tendancy to overheat. It gives a message that it will be shut down due to overheating or the loss of cooling and right after that a message that shutdown was cancelled by the administrator.

Because of this it occured to me that the problems might come from damaged memory. I'm going to have the client's IT support department check the systems memory and see where that gets me. Do you think that this is a possiblity? I would say that when memory is damaged it should't effect just one process, but that other processes would suffer from the same damage. This does not seem to be the case however. So it's a longshot but i'll have them check it anyway.

- Matthijs

|||

If the fault is suspected with DTEXEC, package logging may not help, but the console output from DTEEXEC itself may be of use. Ensure you have set the job step log, in teh Advanced tab of the job step. If DTEXEC itself errors I would expect this to capture it.

If a shutdown started and was then cancelled, it could have started to kill off processes? If it is running hot then you could get all sorts of strange corruptions, but they would probably not manifest themselves under normal conditions.

|||The cancelled shutdown scenario has not happened lately. That was mostly last summer. I thought it might be result of the damage done back then. I will enable logging in the job step and wait until it happens again.

- Matthijs

|||There seems to be no logging option in the advanced tab of the job step. In the general tab there is a loggin tab, but i think this just logs the package log entries, just like the package itself does.

DTExec stops running without error message

For a client i have built an application to give them the possibility to load packages for their data warehouse.

This application starts a database job in SQL Server, which in turn starts a dtsx package. This package loops over the contents of a table and starts the packages that are marked to be executed.

This all work well most of the time. Sometimes though, DTExec, the process running the packages, just stops running. There are no entries in the event viewer or anywhere else.

I run Windows Server 2003 with SQL Server 2005 SE SP1. The packages are run from the filesystem, not the database.

Has anyone encountered the same problem and know a solution? I can't find any info on the internet.

- Matthijs
Do you have package logging turned on? Enable all of the logging events and see if you can catch something that way. Log to a text file or to SQL Server.|||No logging was active. I'll turn it on and see if the problem occurs again. One of the problems is that it stops randomly so it's not easily reproducable.

Thanks for the quick response. I'll post again when it happens again.

- Matthijs
|||The problem occured again. I checked the log and the last thing in there is the OnPostValidate event of one of the script tasks. Again no error in the windows eventlogger and nop apperant reason why it stopped.

There have been some other problems though. It have been brought to my attention that the server on which the process runs has the tendancy to overheat. It gives a message that it will be shut down due to overheating or the loss of cooling and right after that a message that shutdown was cancelled by the administrator.

Because of this it occured to me that the problems might come from damaged memory. I'm going to have the client's IT support department check the systems memory and see where that gets me. Do you think that this is a possiblity? I would say that when memory is damaged it should't effect just one process, but that other processes would suffer from the same damage. This does not seem to be the case however. So it's a longshot but i'll have them check it anyway.

- Matthijs

|||

If the fault is suspected with DTEXEC, package logging may not help, but the console output from DTEEXEC itself may be of use. Ensure you have set the job step log, in teh Advanced tab of the job step. If DTEXEC itself errors I would expect this to capture it.

If a shutdown started and was then cancelled, it could have started to kill off processes? If it is running hot then you could get all sorts of strange corruptions, but they would probably not manifest themselves under normal conditions.

|||The cancelled shutdown scenario has not happened lately. That was mostly last summer. I thought it might be result of the damage done back then. I will enable logging in the job step and wait until it happens again.

- Matthijs

|||There seems to be no logging option in the advanced tab of the job step. In the general tab there is a loggin tab, but i think this just logs the package log entries, just like the package itself does.

DTEXEC for remote execute

I have a legacy extraction ("E") .NET 1.1 application that is still going to be the driving force for our ETL process. We are going to be utilizing SSIS for "T" and "L". Now, the "E" phase is running on an application server where we have .NET 1.1 framework installed and working. The SSIS packages are running on a separate SQL Server. The problem here is - how do we call the SSIS package and be able to pass in the right parameters from this .NET app that runs on a separate box? We would like to use DTEXEC to call the remote SSIS packages through Integrated Security. The SSIS packages are stored as File System packages.How about calling the SSIS package(s) via a stored procedure?|||Ok, I was wondering if there was a more efficient way of executing the SSIS package from the remote server without having to go via a stored procedure.|||

yosonu wrote:

Ok, I was wondering if there was a more efficient way of executing the SSIS package from the remote server without having to go via a stored procedure.

Search this forum for the two words "dtexec" and "remote."

DTC Problems on SQL 2000/Windows Server 2003

I have an ASP application that is working on IIS 4.0/NT 4.0 and SQL Server 7.0/NT 4.0. The ASP pages are using a package registered in the MTS 2.0 running on the IIS server.

I am starting to move my databases over to a new server running SQL Server 2000 on Windows Server 2003.

When I change the database server name in the connection string on the ASP pages and then attempt to run that page I get:

Microsoft OLE DB Provider for SQL Server error '8004d00a'

New transaction cannot enlist in the specified transaction coordinator.

I have confirmed that the Distributed Transaction Controller is running on my new SQL Server box and I have confirmed that network DTC access is on. If I stop the DTC service on my new SQL Server, the error message indicates that the DTC is not running.

Now I am stuck. Any ideas would be greatly appreciated.

Jeff BanningPlease check out Q329332 for help.

Sarah

DTC Error

Hi all,
I built an ASP.Net application. The asp .net application uses distributed
transactions. I add "Transaction='Required'" for every data processing pages
and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit or
abort the transaction.
When the IIS Server and SQL Server are on the same machine, this is no
problem. But when the
IIS server and SQL server are on different machines, error will occurs and
saying that "DTC can not support remote/network transactions".
How the solve this problem?
Thanks!
Kevin
If you are running Win2K3, DTC is disabled for network access by default.
Check out:
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/default...b;en-us;817064
Good luck.
Anthony Thomas

"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
Hi all,
I built an ASP.Net application. The asp .net application uses distributed
transactions. I add "Transaction='Required'" for every data processing pages
and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit or
abort the transaction.
When the IIS Server and SQL Server are on the same machine, this is no
problem. But when the
IIS server and SQL server are on different machines, error will occurs and
saying that "DTC can not support remote/network transactions".
How the solve this problem?
Thanks!
Kevin
|||Thanks Thomas,
Actually I have already installed Network DTC.
The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
machines belong to different domain. Do I need to setup something?
Thanks
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
> If you are running Win2K3, DTC is disabled for network access by default.
> Check out:
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default...b;en-us;817064
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I built an ASP.Net application. The asp .net application uses distributed
> transactions. I add "Transaction='Required'" for every data processing
> pages
> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
> or
> abort the transaction.
> When the IIS Server and SQL Server are on the same machine, this is no
> problem. But when the
> IIS server and SQL server are on different machines, error will occurs and
> saying that "DTC can not support remote/network transactions".
> How the solve this problem?
> Thanks!
> Kevin
>
|||That little piece of info would have been helpful.
Here is a way to handle non-domain communication.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://www.support.microsoft.com/?kbid=555017&SD=tech
I know I've seen articles on how to set this up between two different
domains, same forest and different forests, but can't find it at the moment.
However, the following may prove useful to you as well,
How To Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/default...b;en-us;306843
Good luck.
Anthony Thomas

"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
Thanks Thomas,
Actually I have already installed Network DTC.
The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
machines belong to different domain. Do I need to setup something?
Thanks
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com>
д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
> If you are running Win2K3, DTC is disabled for network access by default.
> Check out:
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default...b;en-us;817064
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I built an ASP.Net application. The asp .net application uses distributed
> transactions. I add "Transaction='Required'" for every data processing
> pages
> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
> or
> abort the transaction.
> When the IIS Server and SQL Server are on the same machine, this is no
> problem. But when the
> IIS server and SQL server are on different machines, error will occurs and
> saying that "DTC can not support remote/network transactions".
> How the solve this problem?
> Thanks!
> Kevin
>
|||Thomas,
Thanks for your reply, I solved my problems!
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> д?:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.g bl...
> That little piece of info would have been helpful.
> Here is a way to handle non-domain communication.
> HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows
> Server
> 2003
> http://www.support.microsoft.com/?kbid=555017&SD=tech
> I know I've seen articles on how to set this up between two different
> domains, same forest and different forests, but can't find it at the
> moment.
> However, the following may prove useful to you as well,
> How To Troubleshoot MS DTC Firewall Issues
> http://support.microsoft.com/default...b;en-us;306843
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Thanks Thomas,
> Actually I have already installed Network DTC.
> The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
> machines belong to different domain. Do I need to setup something?
> Thanks
> Kevin
>
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
>
|||Want to share. I'm curious how you solved it.
Thanks.
Anthony Thomas

"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:uYQjZDeJFHA.484@.TK2MSFTNGP15.phx.gbl...
Thomas,
Thanks for your reply, I solved my problems!
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com>
д?:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.g bl...
> That little piece of info would have been helpful.
> Here is a way to handle non-domain communication.
> HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows
> Server
> 2003
> http://www.support.microsoft.com/?kbid=555017&SD=tech
> I know I've seen articles on how to set this up between two different
> domains, same forest and different forests, but can't find it at the
> moment.
> However, the following may prove useful to you as well,
> How To Troubleshoot MS DTC Firewall Issues
> http://support.microsoft.com/default...b;en-us;306843
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Thanks Thomas,
> Actually I have already installed Network DTC.
> The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
> machines belong to different domain. Do I need to setup something?
> Thanks
> Kevin
>
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
>
|||Hi Thomas,
I add the following registry values, set the firewall to allow ports form
5000~5020 & 135, and then restart both computers.
Ports : REG_MULTI-SZ : 5000-5020
PortsInternetAvailable : REG_SZ : Y
UseInternetPorts : REG_SZ : Y
These information are all in the articals you have mentioned.
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> д?:O7pSP6jJFHA.3484@.TK2MSFTNGP12.phx.gbl ...
> Want to share. I'm curious how you solved it.
> Thanks.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:uYQjZDeJFHA.484@.TK2MSFTNGP15.phx.gbl...
> Thomas,
> Thanks for your reply, I solved my problems!
>
> Kevin
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> д?:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.g bl...
>

DTC Error

Hi all,
I built an ASP.Net application. The asp .net application uses distributed
transactions. I add "Transaction='Required'" for every data processing pages
and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit or
abort the transaction.
When the IIS Server and SQL Server are on the same machine, this is no
problem. But when the
IIS server and SQL server are on different machines, error will occurs and
saying that "DTC can not support remote/network transactions".
How the solve this problem?
Thanks!
KevinIf you are running Win2K3, DTC is disabled for network access by default.
Check out:
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;817064
Good luck.
Anthony Thomas
"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
Hi all,
I built an ASP.Net application. The asp .net application uses distributed
transactions. I add "Transaction='Required'" for every data processing pages
and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit or
abort the transaction.
When the IIS Server and SQL Server are on the same machine, this is no
problem. But when the
IIS server and SQL server are on different machines, error will occurs and
saying that "DTC can not support remote/network transactions".
How the solve this problem?
Thanks!
Kevin|||Thanks Thomas,
Actually I have already installed Network DTC.
The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
machines belong to different domain. Do I need to setup something?
Thanks
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> дÈëÏûÏ¢ÐÂÎÅ:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl...
> If you are running Win2K3, DTC is disabled for network access by default.
> Check out:
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default.aspx?scid=kb;en-us;817064
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I built an ASP.Net application. The asp .net application uses distributed
> transactions. I add "Transaction='Required'" for every data processing
> pages
> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
> or
> abort the transaction.
> When the IIS Server and SQL Server are on the same machine, this is no
> problem. But when the
> IIS server and SQL server are on different machines, error will occurs and
> saying that "DTC can not support remote/network transactions".
> How the solve this problem?
> Thanks!
> Kevin
>|||That little piece of info would have been helpful.
Here is a way to handle non-domain communication.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://www.support.microsoft.com/?kbid=555017&SD=tech
I know I've seen articles on how to set this up between two different
domains, same forest and different forests, but can't find it at the moment.
However, the following may prove useful to you as well,
How To Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
Good luck.
Anthony Thomas
"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
Thanks Thomas,
Actually I have already installed Network DTC.
The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
machines belong to different domain. Do I need to setup something?
Thanks
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com>
дÈëÏûÏ¢ÐÂÎÅ:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl...
> If you are running Win2K3, DTC is disabled for network access by default.
> Check out:
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default.aspx?scid=kb;en-us;817064
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I built an ASP.Net application. The asp .net application uses distributed
> transactions. I add "Transaction='Required'" for every data processing
> pages
> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
> or
> abort the transaction.
> When the IIS Server and SQL Server are on the same machine, this is no
> problem. But when the
> IIS server and SQL server are on different machines, error will occurs and
> saying that "DTC can not support remote/network transactions".
> How the solve this problem?
> Thanks!
> Kevin
>|||Thomas,
Thanks for your reply, I solved my problems!
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> дÈëÏûÏ¢ÐÂÎÅ:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.gbl...
> That little piece of info would have been helpful.
> Here is a way to handle non-domain communication.
> HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows
> Server
> 2003
> http://www.support.microsoft.com/?kbid=555017&SD=tech
> I know I've seen articles on how to set this up between two different
> domains, same forest and different forests, but can't find it at the
> moment.
> However, the following may prove useful to you as well,
> How To Troubleshoot MS DTC Firewall Issues
> http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Thanks Thomas,
> Actually I have already installed Network DTC.
> The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
> machines belong to different domain. Do I need to setup something?
> Thanks
> Kevin
>
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> дÈëÏûÏ¢ÐÂÎÅ:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl...
>> If you are running Win2K3, DTC is disabled for network access by default.
>> Check out:
>> How to enable network DTC access in Windows Server 2003
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;817064
>> Good luck.
>> Anthony Thomas
>>
>> --
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
>> Hi all,
>> I built an ASP.Net application. The asp .net application uses distributed
>> transactions. I add "Transaction='Required'" for every data processing
>> pages
>> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
>> or
>> abort the transaction.
>> When the IIS Server and SQL Server are on the same machine, this is no
>> problem. But when the
>> IIS server and SQL server are on different machines, error will occurs
>> and
>> saying that "DTC can not support remote/network transactions".
>> How the solve this problem?
>> Thanks!
>> Kevin
>>
>|||Want to share. I'm curious how you solved it.
Thanks.
Anthony Thomas
"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:uYQjZDeJFHA.484@.TK2MSFTNGP15.phx.gbl...
Thomas,
Thanks for your reply, I solved my problems!
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com>
дÈëÏûÏ¢ÐÂÎÅ:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.gbl...
> That little piece of info would have been helpful.
> Here is a way to handle non-domain communication.
> HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows
> Server
> 2003
> http://www.support.microsoft.com/?kbid=555017&SD=tech
> I know I've seen articles on how to set this up between two different
> domains, same forest and different forests, but can't find it at the
> moment.
> However, the following may prove useful to you as well,
> How To Troubleshoot MS DTC Firewall Issues
> http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Thanks Thomas,
> Actually I have already installed Network DTC.
> The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
> machines belong to different domain. Do I need to setup something?
> Thanks
> Kevin
>
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> дÈëÏûÏ¢ÐÂÎÅ:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl...
>> If you are running Win2K3, DTC is disabled for network access by default.
>> Check out:
>> How to enable network DTC access in Windows Server 2003
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;817064
>> Good luck.
>> Anthony Thomas
>>
>> --
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
>> Hi all,
>> I built an ASP.Net application. The asp .net application uses distributed
>> transactions. I add "Transaction='Required'" for every data processing
>> pages
>> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
>> or
>> abort the transaction.
>> When the IIS Server and SQL Server are on the same machine, this is no
>> problem. But when the
>> IIS server and SQL server are on different machines, error will occurs
>> and
>> saying that "DTC can not support remote/network transactions".
>> How the solve this problem?
>> Thanks!
>> Kevin
>>
>|||Hi Thomas,
I add the following registry values, set the firewall to allow ports form
5000~5020 & 135, and then restart both computers.
Ports : REG_MULTI-SZ : 5000-5020
PortsInternetAvailable : REG_SZ : Y
UseInternetPorts : REG_SZ : Y
These information are all in the articals you have mentioned.
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> дÈëÏûÏ¢ÐÂÎÅ:O7pSP6jJFHA.3484@.TK2MSFTNGP12.phx.gbl...
> Want to share. I'm curious how you solved it.
> Thanks.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:uYQjZDeJFHA.484@.TK2MSFTNGP15.phx.gbl...
> Thomas,
> Thanks for your reply, I solved my problems!
>
> Kevin
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> дÈëÏûÏ¢ÐÂÎÅ:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.gbl...
>> That little piece of info would have been helpful.
>> Here is a way to handle non-domain communication.
>> HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows
>> Server
>> 2003
>> http://www.support.microsoft.com/?kbid=555017&SD=tech
>> I know I've seen articles on how to set this up between two different
>> domains, same forest and different forests, but can't find it at the
>> moment.
>> However, the following may prove useful to you as well,
>> How To Troubleshoot MS DTC Firewall Issues
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
>> Good luck.
>> Anthony Thomas
>>
>> --
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
>> Thanks Thomas,
>> Actually I have already installed Network DTC.
>> The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
>> machines belong to different domain. Do I need to setup something?
>> Thanks
>> Kevin
>>
>> "Anthony Thomas" <ALThomas@.kc.rr.com>
>> дÈëÏûÏ¢ÐÂÎÅ:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl...
>> If you are running Win2K3, DTC is disabled for network access by
>> default.
>> Check out:
>> How to enable network DTC access in Windows Server 2003
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;817064
>> Good luck.
>> Anthony Thomas
>>
>> --
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
>> Hi all,
>> I built an ASP.Net application. The asp .net application uses
>> distributed
>> transactions. I add "Transaction='Required'" for every data processing
>> pages
>> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to
>> commit
>> or
>> abort the transaction.
>> When the IIS Server and SQL Server are on the same machine, this is no
>> problem. But when the
>> IIS server and SQL server are on different machines, error will occurs
>> and
>> saying that "DTC can not support remote/network transactions".
>> How the solve this problem?
>> Thanks!
>> Kevin
>>
>>
>