Error:SqlConnection Does Not Support Parallel Transactions

Jul 17, 2006

This is my code in vb.net with Sql transaction
I am using insertcommand and update command for executing the sqlquery
in consecutive transactions as follows.
How can I achive parallel transactions in sql
------------------start of code---------------------
try
bID = Convert.ToInt32(Session("batchID"))
                    strSQL = ""
                    strSQL = "Insert into sessiondelayed (batchid,ActualEndDate) values (" & bID & ",'" & Format(d1, "MM/dd/yyyy") & "')"

                    sqlCon = New System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("conString"))


                    Dim s1 As String = sqlCon.ConnectionString.ToString
                    sqlDaEndDate = New System.Data.SqlClient.SqlDataAdapter("Select * from sessiondelayed", sqlCon)
                    dsEndDate = New DataSet
                    sqlDaEndDate.Fill(dsEndDate)

                    dbcommandBuilder = New SqlClient.SqlCommandBuilder(sqlDaEndDate)

                    'sqlCon.BeginTransaction()
                    'sqlDaEndDate.InsertCommand.Transaction = tr
                    If sqlCon.State = ConnectionState.Closed Then
                        sqlCon.Open()
                    End If
                    sqlDaEndDate.InsertCommand = sqlCon.CreateCommand()
                    tr = sqlCon.BeginTransaction(IsolationLevel.ReadCommitted)
                    sqlDaEndDate.InsertCommand.Connection = sqlCon
                    sqlDaEndDate.InsertCommand.Transaction = tr
                    sqlDaEndDate.InsertCommand.CommandText = strSQL
                    sqlDaEndDate.InsertCommand.CommandType = CommandType.Text


                    sqlDaEndDate.InsertCommand.ExecuteNonQuery()
                    tr.Commit()
                    sqlDaEndDate.Update(dsEndDate)
                    sqlCon.Close()
                End If
            Catch es As Exception


                Dim s2 As String = es.Message
                If sqlCon.State = ConnectionState.Closed Then
                    sqlCon.Open()
                End If
                strSQL = " update SessionDelayed set ActualEndDate= '" & Format(d1, "MM/dd/yyyy") & "' where batchid=" & bID & ""
                sqlDaEndDate.UpdateCommand = sqlCon.CreateCommand()
                tr1 = sqlCon.BeginTransaction(IsolationLevel.ReadCommitted)
                sqlDaEndDate.UpdateCommand.Connection = sqlCon
                sqlDaEndDate.UpdateCommand.Transaction = tr1
                sqlDaEndDate.UpdateCommand.CommandText = strSQL
                sqlDaEndDate.UpdateCommand.CommandType = CommandType.Text
                sqlDaEndDate.UpdateCommand.ExecuteNonQuery()
                tr1.Commit()
                sqlDaEndDate.Update(dsEndDate)
                sqlCon.Close()

 

            End Try

'-------------End----------------

View 1 Replies


ADVERTISEMENT

SqlConnection Does Not Support Parallel Transactions.

Mar 27, 2006

hello

i have a problem when i try to begin transaction in sql

this is the massege

"SqlConnection does not support parallel transactions."

but the connection dosent have another transAction

what can i do

thanks

View 7 Replies View Related

Parallel Transactions Error

Aug 21, 2007



Hi,All.
I'm writing test cases on C# for a few methods that make changes in database.To prevent making changes I used BeginTransaction-Rollback,everything was good.But this doesn't work if tested method has BeginTransaction-Rollback code itself.An error appears in NUnit: System.InvalidOperationException : SqlConnection does not support parallel transactions.
Do smb know how to solve the problem?

*******************************tc below********************
[Test]

[Category("Access")]

public void UpdateGroupUserTable(/*Int32 userID, GroupList dataset*/)

{

r.BeginTransaction();

try

{

r.UpdateGroupUserTable(userId,gl);

}

finally

{

r.Rollback();

}
*******************************tested method below********************

public void UpdateGroupUserTable(Int32 userID, GroupList dataset)

{

CheckDisposed();

UpdateCommand.CommandType = CommandType.Text;

UpdateCommand.Parameters.Clear();

UpdateCommand.Parameters.Add("@USERID", userID);

BeginTransaction();

try

{

Adapter.Update(dataset.acl_group);

Commit();

}

catch (SqlException)

{

Rollback();

throw;

}

}

View 5 Replies View Related

Does SQL Server CE Support System.Transactions?

Feb 15, 2007



Hi,

I've tried to enclose a few database operations in a TransactionScope block but it looks like SQL Server CE RM does ignores ambiental transaction.

Here is the code:

static void TestTxn() {
// Command to insert an integer in a table with a single integer column
string cmdPassText = "INSERT TESTTABLE (INTFIELD) VALUES(1)";
// Command to force field type mismatch exception
string cmdFailText = "INSERT TESTTABLE (INTFIELD) VALUES('Foo')";

using (TransactionScope scope = new TransactionScope()) {
using (SqlCeConnection conn = new SqlCeConnection("DataSource = 'Test.sdf'")) {
try {
conn.Open();
SqlCeCommand cmdPass = new SqlCeCommand(cmdPassText, conn);
returnValue = cmdPass.ExecuteNonQuery();
SqlCeCommand cmdFail = new SqlCeCommand(cmdFailText, conn);
returnValue = cmdFail.ExecuteNonQuery();
}
catch (Exception ex){
Console.WriteLine("Command failed");
Console.WriteLine("Exception Message: {0}", ex.Message);
}
}
scope.Complete();
}
}

After first command suceeds and seccond command failes table still has one affected row after transaction.

Am I doing something wrong or System.Transactions.Transaction is not supported with SQL Server CE RM?

Thanks,
Aleksandar

View 3 Replies View Related

Transactions, Package.transactionOption=support

Apr 12, 2006

I want to use transactions to protect my tasks. I have ten tasks that need to be completed in a single package. If any of the tasks fail - I need the entire process to rollback.

I have 5 execute sql tasks to truncate groups of tables in my destination database.

After each of the single truncate tasks - I use data flow tasks to copy the data from the source to the destination db.

Both dbs are on the same server.

I am basically copying the entire db - with the exception of a few tables.

package.transactionOption = required ,
and all tasks transactionOptions are set to supported.

Several questions. It seems to hang on the first data flow task - the output window stops, etc.

If I set package.transactionOption = supported - The package will execute.
If I create an error on the thrid truncate task - all previous tasks will complete - the package will fail on step 3 and the truncation for this step is not commited.

I am partially there. Can anyone help point me in the right direction? I need the entire process to commit if all tasks are successful or rollback if any fail.

thank-you in advance

Kim









View 1 Replies View Related

The Partner Transaction Manager Has Disabled Its Support For Remote/network Transactions.

Aug 23, 2006

I'm trying to run an SSIS package. The package runs on an SQL 2005 server on Win2k3 server. The package tries to connect to another win2k3 server with sql 2000 to retrieve some data. However, I recieve the errormessage shown in the topic.

I found info about modifying the MSDTC security settings under "component services" and did so. I made sure everything was allowed. However, the result was the same. Does anyone have any other idéa about what could cause this problem?

PS. The package works fine if I set up both databases on the same physical machine...

Regards Andreas

View 3 Replies View Related

Please Help Me Error In Sqlconnection

Jan 4, 2008

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
this problem occured when i rum my program which contain database connection
any one there can help me please?

View 6 Replies View Related

Error Executing Parallel SQL Tasks

Mar 29, 2006

I have three SQL tasks executing in parallel in an Integration Services package.

  +-B-+
A-+-C-+-E
  +-D-+

It starts with task A; then B, C, and D all execute in parallel; and finally task E runs after BCD are done.

B, C, and D are all Execute SQL tasks, all with the same connection manager. Here is their code:

B) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process
     FROM temp_B

C) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process
     FROM temp_C

D) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process
     FROM temp_D

Each one is setting a binary value to a package variable (using Result Set settings) based on the count of records from different tables.

This works with no problems when I run it against one server (development). But when I switch to the production server, task B and D both fail. I'v checked to make sure all of the temp tables exist in the database for that connection manager and that all three have the same connection manager - all is okay.

Here's the trickier part. When I'm still pointing to the production server and I run these tasks individually, they are all successful. It is only when they are attempting to run in parallel that they fail.

Here is the Output error:
Error: 0xC002F210 at Process Med?, Execute SQL Task: Executing the query "SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process FROM temp_B" failed with the following error: "Invalid object name 'temp_B'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

What could be causing this? I'm at a loss.

 

View 5 Replies View Related

SqlConnection Server Error

Dec 6, 2006

I am having a hard time finding information about this error
online.  I was hoping someone could help me with it.  I am working with
MS Visual Studio 2005.  The SQL Server version is 2000.  The error
bellow says I am trying to connect to SQL 2005.  Also, I can use MSVS
Server Explorer and SQL Server Enterprise Manager to connect to the
database.Here is my code:
 
imports System.data
Dim Connect As New SqlClient.SqlConnection
Dim Adapter As New SqlClient.SqlDataAdapter
Dim St As New DataSet
Dim ConnectString As String
ConnectString = "Data Source=MANDB01;Initial Catalog=MANCON_WEB;Integrated Security=True"
Connect.ConnectionString = ConnectString
Adapter.SelectCommand = New SqlClient.SqlCommand("select * from item_cat1", Connect)
Adapter.SelectCommand.Connection.Open()
Adapter.Fill(St)
Connect.Close()  
The browser is reporting this error: An error has occurred while establishing a connection to
the server.  When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider, error: 40 -
Could not open a connection to SQL Server)

View 3 Replies View Related

Parallel SQL Destination Load Pre-Process Error

Nov 16, 2005

I cannot find any information on this error. It occurs on packages that are writing to the same table using a sql server destination. I suppose it would be a good exercise in error handling, but I'd rather avoid it.

View 4 Replies View Related

Getting Error Type SqlConnection Is Not Defined...

Mar 10, 2008

I'm a noob to sql ce 3.5 and am getting the error "Type SqlConnection is not defined". I'm thinking this has something to do with the sql client not being installed but am not sure. I've tried adding - 'Imports System.Data.SqlClient' but it's not available, anyone ahave any ideas on how to fix this?

Thanks,

View 4 Replies View Related

SqlConnection Error( Unrecognized Escape Sequence )

Feb 16, 2008

 CSharp:SqlConnection Con = new SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True"); its give ErrorUnrecognized escape sequence 

View 12 Replies View Related

There Is Always An Error When I Want To Hardcode With SqlConnection. Pleas Help Me Check It.

Feb 14, 2006

I am currently using VWD. I only run my web applications with the Cassini. However, as long as I want to hardcode with SqlConnection object, an error occurs. I did a little bit modification to the following codes which use SqlConnection and was quoted from the book "Professional ASP.NET 2.0", Wrox. <%@ Page Language="VB" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Configuration" %> <script runat="server">         Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)         If Not Page.IsPostBack Then             Dim MyConnection As SqlConnection             Dim MyCommand As SqlCommand             Dim MyReader As SqlDataReader             MyConnection = New SqlConnection()            MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("ASPNETDB").ConnectionString             MyCommand = New SqlCommand()            MyCommand.CommandText = "SELECT TOP 3 * FROM Paspnet_Users"             MyCommand.CommandType = CommandType.Text             MyCommand.Connection = MyConnection             MyCommand.Connection.Open()            MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection)            gvCustomers.DataSource = MyReader             gvCustomers.DataBind()            MyCommand.Dispose()            MyConnection.Dispose()         End If     End Sub     </script> <html> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="gvCustomers" runat="server"> </asp:GridView> </div> </form> </body> </html> The error: System.NullReferenceException was unhandled by user code   Message="Object reference not set to an instance of an object."   Source="App_Web_v1u8yf_l"   StackTrace:        at ASP.sqlconnectiontest_aspx.Page_Load(Object sender, EventArgs e) in F:My DocumentMy StudySITMT4Introduction to ASP.NetMeowMeowShoppingCartSQLconnectionTest.aspx:line 13        at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)        at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)        at System.Web.UI.Control.OnLoad(EventArgs e)        at System.Web.UI.Control.LoadRecursive()        at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Please help me find out what's the problem. Thanks beforehand.

View 1 Replies View Related

Error 'Type 'SqlConnection' Is Not Defined' In VS2005/aspx.vb Files

Apr 17, 2008

 I defined the following connection string (strConn) and coded "Dim oConn As New SqlConnection(strConn)".In this VS 2005/ASP.net 2.0 program, 'SqlConnection' was underlined and showed 'Type SqlConnection is not defined' error. 
 What wrong with my VS 2005/ASPnet 2.0 coding, or SQL Server 2000 database configuration?
TIA,Jeffrey
connectionString="Data Source=webserver;Initial Catalog=Ssss;Persist Security Info=True;User ID=WWW;Password=wwwwwwww"providerName="System.Data.SqlClient"

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

DTS Transactions - Error

Mar 9, 2001

I have a DTS package which contains:
- 1 "Execute SQL" task
- 1 "Connection" object

The provider for the connection is SQLOLEDB ("Microsoft OLEDB Provider for SQL Server"), and this works just fine with transactions in ADO etc.
The MDAC version is 2.5, and the SQL Server Client Utils version is 7.0 SP2.

The package properties are set as follows:
- "Use transactions" is on
- "Auto commmit transaction" is on
- "Read committed" isolation level

The execute SQL task has the following workflow properties:
- "Join transaction if present" is on
- "Commit transaction on successful..." is on
- "Rollback transaction on failure" is on
- ("Execute on main package thread" just in case)

When I execute the package (from the designer, or cmd line), I get the following (most informative) error:
"Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: Unspecified error"


If I change the package properties to remove "Use transactions", it executes just fine.

Any ideas?

TIA

View 2 Replies View Related

Support For SQL Express2005 My Host Provider Does Not Provide Support?

Dec 5, 2005

Reader Community
I've just started hosting my newly created Microsoft Visual Web Developer 2005 Express Edition web site.  Unfortunately the Login group membership functions will not function correctly.  Having contacted the web service hosting provider, They replied: "We do not support SQL express2005.  The only way to use the extra functions of ASP.NET2 such as group membership is if it is using an SQL 2000 database to connect to. "
Is it possible to design web sites with Microsoft Visual Web Developer 2005 Express Edition that store membership details on an SQL 2000 database?
I've just paid £88 approx. $140 for a years subscription, have I chosen the wrong web service hosting provider?
Should I have designed the web site with a better web site design software tool that also makes designing membership login functionality easy, just as Microsoft Visual Web developer 2005 express edition?
Look forward to all comments?
Regards
 
Philip

View 1 Replies View Related

Error While Configuring XML Support In IIS With IIS 6.0

Dec 22, 2003

Hi,

I've two servers on which there is the SQL 2000 Server and the IIS 6.0.

I installed the SQL Server Client Tools on web server.

And created the nwind as told in booksonline.

I declared the SQLXML extention and allowed it using IIS 6.

But there is a problem with the virtual directory I created using the tool "Configure XML Support in IIS". Web server doesn't realize it as a virtual directory. Even a jpg or a text file is not served by the IIS.

The web server shows the following error.


ERROR: 500 Internal Server Error
HResult: 0x800706f4
Source: Microsoft SQL isapi extension
Description: Invalid virtual root settings



Thanks for any suggestions.

View 2 Replies View Related

Transactions With Containers Error

Apr 17, 2008



So I have a few data flow tasks that I need to all execute successfully before I commit the changes. So I use a few nested sequence containers with the parent set to Required and all of the children set to Supported. This should work right? Instead I get "The AcquireConnection method call to the connection manager "Databasenamehere" failed with error code 0xC0202009. If I switch the parent back to Supported or NotSupported it will execute fine.

HELP!

Thanks in advance!

View 2 Replies View Related

Changing Connection Transactions To Database Transactions

May 22, 2005

Hi there,
I have decided to move all my transaction handling from asp.net to stored procedures in a SQL Server 2000 database. I know the database is capable of rolling back the transactions just like myTransaction.Rollback() in asp.net. But what about exceptions? In asp.net, I am used to doing the following:
<code>Try   'execute commands   myTransaction.Commit()Catch ex As Exception   Response.Write(ex.Message)   myTransaction.Rollback()End Try</code>Will the database inform me of any exceptions (and their messages)? Do I need to put anything explicit in my stored procedure other than rollback transaction?
Any help is greatly appreciated

View 3 Replies View Related

Where Are Error Transactions Stored? Can They Be Edited Or Deleted?

Apr 2, 2007

Greetings,



We are using peer-to-peer transactional replication. When using the default agent profile, the replicator stops processing commands when it encounters an error. It appears to keep trying to apply the command that caused the error and essentially hangs on that command. We have changed our agent profiles to "Continue on data consistency errors" - not the kind of option to give you a warm fuzzy feeling but we just don't know what else to do.



Where are the commands that cause errors stored within the replication environment? Can they be individually viewed, edited, and/or deleted? We would like some alternative to "continue on data consistency errors."



Thanks,

BCB

View 5 Replies View Related

Error:The Query Designer Does Not Support The UNION SQL Construct

Jul 20, 2007

Here is an example of what I am exactly doing!! CREATE VIEW NamesAS SELECT ID, fName, lName FROM Table1 UNION ALL SELECT id, FirstName, LastName FROM TABLE2.  On Executing this...I'm getting the following error.





The Query Designer does not support the UNION SQL construct:    

View 2 Replies View Related

Managing Distributed Transactions With ADO.NET 2.0 Using TransactionScope Gives Error Message

Nov 14, 2007

 Hi, I am working  on vs2005 with sql server 2000. I  have used TransactionScope class. Example Reference: http://www.c-sharpcorner.com/UploadFile/mosessaur/TransactionScope04142006103850AM/TransactionScope.aspx   The code is given below.  using System.Transactions;   protected void Page_Load(object sender, EventArgs e)    {  System.Transactions.TransactionOptions transOption = new System.Transactions.TransactionOptions();         transOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;         transOption.Timeout = new TimeSpan(0, 2, 0);         using (System.Transactions.TransactionScope tranScope = new System.Transactions.TransactionScope(TransactionScopeOption.Required,transOption))         {            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["nwConnString"].ConnectionString))            {                int i;                con.Open();                SqlCommand cmd = new SqlCommand("update products set unitsinstock=100 where productid=1", con);                i = cmd.ExecuteNonQuery();                if (i > 0)                {                    using (SqlConnection conInner = new SqlConnection(ConfigurationManager.ConnectionStrings["pubsConnString"].ConnectionString))                    {                        conInner.Open();                        SqlCommand cmdInner = new SqlCommand("update Salary set sal=5000 where eno=1", conInner);                        i = cmdInner.ExecuteNonQuery();                        if (i > 0)                        {                            tranScope.Complete(); // this statement commits the executed query.                        }                    }                }            }            //  Dispose TransactionScope object, to commit or rollback transaction.        } } It gives error like
 "The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)" The database I have used is northwind database and pubs database which is by default in sql server 2000. So, Kindly let me know how to proceed further.  Thanks in advance,Arun. 

View 1 Replies View Related

Error Message 25080 The Operating System Does Not Support Encryption Again

Nov 19, 2007

A customer of my program is getting the SQL CE error message "The operating system does not support encryption".


I've seen several threads on this issue, but none of them seem to apply to my problem. This is a Windows Forms application, so no device and no web service.

The OS is a German Windows XP - so there shouldn't be any issues regarding strong encryption. It even runs in Windows 2000 in our test VPC.

We're using SQL CE 2005.

Any ideas what I could check?

View 1 Replies View Related

Problems Using Error Row Redirection And Transactions In A Data Flow Task

Mar 22, 2007

I am having a problem getting error rows to redirect between an OLE DB Source and an OLE DB Destination when using transactions. Each time I turn on the transaction control I get an error stating:

"[OLE DB Destination [48]] Error: The input "OLE DB Destination Input" (61) cannot be set to redirect on error using a connection in a transaction."

I get the above Error when using MSDTC. I have the data flow inside of a Sequence Container with the transaction option set to REQUIRED and the Isolation Level set to Serializable. I have tried all the Isolation levels.

I have the error rows piped off to a seperate OLE DB Destination. I have also tried using native SQL transactions with Execute SQL tasks to BEGIN, COMMIT or ROLLBACK the transaction. This does not work either. It looks like it works properly when the data flow is successful but using profiler I can see SSIS opens up a seperate process for the BEGIN and then another one with the Data Flow task. When I intentionally fail the Data Flow the Rollback always fails. I made sure I had RetainSameConnection turned on for the Connection I was using.

I am speculating that the Data Flow does not know what to Rollback the actual rows that succeeded or the error rows that are getting piped off.

I am fairly stumped on this one so any help is appreciated.

Thanks

View 4 Replies View Related

Error 1601 Installing Microsoft SQL Server 2005 Setup Support Files

Dec 26, 2007

Hi guys,


I have problems installing SQL server 2005, any help ??
Tks...

This is the log file description...

=== Verbose logging started: 25/12/2007 21:05:41 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Archivos de programaMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (AC:50) [21:05:41:656]: Resetting cached policy values
MSI (c) (AC:50) [21:05:41:656]: Machine policy value 'Debug' is 0
MSI (c) (AC:50) [21:05:41:656]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (AC:50) [21:05:41:656]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (AC:50) [21:05:41:656]: Grabbed execution mutex.
MSI (c) (AC:50) [21:05:41:671]: No se puede conectar al servidor. Error: 0x80040154

MSI (c) (AC:50) [21:05:41:671]: Failed to connect to server.
MSI (c) (AC:50) [21:05:41:671]: MainEngineThread is returning 1601
=== Verbose logging stopped: 25/12/2007 21:05:41 ===

View 11 Replies View Related

Error 1603 Installing Microsoft Sql Server 2005 Setup Support Files

Feb 13, 2008

I'm attempting to install the standard version of SQL server 2005 on XP SP2. I'm getting the following:

Errors occurred during the installation:
Error 1603 installing Microsoft SQL Server 2005 setup support files.

View 11 Replies View Related

ADO Error 3251: Current Provider Does Not Support Returning Multiple Recordsets From A Single Execution?

Jul 20, 2005

I posted this in the MS Access group, but no luck.------------------------------------------I've got another stored procedure in the same app that returns multiplerecordsets and the code works.But now I've written another SP and the code traps out with the 3251 message.The SP is writing two recordsets.When I run the SP in Query Analyzer, both recordsets appear.But when I step through the code, when the first RS should be there, it's"Closed" and nothing I've tried will make it open.Provider=SQLOLEDB.1 (which works on the other screen...)Seems like I've been here before, but I can't remember what the problem was.--PeteCresswell

View 7 Replies View Related

Help Needed On A Error From Sql Profiler Login In , The Same Id Can Be Connected With Studio , Pfytil Doesnt Support Encruption

Jan 21, 2008



TITLE: Connect to Server
------------------------------

Cannot connect to xxx
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Client unable to establish connection
Encryption not supported on the client.
(pfutil90)

------------------------------
BUTTONS:

OK
------------------------------




timely help is much appreciated

View 1 Replies View Related

MDAC 2.8 Fatal Setup Error. This Setup Does Not Support Installing On This Operating System

Jan 5, 2006

I have XP Pro SP2 with MDAC 2.8.1022.  It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.

I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP.  There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs. 

There's some other strange things, so I wonder if they are related. 

1) I have Paul set up as an administrator account.  Some folders like MSSQL show that account with no permissions.  I grant all the permissions to Paul for that folder.  I come back later and the permissions are gone.

2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared.  I deleted those 7 again and then they finally went away.

3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.

 

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

Re-indexing In Parallel

Apr 25, 2001

Hi All,

I am working on SQL Server 7.0. Every weekend we go for reindexing of some tables. I want to know if it is possible to run the re-indexing of tables in parallel so that I can save time.

Our database is of size 80GB and one table is around 22GB. Rebuilding of index on this table takes a lot of time and we are unable to index the other tables.

Any solutions/suggestions are mostly appreciated.

Regards,

Mitra

View 2 Replies View Related

Parallel Execution

Nov 11, 2005

Hi

View 5 Replies View Related







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