I have a ASP.NET (VB) web application running. The DTS package is suppose to
generates a flat file to a file path (aka: \\myStation\outputFiles\). When
it runs it generates the following error on one of the steps (the others run
successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Step Error Description:Error opening datafile: The referenced account is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The web
server is on one machine and the sqlserver is on another. Also I am
impersonating a domain account (aka: mydomain\RequestAccount ) that has
verified access to the path. I have run the package with DTSRun.exe
successfully from DOS and successfully from Enterprise Manager (with the
afore mentioned impersonating account). I know I'm successfully running
under the impersonated account because it shows it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME)
Dim DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword, _
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
6  1961 
It sounds as if everything is properly prepared. Can you enable security
auditing on the various servers to see which account is having the difficulty
(and where)? http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott http://www.OdeToCode.com/blogs/scott/ I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also I
am impersonating a domain account (aka: mydomain\RequestAccount ) that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Thanks for responding Scott, I have auditing on and checked the event logs
on the particpating machines and nothing. As a side note when I utilized
DTSRun from DOS to test the package (which ran successfully) it was from the
same machine that is acting as the web server (using same account that I
impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. .. It sounds as if everything is properly prepared. Can you enable security
auditing on the various servers to see which account is having the
difficulty (and where)?
http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott
http://www.OdeToCode.com/blogs/scott/
I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also I
am impersonating a domain account (aka: mydomain\RequestAccount ) that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Interesting. How do you do the impersonation? With a username and password
in web.config?
Also, most DTS components should not need this setting, but try turning on
asp compatibility mode for your page. This adjusts the environment slightly
to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott http://www.OdeToCode.com/blogs/scott/ Thanks for responding Scott, I have auditing on and checked the event
logs on the particpating machines and nothing. As a side note when I
utilized DTSRun from DOS to test the package (which ran successfully)
it was from the same machine that is acting as the web server (using
same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
It sounds as if everything is properly prepared. Can you enable
security auditing on the various servers to see which account is
having the
difficulty
(and where)?
http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott
http://www.OdeToCode.com/blogs/scott/ I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced
account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also
I
am impersonating a domain account (aka: mydomain\RequestAccount )
that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know
I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Scott,
Add AspCompt="True" to the page header and it made no difference. In as far
as the username/password, for the impersonated account, is for now in plain
text in the executable (for testing purposes -- note: the account only works
in our lab environment which is a closed network). Once I get it all to
work properly our security department will put the account info into our
encypted repository where I will pull it from at execution time (I will pass
the impersonate object and the repository object will populate it for me).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. .. Interesting. How do you do the impersonation? With a username and password
in web.config?
Also, most DTS components should not need this setting, but try turning on
asp compatibility mode for your page. This adjusts the environment
slightly to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
Thanks for responding Scott, I have auditing on and checked the event
logs on the particpating machines and nothing. As a side note when I
utilized DTSRun from DOS to test the package (which ran successfully)
it was from the same machine that is acting as the web server (using
same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
It sounds as if everything is properly prepared. Can you enable
security auditing on the various servers to see which account is
having the
difficulty
(and where)?
http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott
http://www.OdeToCode.com/blogs/scott/
I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced
account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also
I
am impersonating a domain account (aka: mydomain\RequestAccount )
that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know
I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Hi Page:
I'm running out of ideas..
Any chance H: is a mapped drive? Impersonation doesn't load a profile with
such settings.
--
Scott http://www.OdeToCode.com/blogs/scott/ Scott,
Add AspCompt="True" to the page header and it made no difference. In
as far as the username/password, for the impersonated account, is for
now in plain text in the executable (for testing purposes -- note: the
account only works in our lab environment which is a closed network).
Once I get it all to work properly our security department will put
the account info into our encypted repository where I will pull it
from at execution time (I will pass the impersonate object and the
repository object will populate it for me).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
Interesting. How do you do the impersonation? With a username and
password in web.config?
Also, most DTS components should not need this setting, but try
turning on asp compatibility mode for your page. This adjusts the
environment
slightly
to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/ Thanks for responding Scott, I have auditing on and checked the
event logs on the particpating machines and nothing. As a side note
when I utilized DTSRun from DOS to test the package (which ran
successfully) it was from the same machine that is acting as the web
server (using same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
It sounds as if everything is properly prepared. Can you enable
security auditing on the various servers to see which account is
having the
difficulty
(and where)?
http://www.pluralsight.com/keith/boo...leauditing.htm
l
--
Scott
http://www.OdeToCode.com/blogs/scott/
> I have a ASP.NET (VB) web application running. The DTS package is
> suppose to generates a flat file to a file path (aka:
> \\myStation\outputFiles\). When it runs it generates the
> following error on one of the steps (the others run successfully):
>
> Step 'Copy Data from Results to H:\Data\outfilename.txt Step'
> failed
>
> Step Error Source: Microsoft Data Transformation Services Flat
> File
> Rowset
> Provider
> Step Error Description:Error opening datafile: The referenced
> account
> is
> currently locked out and may not be logged on to.
> I am using DTS active X in code behine to execute the package.
> The
> web server is on one machine and the sqlserver is on another.
> Also
> I
> am impersonating a domain account (aka: mydomain\RequestAccount )
> that
> has verified access to the path. I have run the package with
> DTSRun.exe successfully from DOS and successfully from Enterprise
> Manager (with the afore mentioned impersonating account). I know
> I'm
> successfully running under the impersonated account because it
> shows
> it in the DTS log header:
> Package Name: PG_WCSOUTPUTFILE
> Package Description: DTS package description
> Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
> Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
> Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
> Executed On: ISBSA-WS05
> Executed By: RequestAccount
> Execution Started: 1/7/2005 10:50:28 AM
> Execution Completed: 1/7/2005 10:50:29 AM
> Total Execution Time: 1.063 seconds
> Any idea why this is taking place?
> Code:
> Dim pkg As New DTS.Package2
> Dim DTSServerName As String =
> ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
> Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
> Constants.ImpersonatePassword, _
> Constants.ImpersonateDomain)
>
> Dim DTSUserName As String =
> ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
> DTSPassword As String =
> ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
>
> impObj.BeginImpersonation()
>
> pkg.LoadFromSQLServer( DTSServerName, _
> DTSUserName, DTSPassword,
> _
> DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
> "", _
> "", _
> "", _
> Constants.DTS_PACKAGE_NAME, _
> Nothing )
> pkg.WriteCompletionStatusToNTEventLog = True
> pkg.Execute()
> pkg.UnInitialize()
> impObj.EndImpersonation()
> Thanks.
> Page
Actually H is a mapped drive, but its never used in the DTS package (no
drive letters are referenced in the package). To be honest that is the one
that has really thrown me. Our H drive is mapped as our My Documents area.
Even though the dts package creates the file with the path \\mynode\file...
does it still try to write to My Document path? But if impersonation
doesn't load a profile it wouldn't have the path would it? I do find it
puzzling because the initial output file is called outfilename.txt (then
renamed in the next step).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. .. Hi Page:
I'm running out of ideas..
Any chance H: is a mapped drive? Impersonation doesn't load a profile with
such settings.
--
Scott
http://www.OdeToCode.com/blogs/scott/
Scott,
Add AspCompt="True" to the page header and it made no difference. In
as far as the username/password, for the impersonated account, is for
now in plain text in the executable (for testing purposes -- note: the
account only works in our lab environment which is a closed network).
Once I get it all to work properly our security department will put
the account info into our encypted repository where I will pull it
from at execution time (I will pass the impersonate object and the
repository object will populate it for me).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
Interesting. How do you do the impersonation? With a username and
password in web.config?
Also, most DTS components should not need this setting, but try
turning on asp compatibility mode for your page. This adjusts the
environment
slightly
to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
Thanks for responding Scott, I have auditing on and checked the
event logs on the particpating machines and nothing. As a side note
when I utilized DTSRun from DOS to test the package (which ran
successfully) it was from the same machine that is acting as the web
server (using same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
> It sounds as if everything is properly prepared. Can you enable
> security auditing on the various servers to see which account is
> having the
>
difficulty
> (and where)?
>
> http://www.pluralsight.com/keith/boo...leauditing.htm
> l
>
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
>> I have a ASP.NET (VB) web application running. The DTS package is
>> suppose to generates a flat file to a file path (aka:
>> \\myStation\outputFiles\). When it runs it generates the
>> following error on one of the steps (the others run successfully):
>>
>> Step 'Copy Data from Results to H:\Data\outfilename.txt Step'
>> failed
>>
>> Step Error Source: Microsoft Data Transformation Services Flat
>> File
>> Rowset
>> Provider
>> Step Error Description:Error opening datafile: The referenced
>> account
>> is
>> currently locked out and may not be logged on to.
>> I am using DTS active X in code behine to execute the package.
>> The
>> web server is on one machine and the sqlserver is on another.
>> Also
>> I
>> am impersonating a domain account (aka: mydomain\RequestAccount )
>> that
>> has verified access to the path. I have run the package with
>> DTSRun.exe successfully from DOS and successfully from Enterprise
>> Manager (with the afore mentioned impersonating account). I know
>> I'm
>> successfully running under the impersonated account because it
>> shows
>> it in the DTS log header:
>> Package Name: PG_WCSOUTPUTFILE
>> Package Description: DTS package description
>> Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
>> Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
>> Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
>> Executed On: ISBSA-WS05
>> Executed By: RequestAccount
>> Execution Started: 1/7/2005 10:50:28 AM
>> Execution Completed: 1/7/2005 10:50:29 AM
>> Total Execution Time: 1.063 seconds
>> Any idea why this is taking place?
>> Code:
>> Dim pkg As New DTS.Package2
>> Dim DTSServerName As String =
>> ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
>> Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
>> Constants.ImpersonatePassword, _
>> Constants.ImpersonateDomain)
>>
>> Dim DTSUserName As String =
>> ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
>> DTSPassword As String =
>> ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
>>
>> impObj.BeginImpersonation()
>>
>> pkg.LoadFromSQLServer( DTSServerName, _
>> DTSUserName, DTSPassword,
>> _
>> DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
>> "", _
>> "", _
>> "", _
>> Constants.DTS_PACKAGE_NAME, _
>> Nothing )
>> pkg.WriteCompletionStatusToNTEventLog = True
>> pkg.Execute()
>> pkg.UnInitialize()
>> impObj.EndImpersonation()
>> Thanks.
>> Page
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Remy C. Cool |
last post by:
Hello,
My application uses a remote import scheme using the sys.path_hooks
solution as explained in PEP302
(http://www.python.org/peps/pep-0302.html)
The importer works fine for packages,...
|
by: kong |
last post by:
I created a package using pl/sql.
In this package i have a dblink to another Database, call it DB2.
Meanwhile, Server2 has a DBlink to another Database, call it DB3.
Within my package, i have a...
|
by: Chris |
last post by:
Background: I am using a MS Access 2000 front end with SQL Server 8.0
back end.
I have the requirement to import all text files (regardless of
filename) from a given folder on the network into a...
|
by: Ron |
last post by:
Hello,
I can run a dts package in a vb6 app multiple times. If I
run the same package once in a vb.net project, it runs
fine (did all the dotnet syntax conversions...). If I try
to run the...
|
by: mortenol |
last post by:
Hi, I am trying to connect a MS SSIS package to an AS400/DB2 database,
and I experience problem when I hit the "Create Package" button in
the "Data Link properties window".
I have understood that...
|
by: kelvin |
last post by:
Can anyone tell me what could cause the error below?
Starting installation ...
Loading zlib: ok
Downloading package: PEAR-stable......ok
Downloading package: Archive_Tar-stable....ok...
|
by: manish deshpande |
last post by:
Hi,
When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command:
rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown:
...
|
by: gngui |
last post by:
Hi,
I am using the Microsoft Office Access 2003 Developer Extensions to package a Ms Access application. After packaging & running setup, the installation works & is completed OK.
The problem is...
|
by: Conny Nehmer |
last post by:
For me that sounds like you don't have a rights problem but the database is
simply not able to find your package.
Can it be that you forgot to create a synonym for the package in first
schema?
...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: giovanniandrean |
last post by:
The energy model is structured as follows and uses excel sheets to give input data:
1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |
