Sequence Container && Error Message Question

May 17, 2007

Hi,



I have a sequence container that contains a bunch of tasks.



I have a failure constraint that goes from the sequence container to execute sql task. The execute sql task then sends out an email upon a failure of the container, which is triggered by the failure of any given task inside the container.



My question is, is there a way to pass a SPECIFIC error message to the execute sql task?? That is, if one of the components inside the sequence container fails, I would like the email message to reflect the error message of that particular component, not just that the container failed, as there are different levels of severity of errors, depending on which component failed.



Thanks much



View 5 Replies


ADVERTISEMENT

Cannot Delete Sequence Container Error: Collection Cannot Be Null. Parameter Name: C

Jan 26, 2006

I have a Sequence Container with an Exec SQL Task in it. I can't delete the task or the container. I can't disable them.

Here's how I got there:

I put a Dataflow Task and the Exec SQL Task in the container, then set a precedence constraint. Lots of complaints moving either of them. Managed to delete the Dataflow Task, but now can't do anything.

Any dieas?

Laurence

View 1 Replies View Related

Loop Container Inside A Sequence Container

Jul 25, 2007

Has anyone ever seen this issue?



If i place a loop container inside a sequence container the connectors within the loop container disappear.... is this a bug - will the loop tasks still run in the correct order?? or will they fire off willy nilly??







View 4 Replies View Related

Error Message: Script Task, For Loop Container

Apr 23, 2008

I everyone,
I'm learning SSIS from a book but the most simple example is not working.
The "For each task" I assigned "xyz" as name.
I added a variable onto the "variables" window and called it "counter" Its scope was set to "xyz".
Inside the "for loop" ("xyz") editor i assigned values as follows:
"initexpression"-"@counter=0"
"eval expression"-"@counter<5"
"assign expression"-"@counter=@counter+1"

I added "Script task" onto the "For each" container and into the "Script task editor" I assigned
the following values:
"ReadOnlyVariables"-"counter"
Its design script is set to:

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain
Public Sub Main()
Dim variables As Variables
If Dts.Variables.Contains("Counter") = True Then
Dts.VariableDispenser.LockOneForRead("Counter", variables)
End If

MsgBox("You are in iteration: " & CStr(variables("Counter").Value))
Dts.TaskResult = Dts.Results.Success

End Sub
End Class

Runnig it i get the following error message:quote:
"DTS Script task has encountered an exeption in user code:
Project name:ScriptTask_e7d98dbad0de4041bcdc9079a5c2fa65
Object reference not set to an instance of an object.."
The line where the error occurs is from within the above script:
"MsgBox("You are in iteration:" " & CStr(variables("Counter").value))
Anyone understands what that means? What is "object reference" and how do i set it to an instance of an object?
Thanks

View 4 Replies View Related

For Loop Container, Script Task: An Error Message

Apr 23, 2008

I everyone,
I'm learning SSIS from a book but the most simple example is not working.
The "For Loop task" I assigned "xyz" as name.
I added a variable onto the "variables" window and called it "counter" Its scope was set to "xyz".
Inside the "for loop" ("xyz") editor i assigned values as follows:
"initexpression"-"@counter=0"
"eval expression"-"@counter<5"
"assign expression"-"@counter=@counter+1"

I added "Script task" onto the "For each" container and into the "Script task editor" I assigned
the following values:
"ReadOnlyVariables"-"counter"
Its design script is set to:[code]
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain
Public Sub Main()
Dim variables As Variables
If Dts.Variables.Contains("Counter") = True Then
Dts.VariableDispenser.LockOneForRead("Counter", variables)
End If

MsgBox("You are in iteration: " & CStr(variables("Counter").Value))
Dts.TaskResult = Dts.Results.Success

End Sub
End Class
[/code]
Runnig it i get the following error message:









DTS Script task has encountered an exeption in user code:
Project namecriptTask_e7d98dbad0de4041bcdc9079a5c2fa65
Object reference not set to an instance of an object..
The line where the error occurs is from within the above script:
[code]
"MsgBox("You are in iteration:" " & CStr(variables("Counter").value))[/code]
Anyone understands what that means? What is "object reference" and how do i set it to an instance of an object?
Thanks

View 22 Replies View Related

Sequence Container

Apr 26, 2006

i am trying to insert data into a table and roll back if this fails. What i have done is created an Execute SQL task with a SQL statement of BEGIN TRANS .. if the constraint = success then it goes to a Sequence Conatiner that amoungst other thing includes an Execute SQl task that does INSERT statement . outsied of the container i have 2 execute sql tasks that to a COMMIT TRANS ond a ROLLBACK Trans . when executing it i get an error the Rollback Transaction request has no corrasponding Begin tranaction. I have seen this in a SSIS created by one of the Wizards and it works fine, im oviously missing something fundemental .. any pointers ?

View 1 Replies View Related

Sequence Container And Checkpoints

Mar 6, 2008



hi people, i have crashed on a this problem. I have a sequence container and on this container I have set "FailPackageOnFailure=true". Now in this container there are 2 tasks. The first one is preceeding the second one. Now both this task have set "FailParentOnFailure=true". Both task are the same and their purpose is to drop table A.

1) I run the package and it fails, because there is no table to drop.
2) I create the table manualy and run package again.
3) I see, that the first task is beeing just SIMPLE OMMITED and the second task runs

In general, everytime any task in a sequence container invokes failure, next time is beeing ommited regardelss of its status. How can this be fixed ? Thanks

View 4 Replies View Related

Validating Sequence Container Freeze

Feb 16, 2007

I am attempting to open up my ssis integration project but when I try to open up packages it says @ the bottom "Validating Sequence Container" and it just stays there. I cannot click on anything and nothing is responsive. Does anyone know why this is happening?

View 9 Replies View Related

Creating Custom Sequence Container

Oct 4, 2006

I have a package that is going to have roughly 20 sequence containers in it. Each of these containers is going to have the same start task and the same end task. The data flow task(s) in each sequence container will differ. So I was thinking I would create a custom sequence container that would implement the common steps I need in each of my containers. I started to create a task that would inherit from Sequence, but I found that it is sealed. Bummer.

What is involved in creating a sequence task by inheriting from Task? I see that Sequence implements IDtsSequence. But looking at this interface, it seems like I would have to build the logic to execute the workflow contained in my sequence.

Any pointers?

-Darrell

View 6 Replies View Related

How To Set The Disable Property At Runtime For Sequence Container

Nov 8, 2006

I have a package that contains multiple SEQUENCE CONTAINERS,
each execute a bunch of tasks. I try to use the script task to dynamically
disable or enable each of these SEQUENCE CONTAINERS base on parameters that pass
in from parent package, but for some reason, I can€™t set the disable value to
True/False at runtime. Anyone knows how to do this?

View 5 Replies View Related

Strange Behaviour With Sequence Container Task

Sep 21, 2006

Hi everyone,
 
Our VB application throws .dtsx on-demand by using Threads. Everything's fine but a little detail:
when it goes to launch a SSIS package with a only task, concretely a Sequence Container task (empty, without tasks inside) fails Prevalidate method.
 
Attach you the snippet of code:
 
 
pkgResults = pkg.Validate(Nothing, Nothing, EventsSSIS, Nothing) -- pkgResults returns me Failure {1}
 
If pkgResults = DTSExecResult.Success Then
..
..
 
Validate method, as usual, do EVENTSSSIS.PreValidate event and after that, returns instead of follow raising events.
 
Perhaps it's mandatory to set one task as a minimum, I don't get the point at all
 
Any guidance or thought will be welcomed,
 
Thanks in advance and regards,

View 5 Replies View Related

Sequence Container Allows Bleedthrough Of Constraint Objects

Jan 10, 2008



I am working with SSIS and use Sequence Conatiners extensively. I have become frustrated enought to stop what I am doing and create this thread in the MSDN SSIS forum.

When working with expanded container objects, constraint objects connecting control objects not in the container can be seen. The control object is hidden (sent ot back) but the constraint objects remain visible (sent to front.)

This is extremely frustrating as the unwanted constraint object can be interacted with and not only interfers with the visual presentation during design, it also allows for unintended changes.

I have implemented SSIS upgrades from MDSN but either haven't implemented the appropriate upgrade or an upgrade doesn't exist for this.

Are there any suggestins or comments that can help me get my sanity back?

Yours,

srankin1957

View 5 Replies View Related

Integration Services :: Precedence Constraint For Sequence Container

May 16, 2015

I have (6) sequence containers, each with a data flow task and script task. The script task renames the file and the data flow uses an OLE DB Source connection to export to a flat file using the Flat File Destination connection.For sI have been unable to move from the 1st sequence container to the 2nd (and the next and so on...). I am trying to do this "on success" (on failure I generate an email notification within each container), but am apparently missing a piece to this because after the sequence container executes, which it does successfully, nothing happens.

View 4 Replies View Related

SSIS Sequence Container,data Flow Task

Nov 28, 2005

I am creating a staging database in which I am loading required tables from 2 different sources.
I have 30 different tables to load from source 1 and 10 different tables from source 2.
This is the way I am doing, in Control flow task I am using Sequence container and in that I included the data flow task, the data flow task
has source OLD DB connection from where I select the table and then destination OLE DB connection where I load the data.
So for 30 tables I have one Sequence container with 30 different data flow task and each data flow task has OLE DB source and OLD DB destination.
I wanted to find out if this is the efficient way to do, or if there is any other way to do this.
And for source 2 shall I put in another package or shall I use the same package with different sequence container and follow the same steps
as for Source 1 tables.
Please advice.
Thanks,

View 19 Replies View Related

Integration Services :: Can Sequence Container Have Multiple Checkpoints

Sep 21, 2015

I have a sequence container in my Package and this sequence has more than one control flow tasks.

Can I create the checkpoints such that only the failed component inside the sequence container runs again and not the other successful components/tasks in the sequence container?

View 3 Replies View Related

Integration Services :: Expressions Not Working After Exiting A Sequence Container?

Sep 21, 2015

I have an SSIS package that is pretty simple.

An Execute SQL task returns one row with two values that are correctly stored into variables.

Based off those two variables, a sequence container is chosen to execute.

That sequence container then does magic. The last step of the container has an execute SQL task that runs and stores the result in a variable - let's call this[User::result] with type Int32.

Based off the value in [User::result] one of two final tasks run. A non zero value executes one task; a zero value executes another. Basically,SOMETHING runs after this.

Simple? I thought so... except Step 4 doesn't work. If I set a post-execute breakpoint on the sequence container, the variables are populated as expected, but nothing else runs. If I add another task to run (without a conditional expression) to run after the sequence container completes, the pre-execute breakpoint shows the data looking exactly as I expect.

Those script tasks are just MessageBox.Show calls and the expression, as you can see, doesn't use variables at all.

View 5 Replies View Related

Integration Services :: Sequence Container Doesn't Alert Failures

Aug 19, 2015

I have a sequence container with 2 task into. If one of the tasks alert a failure then the sequence container should alert a failure too, but it doesn't. For testing I forced the error with setting the attribute ForceExecutionResult to Failure for one of the tasks. The task fails, but the sequence container succeeds.

I tried:

- changed the Precedence Constraints from AND to OR between the 2 tasks into the sequence container
- changed the attribute FailPackageOnFailure setting True
- changed the attribute FailParentOnFailure setting True

but nothing happened.

View 2 Replies View Related

Pre-Execute AcquireConnection Method Call Fails Inside Sequence Container (transaction Required)

Jun 1, 2006

I've created an SSIS package that contains a Sequence Container with TransactionOption = Required. Within the container, there are a number of Execute Package Task components running in a serial fashion which are responsible for performing "Upserts" to dimension and fact tables on our production server. The destination db configuration is loaded into each of these packages using an XML configuration file. The structure of these "Upsert" packages are nearly identical, while some execute correctly and others fail. Those that fail all provide the same error messages.

These messages appear during Pre-Execute

[Insert new dimension record [1627]] Error: The AcquireConnection method call to the connection manager "DW" failed with error code 0xC0202009.

[DTS.Pipeline] Error: component "Insert new dimension record" (1627) failed the pre-execute phase and returned error code 0xC020801C.

... which are followed by

[Connection manager "DW"] Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.".

[Connection manager "DW"] Error: An OLE DB error has occurred. Error code: 0x8004D00A.

While still in debug mode, I can check the properties of the "DW" connection and successfully test the connection within the packages that fail.

The same packages run successfully when tested outside the container (i.e. no transaction) or when the configuration file is modified to point the "DW" connection to a development version of the db which is running on the same server as the source database.

I have successfully used DTCtester to verify that transactions from source to destination server are working correctly. Also tried setting DelayValidation = True with no change. I have opened a case with Microsoft and am awaiting a reply so I thought I'd throw a post out here to see if anyone else has encountered this and might have a resolution. Here's some more on the environment:

Source Server:

Windows Server 2003 Enterprise Edition SP1
SQL Server 2005 Enterprise Edition SP0

Destination Server:

Windows Server 2003 Enterprise Edition SP1
SQL Server 2000 Enterprise Edition SP3 (clustered)

Thank you in advance for any feedback you might be able to provide.

KS

View 4 Replies View Related

Clear Error In For Each Loop Container

Jul 26, 2007

Hi,
I have a "Data Flow Task" inside" For Each container". Data flow task is processing file and updating the DB.
If one of the file is correpted i want to move to error folder and continue with the next file. i have given red arrow to a script Task which move the file to error folder. but its not continuing with next file. how can Ido that?
Any help

View 3 Replies View Related

[File System Task] Error: An Error Occurred With The Following Error Message: Access To The Path Is Denied

Sep 7, 2007

Hi -

I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:

[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".

Where do I change the security settings?

Thanks - Grace

View 5 Replies View Related

[XML Task] Error: An Error Occurred With The Following Error Message: There Are Multiple Root Elements.

Aug 18, 2006

I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:

[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".

The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:

<?xml version="1.0" encoding="UTF-8"?>
<ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>

There is only 1 ESDU root element and only 1 package element.

Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/>

<xsl:template name="identity" match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="kw">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsl:attribute name="ihs_cats_seq" select="position()"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>

</xsl:stylesheet>


Its 5th line is the first xsl:template element.

What is going on here? I do not see multiple root elements in either the XML document or the XSLT stylesheet.

Thanks!

View 5 Replies View Related

Sequence Clustering Error

Oct 10, 2006

I get this message when I deploy my sequence clustering model:

Error 1 Error (Data mining): Duplicate Key Sequence values in an input case for SeqCluster. Ambiguous case(s) may lead to unreliable results. Disambiguate the data (recommended) or increase ErrorLog KeyErrorLimit server parameter. 0 0


I don't have any duplicate keys in my case table. I'm using a date for my key sequence column in my nested table. Is that the problem?

View 3 Replies View Related

How To Catch An Error Raised In The Forach Loop Container And Perform Cleanup Jobs Accordingly?

Nov 29, 2007

Hello everyone,

I have a package that should accomplish the following task:
- Loop on all files in a given directory.
- Before proccessing the current file in the Enumerator, it should be moved to a folder called "importing"
- Load the content of the file into a destination DB.
- After a successfull load, the file is moved from the "importing" to the "success" folder.
- If anything went wrong during the load process, the file should be moved from the "importing" to the "error" folder and an e-mail should be sent out to a certain admin account.

What I have done so far:
My control flow looks like this:
Foreach Loop containing the following tasks:
- File System Task: moving the current file from its original path to the "importing" folder
- Data Flow Task1: performing some transformations and insertions into the DB and raw files.
- Data Flow Task2: performing some transformations and insertions into the DB and raw files.
- Data Flow Task3: performing some transformations and final insertions into the DB.
- File System Task: moving the current file from the "importing" to the "success" folder

Question:
I do not know how to catch the event that one of my three Data Flow Tasks has failed and in this case perform two simple tasks, namely...
- File System Task: moving the current file from the "importing" to the "error" folder
- Send Mail Task: sending a configured e-mail message to a ceratin administrator.

Thanks in advance...

Regards,
Samar

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

Error When Using A Create Table Execute SQL Task Statement In Control Flow Prior To Using An OLE DB Destination Container...

May 18, 2008

SSIS Newbie Question:

I have a simple Control Flow setup that checks to see if a particular table exists. If the table does not exists, the table is created in an alternate path, if it does exist, the table is truncated before moving to a file import Data Flow that uses an OLE DB Destination to output the imported data.

My problem is, that I get OLE DB package errors if the table the OLE DB Destination Container references does not exist when I load the package.

How can I over come this issue? I need to be able to dynamically create the table in an earlier step, then use that table to import data into in a later step in the workflow.

Is there a switch I can use to turn off checking in the OLE DB Destination Container so that it will allow me to hook up the table creation step?

Seems like this would be a common task...

Steps:

1. Execute SQL Task to see if the required table exists
2. Use expresions to test a variable to check the results of step 1
3. If table exists, truncate the table and reload it from file in Data Flow using OLE DB Destination
4. If table does not exist, 1st create it, then follow the normal Data Flow

Can someone help me with this?

Signed: Clueless with a deadline approaching...

View 3 Replies View Related

Getting Access Denied To FileName Error When Using The Execute Sql Task (With File Connection) Into A Foreach Loop Container.

Jan 18, 2007

Hi ALL,

Getting Access Denied To FileName Error When Using the Execute Sql Task (With File Connection) into a Foreach Loop Container.

Please Note :

I have a folder containing .sql files. I have to dynamically loop through the files and send them as a File connection Folder to the Execute Sql Task.

When I run this Package I am getting the follwoing error :

[Execute SQL Task] Error: An error occurred with the following error message: "Access to the path 'C:ProjectsFuzzy Lookup DataFlow ExampleScripts' is denied.".

Also I have logged in to the machine as Administrator and to Sql Server with sa.

Please help.



Thanks.

Regards,

Salil

View 1 Replies View Related

SQL Server 2008 :: ODBC Function Sequence Error

Apr 13, 2015

We are trying to upgrade a SQL server 2000 to a SQL 2008 R2 (SP1) server. After migrating, the developer test code, and got an error: ERROR [HY010] [Microsoft][ODBC SQL Server Driver]Function sequence error...But this is a release for 2008, ours is already 2008 R2 SP1, so that hot fix should already be included since it is always cumulative.

View 2 Replies View Related

Foreign Language/function Sequence Error Problem

Jul 13, 2007

Am using sql 2000 to store data in the greek language. Using delphi built program to enter the data. The delphi program communicates with sql server via the ODBC connection I created. When I type in above 150 characters in a varchar column that can hold 600, the message (odbc manager - function sequence error) appears and does not allow me to save. However if I type in the english language, it saves without a problem. Here's the strange one-- if I type very very slowly in the greeek language it will save! Am using Windows XP english version.

Any ideas? I have spent above a month on this one!!

View 11 Replies View Related

Sequence Timeout - SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Apr 24, 2007



Help please...



in first package of a migration solution (6 packages), have got a sequence container that "loops around" setting up initial mapping data for 17 tables (each table has 2 tasks within the control flow - purge / clean out and then re-populate - ).



the package has "transactionOption" set to required, as does the sequence container.



when i run the individual control flows, all goes ok



when i run the sequence container on the server (same one as database), all goes ok.



when i run the sequence container on my PC via VisualStudio 2005, get the above mentioned error code...


Task Purge FirstContactMethod_Mapping Table
Start, 11:00:14 a.m.
Validation has started
Validation is completed
Progress: Executing query "DELETE FROM zMapping_FirstContactMethod". - 100 percent complete
Finished, 11:00:14 a.m., Elapsed time: 00:00:00.031
Task Load FirstContactMethod_Mapping Table
Start, 11:00:14 a.m.
Validation has started
[DTS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
Progress: Validating - 33 percent complete
Progress: Validating - 66 percent complete
Progress: Validating - 100 percent complete
Validation is completed
[DTS.Pipeline] Information: Prepare for Execute phase is beginning.
Progress: Prepare for Execute - 0 percent complete
Progress: Prepare for Execute - 33 percent complete
Progress: Prepare for Execute - 66 percent complete
Progress: Prepare for Execute - 100 percent complete
[Create FirstContactMethod_Mapping Table [56]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Source_OLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[DTS.Pipeline] Error: component "Create FirstContactMethod_Mapping Table" (56) failed the pre-execute phase and returned error code 0xC020801C.
[DTS.Pipeline] Information: Cleanup phase is beginning.
etc...
etc...





this also occurs on a second migration solution we have developed.



in both cases, it occurs after c. 30 seconds of operation



for the above error, SSIS is trying to open the table to do a "OpenRowset Using FastLoad" - with the CommandTimeout set to 0.



we do not think it is due to the transaction being set - was occuring before we added transactions - think it is a timeout within the container object. We have set the CommandTimeouts to 0 for all of the purge commands and the re-populate commands)



environment is VS2005 on my PC, SQL2005 SP2 on server



have searched Google for this error - and whilst there are many entries, not many answers...



thx



mark



View 11 Replies View Related

I Am Getting An Error Message When I Try To Print Using Reporting Services: An Error Occurred During Printing (0x80004005)

May 22, 2007

I am getting an error message when I try to print using reporting services: "an error occurred during printing (0x80004005)"

View 4 Replies View Related

SQL Server Error Message - Operating System Error 10038: An Operation Was Attempted On Something That Is Not A Socket...

Nov 20, 2006

My apologies...I wasn't for sure where to post an error like this...

Over the last 2 months I have gotten this SQL Server error (twice). All existing processes will continue to work, however no new processes can be created and users cannot connect to the server. This is the exact text of the message in the SQL Server error log.

Operating system error 10038: An operation was attempted on something that is not a socket...

Error: 17059, Severity: 18, State: 0

Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing.

Error: 17882, Severity: 18, State:

While we can typically just stop SQL Server Service and restart the services...I have found it is best to restart the machine during non-production times to take care of any 'residual' effects of this error.

The SQL Server 2000 SP4 box with Windows 2003 Standard SP1 is well maintained by our I.T. team and it typically will run 4 or 5 months without a reboot.



Thank you...

...cordell...

View 5 Replies View Related

Error While Calling The Roles.AddUserToRole (error Message: Cannot Resolve Collation Conflict For Equal To Operation)

Feb 5, 2006

Hi, I have developed a website in asp.net 2. I have tester it and it is working fine on my computer but when I have uploaded it to my server I'm getting an error message when the user signup. The error occurs when I'm setting the user role to 'members'.
 
Error line > Roles.AddUserToRole(user.UserName, "members")
 
The strage thig is that it is working on my computer but not on the server. My home computer and the server are running the same software versions and the website database is the same as well.
 
To double check that my code is not generating the error I have lonched 'SQL Query Analizer' and executed the folowing code on my database:
NOTE: In my database I have create the user “teeluk12� and a role “members�
 
aspnet_UsersInRoles_AddUsersToRoles "/", "teeluk12", "members", "5/02/2006 4:44:33 pm"
 
Once again the code is working on my home computer but not on the server. On the server I'm getting the following error:
 
Server: Msg 446, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 76
Cannot resolve collation conflict for equal to operation.
 
 
 
Does anybody know what could cause the error?
Could it be some permissions that I didn't set on my server?
 
 
Thanks for my help and suggestions...
Regards,
Gonzal
 

View 9 Replies View Related

Famous Named Pipes Provider, Error 40 Error Message

Oct 18, 2007

Trying to connect to remote server croaktoad.simpli.biz
I have SQL 2005 Developer on XP SP2 , I have disabled my windows firewall. I can ping to my server (croaktoad.simpli.biz) and i get no error message. My remote connection using both TCP/IP and named pipes are checkeed. My SQL Server Browser is running as well.

However when I try to connect using Managment Studio or running SQLCMD /Scroaktoad. simpli.biz /E I get the following error message

C:sqlcmd /Scroaktoad.simpli.biz /E
HResult 0x52E, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [1326].
Sqlcmd: Error: Microsoft SQL Native Client : 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired


So I've read all the forums for past 2 days and tried everything, nothing changed Any ideas?

View 4 Replies View Related







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