Error Code: 60000000b8 Server Could Not Continue Transaction

May 27, 2008

Hi,

does anybody know this error code? I get that error from a jdbc-connection ocasionally but can't find an explanation. The original message is in German. The number should be ok. The error occures when a transaction is aborted, the jdbc-connection is lost.

'Der Server konnte die Transaktion nicht fortsetzen. Beschreibung: 60000000b8'

Please help,
Many thanks

View 2 Replies


ADVERTISEMENT

Error Handling In MSSQL - If Error During Call Remote Stored Prcedure I Need SQL Code To Continue...

Jul 20, 2005

Hi All,I want to catch the next MSSQL error in my SQL code with following continuecalculationsServer: Msg 17, Level 16, State 1, Line 1SQL Server does not exist or access denied.If REMOTE_SERVER_1 is inaccessible (as in (a) below) the executing of SQLwill not continue with (b) - I need the code in (b) to run despite whetherthe previous exec was successful or not - Any ideas?begin transaction(a) exec REMOTE_SERVER_1...bankinsert '1' , '1' , 1 , 0 , 0(b) print @@errorcommit transactionwhere REMOTE_SERVER_1 is link to server created byEXEC sp_addlinkedserver @server = 'REMOTE_SERVER_1', @srvproduct = '',@provider = 'SQLOLEDB', @datasrc = 'MYCOMP1', @catalog = 'mirror2'EXEC sp_addlinkedsrvlogin @rmtsrvname = 'REMOTE_SERVER_1', .....Exec sp_serveroption 'REMOTE_SERVER_1', 'data access', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc out', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'collation compatible', 'true'Any help will be greatly appreciated

View 1 Replies View Related

Error: SQL Server Internal Error. Text Manager Cannot Continue With Current Statement..

Sep 21, 2006

When my production server processing some queries suddenly the SQL Server service crashed and following error was in the error log:

SQL Server Internal Error. Text manager cannot continue with current statement.

The server is running SQL Server 2000 with SP4.

I am really concerned because this is a production sever and there are over 300 users access concurrently.

Please help me to find a solution.

Thanks,

Roshan.

View 8 Replies View Related

SSIS Error: The Connection Does Not Support Enlisting In Distributed Transaction. Error Code: 0x8000FFFF

Feb 29, 2008



Hi all,

can anyone tell me if an oleDb connection (provider is Jet 4.0 to Access database) can be enlisted in a Distributed Transaction?

The goal is to copy data from SqlServer to Access within a transaction.

Pier

View 10 Replies View Related

Continue Transaction If Trigger Fails

Nov 6, 2007

Hi guys,

I have some triggers that insert data in a table located in a remote server. If the remote server happens to be down I want to continue with the original transaction anyway. Can I use a BENGIN TRY BEGIN CATCH block to continue with the transaction in the trigger and also insert the data into a temporal local table if the remote insert fails?

Regards

View 3 Replies View Related

How To Continue On Error

Jul 23, 2005

How can I cause my insert statement to skip over (without failing) rowswhere there's a primary key constraint violation?I've got a case where daily I insert >500k rows of daily data, wherethe data is date and time stamped. So, for example, I have an insertstatement with constraint: WHERE date >= '5/20/05' AND date <'5/21/05'. That takes care of one day's data (5/20).However, the next day's data (5/21) will still have some time stampsfrom the previous day. Therefore the statement needs to be somethinglike WHERE date >= '5/20/05' AND date <= '5/21/05'. The 5/20 data isalready loaded but I need to take the 5/21 data which just happens tocontain just a few rows of data marked 5/20 and insert it withoutgenerating a primary key error from all the other 5/20 rows that arealready inserted.-Dave

View 7 Replies View Related

Continue After Error

Aug 27, 2007

I have an SSIS package that uses a for each loop to send an order confirmation e-mail. If it does not find an email I need the package to continue after the failure path. The package stops after the failure, but I need it to continue with the next iteration of the for each loop. How can I do this?

View 4 Replies View Related

Continue On If Certain Error Message

Jan 14, 2002

I have a sql statement which runs through a reference table to drop columns no longer needed. It works, however if it tries to delete a column that does not exist, it errors out. Is there a way to continue if this error appears(I have the set error routine set up) The question is can I tell it if it is this error to go on, and is "continue" the
right syntax? Below is statement

open dbcursor
fetch next from dbcursor into @tbname,@fldname,@recid
while (@@FETCH_STATUS <> -1)
begin
--set @tbname = 'IMMUNIZATION_MAST_'
--set @fldname = 'cb_other'
set @sql = 'alter table ' + ltrim(@tbname)
set @sql3= ' drop column ' + ltrim(@fldname)
exec(@sql + @sql3)
select @error = @@error
if @error = 5924
begin
CONTINUE?
end
print @error

View 1 Replies View Related

Error In Replication How To Continue

Jan 28, 2004

I have transactional Replication from A to B.

My distribution agent failed becos of a primary key violation error in a table.[i have not included the skip error option].

Then the replication stopped.
The transactions on other tables are also not replicated to B.

IF an error is encountered in one of the tables will the replication stop entirely??.Is there no way for the replication to continue for the rest of the tables..
Pls clarify

View 2 Replies View Related

Continue On INSERT Error.

May 10, 2007

Hi!



Imagine this SQL statement:






Code SnippetINSERT INTO B SELECT * FROM A






If one of the insert fails ... don't continue, the statement fail. For example if any field in A violate a constraint in B, the statement fails.



I want that the statement continue if errors occurs, if i lost a number of rows don't matter ... but if i can save or log this row will be great too !!



Is posible? Any way to do it?



Regards.

View 5 Replies View Related

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB Error Has Occurred. Error Code: 0x8000FFFF.

Jan 28, 2008

Hi All,

Recently in an SSIS package I am getting the following error for a particular Data flow task.





Error: 2008-01-25 12:01:48.58

Code: 0xC0202009

Source: Import Datasynapse Data User Events Source [3017]

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF.

End Error

Error: 2008-01-25 12:01:48.73

Code: 0xC004701A

Source: Import Datasynapse Data DTS.Pipeline

Description: component "User Events Source" (3017) failed the pre-execute phase and returned error code 0xC0202009.

End Error

Our guess is when the data size of User Events table is more it throws this error. If we try to transfer small subset of data it succeeds. What could be reason for this error?

Since this is very urgent, immediate response would be very much appreciated.

Thanks & Regards,
Prakash Srinivasan

View 4 Replies View Related

Continue The Query If An Error Occured

Jan 12, 2004

I have a looped query querying linked servers. When it cannot connect to a server, it errors out.

Error Message;
Server: Msg 6, Level 16, State 1, Line 2
Specified SQL server not found.

How can I handle this error message and continue the query?

View 6 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

Continue ForEach After An Error Was Handled

Mar 13, 2008

How can we continue with the rest of the iterations in ForEach Loop after handle an error.

I Have a dataflow task inside a for-each loop and processing a set of flat files in that. When error occurs in the dataflow task, i moved that particular flat file to another location. But, If an error occurs at first falt file, It moves that flat file to the location i specified and not continue with the next file (The Execution finished at that stage itself afetr the first flat file).

I Set the FailParentonFailue of Dataflow task to TRUE (Since its inside the for loop).

Any thing i have to change ? Or Where i miss the thing.

View 5 Replies View Related

Error 8525: Distributed Transaction Completed. Either Enlist This Session In A New Transaction Or The NULL Transaction.

May 31, 2008

Hi All

I'm getting this when executing the code below. Going from W2K/SQL2k SP4 to XP/SQL2k SP4 over a dial-up link.

If I take away the begin tran and commit it works, but of course, if one statement fails I want a rollback. I'm executing this from a Delphi app, but I get the same from Qry Analyser.

I've tried both with and without the Set XACT . . ., and also tried with Set Implicit_Transactions off.

set XACT_ABORT ON
Begin distributed Tran
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.TRANSACTIONMAIN
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.TRANSACTIONMAIN
set REPFLAG = 0 where REPFLAG = 1 and DONE = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.WBENTRY
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.WBENTRY
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.FIXED
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.FIXED
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.ALTCHARGE
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.ALTCHARGE
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.TSAUDIT
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.TSAUDIT
set REPFLAG = 0 where REPFLAG = 1
COMMIT TRAN


It's got me stumped, so any ideas gratefully received.Thx

View 1 Replies View Related

Flat File Source - Continue On Error?

Oct 20, 2007

Hi

I have a CSV file which sometimes contains the odd CSV error, for this reason the odd row throws an error.

If I have a clean CSV file my SSIS package works great, but I am having problems getting the package to continue past the rows in the file that throw errors.

How do I :



Get the package to continue on error, I have tried playing with the Propagate Variable with no joy

Add an Error event, which will capture the error and log it to a SQL table or File Destination?
Any help will be great!

Thank you



View 3 Replies View Related

Cannot Continue Past Source File Error...

Nov 30, 2006

 

 

  I have an SSIS package where I have directed the error output to a Flat File Destination.  The issue is that there are some bad entried in a set of log files, where the source file reads on more delimited column than there are actual columns.  (As in there are 26 column headers, and one row will have 27 commas, or delimiters.)  I am trying to redirect the row output to put the bad rows into a Flat File for debugging purposes.  Although, the package is not able to continue past the error.  As soon as it hits the bad row, it fails despite the error output.

Any ideas?

View 2 Replies View Related

Error Handling - If Update Fails I Need Procedure To Continue...

Jan 7, 2004

Hi There,

If an update in a stored procedure fails/errors (as in (a) below) the procedure will not continue with (b) - I need the code in (b) to run despite whether the previous update was successful or not - Any ideas?


(a) if(@Data2 = 6)
begin
update
SCHEDULE
set
Start_CallBack = getdate()
where
(Block = @Block)
end


(b) WHILE @Block_Count > 0
BEGIN
UPDATE BLOCK SET Status = @Block_Status
END


Any help will be greatly appreciated :)

View 2 Replies View Related

Insufficient Memory To Continue Error When Attempting To Save SSIS Package

May 12, 2006

When attempting to save an SSIS package in Visual Studion I receive the following error message detailed below. If I attempt to "Save As" to another location, I then receive an insufficient storage error. The development machine has over 1.5 GB of available physical memory and several GB of disk space availabe to save my 16 MB package. I have checked the event log and have found no related messages in the Application or Server logs.

Any suggestions on how to determine the cause or resolution of this error message would be greatly appreciated.


Failure saving package. (Microsoft Visual Studio)

Insufficient memory to continue the execution of the program. (Microsoft.SqlServer.ManagedDTS)

Advanced Error Message Details

Failure saving package. (Microsoft Visual Studio)
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializePackage(IDesignerSerializationManager manager, Package package, TextWriter textWriter)
at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializeComponent(IDesignerSerializationManager manager, IComponent component, Object serializationStream)
at Microsoft.DataWarehouse.Serialization.DesignerComponentSerializer.Serialize(IDesignerSerializationManager manager, Object value)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Serialize()
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.BaseDesignerLoader.Flush(Boolean forceful)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.BaseDesignerLoader.Flush()
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseContainerManager.OnBeforeSave(UInt32 docCookie)
===================================
Insufficient memory to continue the execution of the program. (Microsoft.SqlServer.ManagedDTS)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package.SaveToXML(String& packageXml, IDTSEvents events)
at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializePackage(IDesignerSerializationManager manager, Package package, TextWriter textWriter)

View 3 Replies View Related

SQL Server 2005 Startup Error - TDSSNIClient... Error 0x5... Code 0x51

Jul 13, 2006

Hi,My SQL Server 2005 won't start - can anyone provide some help? Thisseems to be the most significant error:- TDSSNIClient initialization failed with error 0x5, status code 0x51.There was some info here, but the reg key described looks okay:- http://blogs.msdn.com/sql_protocols/I am running SQL Server 2005 64-bit Standard Edition. The server inquestion is the first node of an Active/Active Cluster. This firststarted happening while I was trying to add a share as a clusteredresource of the other node (not to this node's resources).I have not yet reinstalled SQL Server 2005 because I am hoping for moreexplanation of the problem and a possible fix.Thanks,Tom

View 1 Replies View Related

MS SQL Server Maintenance Plan Failed: Error Code 0x534. [SQLSTATE 42000] (Error 15404))

May 3, 2008



hello,

we have changed the name of MS SQL server 2005 from XYZ to ABC using


sp_dropserver <old_name>

GO

sp_addserver <new_name>, local

GO


Now our maitenance plan is getting failed we are not able to execute backup jobs we are getting following error


Date 03.05.2008 16:00:00
Log Job History (ADM_AdminDB_TP_Backup.Subplan_1)

Step ID 0
Server ABC
Job Name ADM_AdminDB_TP_Backup.Subplan_1
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. Unable to determine if the owner (XYZSQLServer) of job ADM_AdminDB_TP_Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'XYZSQLServer', error code 0x534. [SQLSTATE 42000] (Error 15404)).

please help us in this issue

View 13 Replies View Related

Error: SQL Server Does Not Exist Or Access Denied. (Error Code 17).

Mar 22, 2006

Hello everyone.

I am trying to install Project Server, and i'm having issues with sharepoint, and connecting to SQL:

dataserver is running sbs2003 sql2003 and analsys services.

server2 is running server2003 is to be the application server for project.

ProjectDb is the database that i have setup in sql.

username is the account that can control everything as administrer.

in Sharepoint is asks for the database server: <<dataserver>>

SQL Server database name: <<ProjectDb>>

I'm using windoes authentication and then i click ok, and get the error message.



I've also see the error message can not find the SQL Server, and access denied. Under ODBC i have installed the sql server information under System DSN.

Any help would be great.

Thanks

Everett Buel

View 3 Replies View Related

Flat File Source - If An Error Occurs, Continue Parsing The Remaining Columns In The Row Before Failing

Jan 14, 2008

Hello everyone,


I have a package that extracts data from a Flat File. If any errors or truncation occur during the extraction of the input data, the package should fail. All fields that have erroneous values should be reported in the log file.


My Solution:
- I have created a Data Flow Task that contains a Flat File Source Adapter and a dummy destination.

- I have left the default "Error Output" configuration of the Flat File Source adapter, namely if a truncation or an error occur for a certain column, then the reaction is "Fail Component".


Problem:
This configuration gives me only the first erroneous column in the row being processed.


Question:
Is it possible to make the Flat File Source adapter continue parsing the current row before it fails? This way, I would be able to get all the erroneous columns in the row in one shot.


Thanks in advance...
Samar

View 6 Replies View Related

Where Should I BEGIN/END Transaction? In Code Or In The SP?

Mar 30, 2006

I notice you can do a END and BEGIN trasaction in BOTH. But I hope BOTH are not needed. So where so I use them  ?
 
Or should I even use them for simple updates and inserts ?

View 3 Replies View Related

SQL Server Memory Usage Continue To Increase

Dec 28, 2004

Hi,
On the last Sunday 26/12/04 on 20:00 I got on one of our applications in the customer site this error:
"There is insufficient system memory to run this query."

Details:

Computer: IBM XSERIES_345, dual CPU 2.8 Intel xeo, 1,047,952 KB ram, windows 2000 server sp4.
Disk space: 4395 MB, Virtual memory: initial size 1536 MB, Max size 3072 MB. Registry size: current 14 MB, Max 90 MB.

SQL Server 2000 SP 3, two production databases (1) Data size 100 MB, log size 15 MB (2) Data size 500 MB, log size 125 MB
All the memory options are configured as default i.e. dynamically configure for memory and not changes in any sp_configure options.

SQL server is the only major application running on the machine.


Facts:
On that evening the I've checked the Task Manager and found that SQL Server use 500 MB in Mem Usage and 1200 MB in VM size.
In the query analyzer I execute the select query which results the "…insufficient system memory…" error on both databases and on the one with more data it failed with this error, but on the other database it completed successfully.
I restart SQL Server service to solve it, and as for today 28/12/04 at 08:00 it use 590 MB in Mem Usage and 590 MB in VM size.


I have checked the system with Performance monitor and didn't find any problems I use the Memory: Pages/sec, Memory: Available Bytes, Physical Disk: % Disk Time, Processor: % Processor Time, SQL Server Buffer: Buffer Cache Hit Ratio.

We have 8 user connections for one of the database and 16 for the other one.
Our system runs with this configuration for 2 months, I backup the databases FULL, DIFF and LOG backup.
It's not real time system, and the load on the SQL is medium, but we use bad queries as update for all fields in one query (please don't ask…)

I know that SQL server is greedy with the memory and released memory only if other process needs it.

Any ideas why it happens?

Thanks,
Yaniv

View 2 Replies View Related

Exclude Part Of The Code In A Transaction

Oct 25, 2007

Hello,

I have a TSQL (SQL SERVER 2005) code inside a Transaction,
I would like to exclude a piece of that code from the transaction (I do need to recovere it in the trasaction log).

For instance

BEGIN TRAN

SQL Statement 1
SQL Statement 2 -- out of the transaction
SQL Statement 3

COMMIT TRAN

I would like to exlude SQL Statement 2 (SQL statement1 and 3 must be inside the same transaction)

Is it possible? How to do it?

Thank

View 8 Replies View Related

Exclude Piece Of Code From Transaction

Mar 20, 2008



Hello,

I have created a procedure with several SQL statement, all are included in a transaction.
Some of the code are "insert" in tables that are in remote server.
for example:


procedure sp1 is on SERVER B.
From SERVERA by linked server we have:

exec serverB.db_B.dbo.sp1 (from serverA the procedure sp1 is called)


CREATE procedures sp1
AS
BEGIN TRANSACTION
insert into T1 (col1) values (1)
insert into serverA.db_A.dbo.T2 (col1) vales ('8vhrfvrf')
insert into T3 (col1) values (3)
COMMIT TRANSACTION
GO


I would like to make that these piece of code (
insert into serverA.db_A.dbo.T2 (col1) vales ('8vhrfvrf')
) is out of transaction.
My question is: Is it possible to exclude piece of code from a transction?


You ask me why this: because SQL server do not allow loopback transaction


Thank

View 7 Replies View Related

SQL Server 7 Error Code : 73301

Sep 28, 1999

Hi,

Do anyone know what's the error for code 73301?

Is there anyway for me to trace source of the error no?

The error msg is as below:
NSQL 73301: EXcProd does not exist (nsp_Archive_Table)

EXcProd is the database, where nsp_Archive_Table is the store procedure.
Actually, nsp_Archive_Table do exist in the database but the system keep saying that it's not.

Thanks

View 2 Replies View Related

SQL Server 2005 Code Error

Aug 18, 2006

Hey,

I need someone to look at a small piece of code and tell me where I'm going wrong in SQL 2005 Server. Where should I post?

Thanks in advance,

Danny

Problem: When I run this I'm told NoOfContractsCount is an invalid column name when I try creating my cusor

USE SLXDEV

SELECT Count(MCS2_CONTRACT.accountid) AS NoOfContractsCOUNT, MCS2_CONTRACT.accountid, CONTACTID

INTO #TempTable

FROM sysdba.MCS2_CONTRACT, CONTACT

WHERE MCS2_CONTRACT.accountid = CONTACT.accountid

GROUP BY MCS2_CONTRACT.accountid, CONTACTID

HAVING Count(MCS2_CONTRACT.accountid) > 1

DECLARE @CountTemp int

DECLARE @accountIDTemp CHAR(12)

DECLARE @ContactIDTemp CHAR(12)

DECLARE @AccountName VARCHAR(128)

DECLARE @LastName VARCHAR(32)

DECLARE @FirstName VARCHAR(32)

DECLARE @WorkPhone VARCHAR(32)

DECLARE @Fax VARCHAR(32)

DECLARE @Mobile VARCHAR(32)

DECLARE @Email VARCHAR(128)

DECLARE @Title VARCHAR(64)

DECLARE @UserField1 VARCHAR(80)

DECLARE @UserField2 VARCHAR(80)

DECLARE @UserField3 VARCHAR(80)

DECLARE searchCursor CURSOR

FOR

SELECT NoOfContractsCOUNT, accountid, ContactID

FROM #TempTable

OPEN searchCursor

FETCH NEXT FROM searchCursor INTO @CountTemp, @accountIDTemp, @ContactIDTemp

While (@@FETCH_STATUS <> -1)

BEGIN

IF (@@FETCH_STATUS <> -2)

BEGIN

PRINT 'GOT HERE'

SELECT @accountIDTemp = AccountID, -- SELECT DISTINCT?

@AccountName = Account, @LastName = LASTNAME, @FirstName = FIRSTNAME,

@WorkPhone = WORKPHONE, @Fax = FAX, @Mobile = MOBILE, @Email = EMAIL,

@Title = TITLE, @UserField1 = USERFIELD1, @UserField2 = USERFIELD2,

@UserField3 = USERFIELD3

FROM CONTACT

WHERE AccountID = @AccountIDTemp

declare @counter int

set @counter = 1

while @counter < @CountTemp

begin

INSERT INTO CONTACT(CONTACTID, ACCOUNTID, ACCOUNT,

FIRSTNAME, LASTNAME, WORKPHONE, FAX, MOBILE, EMAIL,

TITLE, USERFIELD1, USERFIELD2, USERFIELD3)

VALUES

(@ContactIDTemp, @accountIDTemp, @AccountName, @FirstName,

@LastName, @WorkPhone, @Fax, @Mobile, @Email, @Title,

@UserField1, @UserField2, @UserField3)

set @counter = @counter + 1

end

END

END

DROP TABLE #TempTable

View 6 Replies View Related

TRANSACTIONS In SSIS (error: The ROLLBACK TRANSACTION Request Has No Corresponding BEGIN TRANSACTION.

Nov 14, 2006

I'm receiving the below error when trying to implement Execute SQL Task.

"The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION." This error also happens on COMMIT as well and there is a preceding Execute SQL Task with BEGIN TRANSACTION tranname WITH MARK 'tran'

I know I can change the transaction option property from "supported" to "required" however I want to mark the transaction. I was copying the way Import/Export Wizard does it however I'm unable to figure out why it works and why mine doesn't work.

Anyone know of the reason?

View 1 Replies View Related

General Network Error: Is It My Code Or Our Server?

Mar 10, 2007

Hello everyone, this post will be a bit lengthy, so please bear with me.  I've been programming asp.net for abou 2 years.  I'm not a master by any means, and I do things like I learn from books.  Here is my standard way of connection to my mssql database (which is on the same server as my site, so I just use "localhost")  Dim objConnection As New SqlConnection(Application("dbstring"))
Dim strSQL As String = "SELECT * FROM myTable WHERE this='that'"
Dim objCommand As New SqlCommand(strSQL, objConnection)
Dim objDataReader As SqlDataReader

objConnection.Open()
objDataReader = objCommand.ExecuteReader()

Do While objDataReader.Read() = True
'Do what I need to do with the data
Loop

objDataReader.Close()
objConnection.Close()

objConnection.Dispose()Here's my issue. Our website gets this error 2-4 and as many as 6 or 7 times a day: General network error. Check your network documentation.Line ###: objConnection.Open()I use the method I wrote above for getting data on almost every page in the site. Its a HUGE site, but I've made sure that I close all my connections. This is my global connection string:  Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)        Application("dbstring") = "Server=WWW1;database=###;uid=#####;password=#####;Connect Timeout=300;Connection Reset=False;Pooling=False;Max Pool Size=75000;" End Sub Here's my web.config file:<configuration>    <system.web>        <customErrors mode="Off"/>    </system.web></configuration>... This server has only one website running on it, its a dedicated server. Is there something in my code causing this error to happen so much? We have to restart the sql server everytime this error happens for it to go away. Its very disruptive to the website.

View 8 Replies View Related

SQL SERVER Error Code For System.InvalidCastException

Apr 22, 2008

Can anyone give me the error code for System.InvalidCastException in sql server .......need it urgently.......

View 8 Replies View Related

Error Code 17122 On Server Boot

Feb 16, 2001

What causes this error, what is the fix ???
No information on the microsofsite !! What a surprise

View 3 Replies View Related







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