Resume Execution After Error

Nov 21, 2006

Hi,

I have a stored procedure containing iterating cursor in which iam inserting records in a table. My problem is that whenever any data mismatch occurs whole process gets stops. I want it should skip that error record and continue with next iteration. Like on error resume next in vb. Please suggest.

View 5 Replies


ADVERTISEMENT

How Do I Achieve - In SQL - Something Like On Error Resume Next In VB?

Oct 2, 2007

Often when I write a stored procedure, I encounter a situation where
it will be really convenient if I can ignore an error and continue the execution
of next SQL statement, especially when I know what kind of error it will generate.
It's just like the effect of "On Error Resume Next" in VB.

Does anyone have any idea or have some knowledge to share?
I would really appreciate.

I am using SQL Server 2005 and SQL Server 2000. Thanks.

Chris

View 5 Replies View Related

Error 3926 , Server Failed To Resume Transaction

Aug 22, 2007

In a high load asp.net environment,  I am getting an error. The transation active in this session has been committed  or aborted by another session.Here is the code , I am getting error. 1 object returnObject = null;
2 SqlTransaction sqlTrans = null;
3 try
4 {
5 //Getting new SqlConnection
6 comm.Connection = GetConnection();
7 //Opening connection
8 OpenConn(comm.Connection);
9 //beginning transaction
10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );
11 //setting transaction to SqlCommand object
12 comm.Transaction = sqlTrans;
13 //executing operation
14 returnObject = comm.ExecuteScalar();
15 //trying to commit.
16 sqlTrans.Commit();
17
18
19 }
20 catch (SqlException sex)
21 {
22 if (sqlTrans != null)
23 {
24 sqlTrans.Rollback();
25 }
26 }
27 finally
28 {
29 comm.Connection.Close();
30 }
  Could you please explain , am I doing smthg wrong ?

View 5 Replies View Related

How To Achieve On Error Resume Next Login In SSIS For Loop

Apr 5, 2006

Hello All,

I am developing a package using SSIS which needs to do the following.

1. Read all flat file from a folder. I am doing this using For Loop task. I know the total number of files in that folder hence I am setting the loop counter = file count.

2. The next step is to import the data from flat file to SQL server destination table using data flow task.

3. Upon successful completion of data flow task there are some other tasks like SQL to do some checks/validation on the data, export it to another tables.

Upon successful completion of step 3 the iteration goes to next file.

I want to achieve the following

IF step 2 has error (for example corrupt file or incomplete data), I want to fail data transfer completely, skip step 3, and go to step 1 for next available file and do rest.

How do I do this in SSIS?

Thanks for your help.

SGK

View 1 Replies View Related

How To Retrieve Resume From Database

Mar 20, 2008

I stored resume in database with datatype Image. But now i want to retrieve the resume becoz if user wants to edit their resume and again i shud store the updated resume into my database.
Give me ideas...Thanks in adv!! 
 

View 4 Replies View Related

How To Set A Catalog To RESUME Status

Nov 7, 2012

I came across the following error message while backing up a database:

The backup of full-text catalog 'myCatalog' is not permitted because it is not online.

Changing the status to RESUME for full-text catalog "myCatalog" (5) in database "myDB"

View 1 Replies View Related

Log Shipping- How To Resume After Swap

Oct 30, 2006

I have setup logshipping in sql 2005. i have a primary and secondary server only.
Suppose for maintenace i bring primary down. . i have to manually bring the secondary server online. usnig restore databse with restore.

1) so far so good. But what now. How can i re-sync the old primary with the new primary?

2) can i return the original secondary back to standby mode so that the primary can resume its role and the log shipping process proceeds.

View 5 Replies View Related

Pause And Resume Mirroring

Dec 5, 2007



If we have a situation that the Mirror server is unavailable for a day....very unlikely, but it happens when servers are moved from one data center to another....Lets assume we are doing safety off (high performance mode)

Should we pause mirroring on the principal server?

When we pause, does the transaction log keeps growing ?
Can we backup the logs ?

If we don't pause mirroring

Does the transaction log keeps growing ?
Can we backup the logs ?

What we can expect we we bring online the mirror server next day! will there be any performanbce problems since mirroring will try to catch up....

Considering moving to mirroring from logshipping for our disaster recovery.

Thanks,


View 4 Replies View Related

SQL 2012 :: Resume Data Movement

May 28, 2015

The secondary server for my availability group was recycled. When SQL Server came back online the data movement for a database was suspended. The error log shows:

"AlwaysOn Availability Groups data movement for database 'XXXXXXXXX' has been suspended for the following reason: "system" (Source ID 5; Source string: 'SUSPEND_FROM_RESTART'). To resume data movement on the database, you will need to resume the database manually. For information about how to resume an availability database, see SQL Server Books Online."

I was able to resume data movement with no issue. I would like to understand the technical reason as to WHY the data movement was put in the suspended state and left there upon recycle. I searched for an article that would list possible reasons (BOL, Google, Bing, etc..). I just could not find much information out there on 'SUSPEND_FROM_RESTART'.

View 2 Replies View Related

How To Store Resume And Cover Letter Into SQL Server?

Jun 6, 2005

Hi,
    I am trying to create an asp.net web recruiting application for HR, which will give the users the ability to both copy/paste the Resume and cover letter in textbox and upload resume and cover letter, then submit it (which will be saved into SQL Server 2000 table). 
I am thinking to save Resume and cover_letter as Image data type columns in SQL Server. 
.  Can someone give me a direction about how to save the uploaded resume and cover letter to table and if it's the easiest way to do it?
.  What to deal with different formats of uploaded resumes?  I hope to limit to only Word or HTML
.  Since I also give user another option - copy/paste the resume and coverletter into a textboxes.  Can I simply save the copy/paste resume and cover letter into text field column?  Later, say, if any HR recruiter retrieve the text from database, will it concatonates everything together without line break?
Any ideas is appreciated.

View 8 Replies View Related

SQLException The Server Failed To Resume The Transaction

Mar 24, 2008



Hello-

A customer has reported getting the following excpetion in our logs, and I have never seen it before and wanted to see if there was any insight you could provide to understand when you throw this exception.

The process is a "purging" process- it just executes a sequence of DELETE statements that should be fairly simple (delete a number of records from a table and CHECK some constraints, no cascading), after the sequence it commits. All of this occurs on the same connection. We use c3p0 for connection pooling.

Here is the exception:

2008-03-22 08:30:08,699 WARN impl.NewPooledConnection : [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
2008-03-22 08:30:08,699 WARN impl.NewPooledConnection : [c3p0] Another error has occurred [ com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:9f00000002. ] which will not be reported to listeners!
com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:9f00000002.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
at $Proxy15.rollback(Unknown Source)
at

View 3 Replies View Related

The Server Failed To Resume The Transaction. Desc:d200000003

Apr 18, 2007

Hi,

We recently migrated our application from SQL Server 2000 to SQL Server 2005 and we also migrated from WAS5 to WAS6.

We are getting the following exception when we call any of the stored procedures.

The server failed to resume the transaction. Desc200000003.

Basically we call these stored procedures frequently using the Java thread scheduler.

We didnt face any problem when we use IBM drivers

I guess this is the problem with the drivers.We use JDBC 2005 driver Version 1.1.

But we didnt face this problems when we use JDBC 2000 driver when we used to connect to SQL Server 2000

The Microsoft says that it has fixed the date problems as well as the transaction problems in the version 1.1.But still are facing the issues.

Can anyone of you please help me in getting the solution for the same?

View 4 Replies View Related

How Long Takes To Do Resume Full Text Index Population

Aug 11, 2012

I have a table having 220 lakhs of records and one of the column is Full Text enabled.We have used ContainsTable() to search for data, but we are unable to get results as expected. so we done rebuild.During Index Rebuild, population is failed.I have found this error in error log and it is saying to do resume population.So I want to know how long it takes to complete Resume population process.

look at the below more details about FT Index table.

Row count - 22155112

Index space - 1,903.250 MB (1.9 GB)

Data space - 87,552.258 MB (87 GB)

sqlserver2008 R2

and the below query we have used

HTML Code:
SELECT Distinct top 50 cal.case_id,cal.cas_details
From g_case_action_log cal (READUNCOMMITTED)
inner join containstable(es.g_case_action_log, cas_details,
' ("235355" OR "<br>235355" OR "235355<br> ") ') as key_tbl on cal.log_id = key_tbl.[key]
Where cal.product_id = 38810 ORDER By cal.case_id DESC

This query is not going to search in recent inserted/updated rows. this is the actual issue we are facing.

how to fix this error and if population need to be resume, then how long takes to do resume population.

View 1 Replies View Related

SQL Execution Error

Oct 2, 2007




I have converted a CF app to MSVS 2008 beta 2 and SQL Server CE 3.5 , everything seems to work except one query. It work in Query Designer nor can I load the form the datsource resides on. It will work if I just right click the query and left click preview data. The error is an SQL Execution Error.
Error source SQL Server Compact ADO.net Data Provider
Error Message: There was an error parsing the query [Token Line number = 1, Token Line offset = 121, Token in Error = Procedure]

SELECT RecNum, InvNum, InvoiceDate, Horsename, ProcedureCode, PartNum, Procedure, Qty, Rate, Amount, CostPerItem, Cost, Net, Type
FROM LineItem

Also tried this but the query designer won't allow the [ ] it removes them an fails the query.
SELECT RecNum, InvNum, InvoiceDate, Horsename, ProcedureCode, PartNum, [Procedure], Qty, Rate, Amount, CostPerItem, Cost, Net, Type
FROM LineItem


This is the SQL from the same program in MSVS 2005
SELECT RecNum, InvNum, InvoiceDate, Horsename, ProcedureCode, PartNum, [Procedure], Qty, Rate, Amount, CostPerItem, Cost, Net, Type
FROM LineItem

Also tried this but I get no data in the Proced column and Procedure is auto unselected in the Query Designer.
SELECT RecNum, InvNum, InvoiceDate, Horsename, ProcedureCode, PartNum, Qty, Rate, Amount, CostPerItem, Cost, Net, Type, 'Procedure' AS Proced
FROM LineItem


Is there a new symbol to use for protecting a column name?

Thanks Jon Stroh

View 3 Replies View Related

DTS Execution Error

Sep 19, 2007



when i execute a DTS to copy a database from one server to another, I am getting the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 'SQL OLEDB' reported an error.Authentication Failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE/DB provider returned message: Invalid authorization specification]
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDB Initialize: Initiliaze returned 0x80040e4d: Authentication failed.].

Can somebody please help?

View 6 Replies View Related

Execution Error Of A Job

May 31, 2007

I want to run a job and in the step 1 is a package, I test my package in VS and it works but when I execute this from a job this do not work and I receive an error message "Executed as user: serverSYSTEM. The package execution failed. The step failed."



any help please

View 3 Replies View Related

Error During Second Execution

Dec 11, 2007

Hello everybody,

I designed simple package using VS.NET to implement copy operation from MS Access to SQL Server via SSIS technic

1) in the server side, I have created new database called "test" (no tables inside)

then

2) i added a new connection to connect to target database (test)

after that
3) I added another conncetion for MS Access database (db_access.mdb) which contains some tables(on of them is called "Employees_Table" )

Finally

I executed the simple package to check my work,
at first time, the operation completed successfully
but
when i tryed to run it again, the error occure and tell me that table with name "Employees_Table" already exist.

my test was to copy any exist modifications in db_access.mdb and reflects them into Employees_Table on SQL Database "test"
So, my question is how to correct this package?

Thanks

View 5 Replies View Related

Job Execution Error - Please Help

May 1, 2006

I have started having a problem with my SQL Server 2005 SSIS system and it has become a nightly event. What is happening is that sometime in the evening before 7:30 the server gets into a state in which any SSIS job that attempts to run, fails. The error message that SSIS reports is:
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS file mapping object 'GlobalDTSQLIMPORT ' could not be opened. Operating system error code 8(Not enough storage is available to process this command.). Make sure you are accessing a local server via Windows security.".

I can bounce the SQL Server service and then packages run normally.
I will be greatful to anyone who can help with this error.
Best Regards,
Mark Redman.

View 7 Replies View Related

T-SQL (SS2K8) :: Error With SP Execution

Apr 16, 2014

I am having SP where I am pulling data from linked server. Previously its working fine but suddenly started to give below error.

Msg 15281, Level 16, State 1, Procedure Procedure_Name Line 184

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

View 4 Replies View Related

Execution Error: Null

Jan 18, 2007

I thing I need your help..I have a data task flow w Derived Column Transformation to concatenate name +familyname. It seems like Nulls are not accepeted but where do I correct it?
How do I
[OLE DB Destination [658]] Error: An OLE DB error has occurred. Error code: 0x80040E2F. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E2F Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E2F Description: "Cannot insert the value NULL into column 'namn', table 'ElektronicsDW.dbo.Dim_Salesperson'; column does not allow nulls. INSERT fails.".

View 3 Replies View Related

Execution Error Message

Jan 29, 2008

This is really strange to me. I am trying to run this report. I am able to run it from 01-01-2007 through 10-01-2007, but when I go to run it from 01-01-2007 throug 12-31-2007, I get this error messge below. I don't understand, if you can help let me know. Thanks!

Error Source: Net SQLClient Data Provider
Error Message:Arithmetic overflow error converting numeric to data type numeric.

Here is my SQL below, if that helps to look at.

SELECT DISTINCT
clm_wkpct, clm_1a, clm_12a, clm_12b, clm_55d, clm_clir, clm_65a, clm_medb2, clm_tchg, clm_base, clm_stades, clm_prod, clm_nego, clm_sppo,
clm_1e, Note, Clm_Att1, AccessFeeFinal, CLM_ATT2, CLM_ATT3, ACCESSFEEIMPACT, MAS90#, clm_meda4 AS OriginalAllow, CLM_H30 AS Adjusted,
clm_id1, CONVERT(CHAR(10), clm_rcvd, 110) AS daterecieved, CONVERT(CHAR(10), CLM_DOUT, 110) AS dateclosed,
CAST(clm_sppo / clm_tchg * 100 AS decimal(4, 2)) AS PercentSavings
FROM vw_Claims_Settlement_Rptdata_SharePoint_NO_DISCOUNT
WHERE (CLM_DOUT >= @BottomDate) AND (CLM_DOUT <= @TopDate)

View 5 Replies View Related

Halting Execution On Error

Apr 25, 2006

I have a simple SSIS package split into two parts; validation and processing. I want to be able to stop execution on any package errors (such as file not found, etc) using the OnError event handler. Is this at all possible?

View 3 Replies View Related

SQL Execution Error: Clr Enabled

Feb 8, 2007

I've Created a DLL Library and added it as an assembly in a database when I make a select statement from SQLCmd using my functions it runs fine but when I try to Create View from the VB 2005 Express Development Environment it Gives me the Error

SQL Execution Error
Error Message: Execution of user code in the .net Framework is disabled. Enable "clr Enabled" configurartion option



note that CLR Integration Option of the SQL server is ON and I've Tried sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGUREform SQLCMD in vainwhen I execute the select statement from the SQLcmd it runs fine but when I try to make a View from the Developmet Environment i gives me that error Please Help

View 6 Replies View Related

SSIS Execution Error

Feb 14, 2007



Hi

I am getting this error when I try to execute a package source is oracle and destination is sql

[Source [1016]] Error: The AcquireConnection method call to the connection manager "Oracle_test" failed with error code 0xC0202009.

It was working fine until I changed the Connection to New Connection from Data Source.

View 4 Replies View Related

SQL2000 DTS Execution Error

Oct 2, 2007

Hi


I'm having a DTS which will select all columns from table and export as a text file to a network share. The job is executing successfully for long days, but suddenly we got the following error.

Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed.


The job owner is sqlservice account and that account has SA privilege in SQL level, then i've given SA privilege on OS level also but i got the same error.

Inside the jobstep the command is like "DTSrun dts_id", when i changed this to run as Exec master..xp_cmdshell "DTSrun dts_id" the job executed successfully.


Why the job failed even it has SA privilege on both SQL & OS level and also it has necessary privilege on the share folder?
Why the job ran successfully after changing it to Xp_cmdshell command ??

View 8 Replies View Related

Cryptic Sql Execution Error

Feb 29, 2008

I am trying to create a Union view with the following query:

SELECT TxType, AccNo, Stream
FROM dbo.vw7_Existing_Member_History
UNION
SELECT TxType, AccNo, Stream
FROM dbo.vw8_Deleted_Member_History

Here TxType is a short int, AccNo a nvarchar and stream is also nvarchar.

Stream containd values sch as "MCA", "MBA", "B.Ed." etc....

When I try to execute this query I get the following error:
Error Message: Conversion failed when converting the nvarchar value 'B.Ed.' to data type int.


Removing Stream from both clauses of the query leads to uccessful execution.
As I said, Stream is nvarchar, and nowhere am I trying to convert it into an int!!!!

What does this error means then???

View 5 Replies View Related

TSQL Execution Error

Mar 20, 2008



HI,

i am trying to add the backup device within my procedure, but i m getting following error.. Can anyone please have a look and tell me where i m doing mistake


SET @Device_name = ''

SELECT @Device_name = @DatabaseName

SELECT @Device_name = @Device_name + '_TLOG'

SELECT * FROM sys.backup_devices where Name = @Device_name

IF @@ROWCOUNT <=0

BEGIN

SELECT @Device_name = ' sp_addumpdevice ''DISK'',''' + @Device_name + ''',''\1.3.0.1SQL_BackupsTLOG_Backups' + @Device_name + '.BAK'

EXEC @Device_name

END



error message


Msg 203, Level 16, State 2, Procedure CreateTLOGBackup, Line 55

The name ' sp_addumpdevice 'DISK','databasename_TLOG','\1.3.0.1SQL_BackupsTLOG_Backupsdatabasename_TLOG.BAK' is not a valid identifier.



View 11 Replies View Related

SQL Error Doesn't Stop Execution

May 25, 2006

I have some code that I inherited that I'm having an issue with.  It includes a class for database functionality.  At one point a call to a function, snippet below, results in a SQL error ('can't insert NULL into column MyColumn).  What is amazing and frustrating me is that it just Blows Right by the Error!  I thought it would raise the alarm bells, "hey!  I got a sql error."  I only see the error if I step through the code and look at the Exception that's caught.  I tried removing the catch statement entirely, thinking that would at least cause an unhandled exception error, but no go. 
How do I raise a big red flag to the user when SQL errors happen?  And how could it not be doing that automatically?  This is for an intranet site so I really don't care if they see ugly errors or not.
try{   sqlcommand = new SqlCommand();   sqlcommand.Connection = DBInterface.DBConnection;   sqlcommand.CommandText = strSQL;   sqlcommand.CommandType = CommandType.Text;   nRowsAffected = sqlcommand.ExecuteNonQuery();}catch (Exception ex){   return -1;}
 
 

View 5 Replies View Related

DTS Error: &#39;Execution Was Canceled By User&#39;

Nov 13, 2001

We are running SQL Server 2000 (select @@version reports 8.00.194).

We are calling a package (Package B) from another package (Package A) using the 'Execute Package Task'

Package B is constructed as:

A CSV file
A Data pump into a database (OLEDB and ODBC to SQL Server DB - both operate in the same way)
An ActiveX step after the connection to display a message box

When Package B is executed in isolation the data pump runs to completion and then the ActiveX step displays the message box.

However, when Package A is used to execute Package B then Package B returns an error message indicating that 'Execution was canceled by user'. Inspection of the database shows that the data pump ran successfully to completion, however, the last Active X step was not executed.

More strangely if the ActiveX task is removed then using either method will report successful execution of Package B.

Additionally, if individual ActiveX steps are included for success, failure and completion after the connection step, none of them execute when Package A calls Package B.

View 1 Replies View Related

DTS Package Execution Error-URGENT!

Jun 15, 2001

Hello!
I'm trying to execute DTS package using dtsrun utility from MSDOS Prompt
and getting error message "Cannot Open user default database '<ID>'.Using master database instead".

here's the syntax

dtsrun -Stestserver -Utestuser -Ptestuser -Ncustomers


How can I resolve this?

Thank you

Lena

View 2 Replies View Related

&#34;Timeout Expired&#34; Error On DTS Execution

Jan 22, 2001

Hello,

I am using a VB script active task object in a DTS package
to connect to one of my databases using an OLE DB connection.
I send an SQL string executing stored procedures, and depending
on the size of the procedures I get a "Timeout Expired" error
on execution of the DTS package. I have trimmed and tuned the
stored procedures to be much smaller and faster, but still
haven't beaten the timeout. How do i avoid, switch off, or
lengthen the timeout period?

Thanks, Joshua

PS, alternately, how might I modify the parameters of and execute
DTS packages from stored procedures?

View 1 Replies View Related

How To Continue Package Execution During Error?

Jun 5, 2006

We have a package that loads the data from several excel files into database in a forloop.

Everything works files until the package hits the bad file.

My goal is to continue the loop to process the rest of the files by skipping the bad file and error. In each task OnError I am creating custom error message to send an error/ sucess summary email out at end of the process.

How can force the for loop to continue when there is an error?

Is there any way to reset the errors?

Thanks

R

View 1 Replies View Related

SSIS Package Execution Error

Jul 24, 2006

While executing the SSIS package from visial studio it is running. If we execute from Integration services - - -> stored packages - - - -> msdb - - - -package name, the package gets executed.



But when scheduled through jobs it gives the following error in history

"Execution as user. <user name > The command line parameters are invalid. the step failed"

command line looks like this "

/DTS "MSDBMaintenance PlansPackage1-HYUNDAI" /SERVER tvmwindev02 /CONNECTION "10.10.1.52.upsframis";"Data Source=10.10.1.52;Initial Catalog=upsframis;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;" /CONNECTION DestinationConnectionOLEDB;"Data Source=mscoe.db.ustri.com;Initial Catalog=HISNA_POC;Provider=SQLOLEDB;Integrated Security=SSPI;Auto Translate=false;" /CONNECTION "sample.db2test";"Data Source=sample;User ID=db2test;Provider=IBMDADB2.1;Location=10.10.1.55;" /CONNECTION SourceConnectionOLEDB;"Data Source=SAMPLE;User ID=db2test;Provider=IBMDADB2.1;Persist Security Info=True;Location=10.10.1.55;Extended Properties="""";" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

"

What could be the reason ?



Deleep.P

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved