[MSSQLServer] [DTS] How to avoid a DTS Package be reentrant

Hello.
I am designing a DTS package that should not to be executed more than two instances of this package.
Something like "If App.PrevInstance = True Then End" in Visual Basic, but I want to do the similar thing with my DTS Package, so that the same package will not be executed (just quit) in same time.
I'm wondering if I can add an ActiveX step to cope with this, to validate whether the following steps can be controlled to be executed or not.
Thank you in advance,
NokSearch SQLDTS (http://www.sqldts.com) website for any examples.

[Microsoft][ODBC SQL Server Driver]Timeout expired

Hi,
[Microsoft][ODBC SQL Server Driver]Timeout expired
I am getting the above error all the time:
In are old verison of the App it is not working.
The query is updating are table that has varchar(8000) columns and text(16)
columns.
Is there anything I can do to make this run faster. If you run the whole
query in SQL Analyzer it runs in milliseconds, but through the ASP pages that
are updating a record it Timeouts. And it is only happening to this one
table, we have other similar tables that have text and large varchars, that
run in are ASP pages just fine.
Thanks,
MattHi
Whist it is running, run sp_who2
Check for blocked processes
Looks like you have processes blocking each other so eventually the query
times out.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jaffa" <Jaffa@.discussions.microsoft.com> wrote in message
news:EE8F55E6-C237-4262-920D-B0E889DE29CD@.microsoft.com...
> Hi,
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> I am getting the above error all the time:
> In are old verison of the App it is not working.
> The query is updating are table that has varchar(8000) columns and
text(16)
> columns.
> Is there anything I can do to make this run faster. If you run the whole
> query in SQL Analyzer it runs in milliseconds, but through the ASP pages
that
> are updating a record it Timeouts. And it is only happening to this one
> table, we have other similar tables that have text and large varchars,
that
> run in are ASP pages just fine.
> Thanks,
> Matt
>|||Can you post the DDL for the table and exactly how you are updating the row?
--
Andrew J. Kelly SQL MVP
"Jaffa" <Jaffa@.discussions.microsoft.com> wrote in message
news:EE8F55E6-C237-4262-920D-B0E889DE29CD@.microsoft.com...
> Hi,
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> I am getting the above error all the time:
> In are old verison of the App it is not working.
> The query is updating are table that has varchar(8000) columns and
> text(16)
> columns.
> Is there anything I can do to make this run faster. If you run the whole
> query in SQL Analyzer it runs in milliseconds, but through the ASP pages
> that
> are updating a record it Timeouts. And it is only happening to this one
> table, we have other similar tables that have text and large varchars,
> that
> run in are ASP pages just fine.
> Thanks,
> Matt
>

[Microsoft][ODBC SQL Server Driver]Timeout expired

Hi,
[Microsoft][ODBC SQL Server Driver]Timeout expired
I am getting the above error all the time:
In are old verison of the App it is not working.
The query is updating are table that has varchar(8000) columns and text(16)
columns.
Is there anything I can do to make this run faster. If you run the whole
query in SQL Analyzer it runs in milliseconds, but through the ASP pages that
are updating a record it Timeouts. And it is only happening to this one
table, we have other similar tables that have text and large varchars, that
run in are ASP pages just fine.
Thanks,
Matt
Hi
Whist it is running, run sp_who2
Check for blocked processes
Looks like you have processes blocking each other so eventually the query
times out.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jaffa" <Jaffa@.discussions.microsoft.com> wrote in message
news:EE8F55E6-C237-4262-920D-B0E889DE29CD@.microsoft.com...
> Hi,
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> I am getting the above error all the time:
> In are old verison of the App it is not working.
> The query is updating are table that has varchar(8000) columns and
text(16)
> columns.
> Is there anything I can do to make this run faster. If you run the whole
> query in SQL Analyzer it runs in milliseconds, but through the ASP pages
that
> are updating a record it Timeouts. And it is only happening to this one
> table, we have other similar tables that have text and large varchars,
that
> run in are ASP pages just fine.
> Thanks,
> Matt
>
|||Can you post the DDL for the table and exactly how you are updating the row?
Andrew J. Kelly SQL MVP
"Jaffa" <Jaffa@.discussions.microsoft.com> wrote in message
news:EE8F55E6-C237-4262-920D-B0E889DE29CD@.microsoft.com...
> Hi,
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> I am getting the above error all the time:
> In are old verison of the App it is not working.
> The query is updating are table that has varchar(8000) columns and
> text(16)
> columns.
> Is there anything I can do to make this run faster. If you run the whole
> query in SQL Analyzer it runs in milliseconds, but through the ASP pages
> that
> are updating a record it Timeouts. And it is only happening to this one
> table, we have other similar tables that have text and large varchars,
> that
> run in are ASP pages just fine.
> Thanks,
> Matt
>

[DBNETLIB][ConnectionRead (WrapperRead()).]General network error.

I am intermittantly getting this error in a background VB app. It runs
from task scheduler before I get to work. The last 5 days it has failed
every day. The task opens a connection to an MSDE instance, deletes all
rows from two tables and then reloads them from another database. Then
when attempting to delete all rows from a third table it dies. If I
rerun it once I get to work it has no problems. If I schedule the task
to run again right after the problem run, it works fine.
Ideas?
TomLooks like I'll have to reply to my own post.
In my case it appears that the problem was a command which was taking
longer than 30 seconds to complete.
cnEI.Execute "Delete from Empinfo", , adCmdText
I changed the connection command timeout
cnEI.CommandTimeout = 90
and now all is well.
Tom
Tom Wells wrote:
> I am intermittantly getting this error in a background VB app. It runs
> from task scheduler before I get to work. The last 5 days it has failed
> every day. The task opens a connection to an MSDE instance, deletes all
> rows from two tables and then reloads them from another database. Then
> when attempting to delete all rows from a third table it dies. If I
> rerun it once I get to work it has no problems. If I schedule the task
> to run again right after the problem run, it works fine.
> Ideas?
> Tom
>

[DBNetLib] ConnectionOpen error

I have a working SQL Server 2000. I use Citrix to run Terminal Server
Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
same app and the same user, I get
an error as follows:
"[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access
is denied."
As I said , the same App and Same User work fine if I ICA int the box.
THe Only diff is When I RDP into the same box.
An Domain ADMIN will work using both RDP and ICA. Other users will work
in ICA but not RDP.
Anyone have a suggestion where I can look?
jwc
*** Sent via Developersdex http://www.codecomments.com ***
Jim Bob wrote:
> I have a working SQL Server 2000. I use Citrix to run Terminal Server
> Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
> same app and the same user, I get
> an error as follows:
> "[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access
> is denied."
> As I said , the same App and Same User work fine if I ICA int the box.
> THe Only diff is When I RDP into the same box.
> An Domain ADMIN will work using both RDP and ICA. Other users will work
> in ICA but not RDP.
> Anyone have a suggestion where I can look?
> jwc
Are you doing remote desktop with rdp or using rdp inside citrix for a
published App? And whats with ica? remote desktop or directly a
published App?
early guess:
Please check the terminal Server / Citrix Server local users. Maybe the
account you are using exists as a local and a domain user and rdp is
using the local account insead of the domain account.
hth
Gregor Stefka
|||I am using a thin client and the RDP protocol (No Citrix).
It seems to be a permission thing possible with DCOM. Are you familiar
with dcomcnfg and How I can use it to grant the proper permissions?
jwc
*** Sent via Developersdex http://www.codecomments.com ***
|||Jim Bob wrote:
> I am using a thin client and the RDP protocol (No Citrix).
> It seems to be a permission thing possible with DCOM. Are you familiar
> with dcomcnfg and How I can use it to grant the proper permissions?
>
Just start dcomcnfg select the component you want to alter the
permissions for. After that you may need to restart the Service/component.
What kind of application you are using? MS Office? individual software?
hth
Stefka
|||It is an internal app that uses a backend SQL Database. The SQL
Database in on another server
jwc
*** Sent via Developersdex http://www.codecomments.com ***
|||OK I have narrowed it down a bit. If I RDP into the Terminal Server
with a Thin Client, I get the error. If I RDP with the same user on the
Terminal Server console and run the App, it works fine.
What is the difference here?
jwc
*** Sent via Developersdex http://www.codecomments.com ***

[DBNetLib] ConnectionOpen error

I have a working SQL Server 2000. I use Citrix to run Terminal Server
Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
same app and the same user, I get
an error as follows:
"[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access
is denied."
As I said , the same App and Same User work fine if I ICA int the box.
THe Only diff is When I RDP into the same box.
An Domain ADMIN will work using both RDP and ICA. Other users will work
in ICA but not RDP.
Anyone have a suggestion where I can look?
jwc
*** Sent via Developersdex http://www.codecomments.com ***Jim Bob wrote:
> I have a working SQL Server 2000. I use Citrix to run Terminal Server
> Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
> same app and the same user, I get
> an error as follows:
> "[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or acce
ss
> is denied."
> As I said , the same App and Same User work fine if I ICA int the box.
> THe Only diff is When I RDP into the same box.
> An Domain ADMIN will work using both RDP and ICA. Other users will work
> in ICA but not RDP.
> Anyone have a suggestion where I can look?
> jwc
Are you doing remote desktop with rdp or using rdp inside citrix for a
published App? And whats with ica? remote desktop or directly a
published App?
early guess:
Please check the terminal Server / Citrix Server local users. Maybe the
account you are using exists as a local and a domain user and rdp is
using the local account insead of the domain account.
hth
Gregor Stefka|||I am using a thin client and the RDP protocol (No Citrix).
It seems to be a permission thing possible with DCOM. Are you familiar
with dcomcnfg and How I can use it to grant the proper permissions?
jwc
*** Sent via Developersdex http://www.codecomments.com ***|||Jim Bob wrote:
> I am using a thin client and the RDP protocol (No Citrix).
> It seems to be a permission thing possible with DCOM. Are you familiar
> with dcomcnfg and How I can use it to grant the proper permissions?
>
Just start dcomcnfg select the component you want to alter the
permissions for. After that you may need to restart the Service/component.
What kind of application you are using? MS Office? individual software?
hth
Stefka|||It is an internal app that uses a backend SQL Database. The SQL
Database in on another server
jwc
*** Sent via Developersdex http://www.codecomments.com ***|||OK I have narrowed it down a bit. If I RDP into the Terminal Server
with a Thin Client, I get the error. If I RDP with the same user on the
Terminal Server console and run the App, it works fine.
What is the difference here?
jwc
*** Sent via Developersdex http://www.codecomments.com ***