My group has recently begun ramping up #of users from 5-10 to 50 concurrent. I'm currently using a 10Mb/s Ethernet but am not sure if there is a fiber
or multiplexing solution that I could use to increase output. Basically, we're looking at up to 50 heavy duty data pulls (50MB+) at any one time.
Thanx,
Joe
I have a problem with a PIPE "|" delimited flat file. I have a column "Description" in which we get a string in which we have PIPE "|" as data. How we can skip this and load it as a data into the column Description.
View 7 Replies View RelatedHello,I was wondering is the following is correct with the network packet size.I've installed sql server 2000 and made some changes in the configuration.Now i've read that sql server's default network packet size is 4096 bytes,but when i look up the advanced tab, in the optionsmenu of the enterprisemanager, the networkpacketsize is 0!Now i see that some connections are memoryconsuming, could the above hassomething do with this and should i change the network packet size.I would like to have some help with this.Thnx
View 1 Replies View RelatedWe have an application that runs across the WAN to multiple locations. Performance is poor and we are looking at ways to improve performance. One suggestion from our Sr. Network Administrator is to change our Network Packet Sizes across all points, SQL Server & NIC to match the outgoing Router. This would be a size of 1440.
Does anyone have any thoughts or recommendations on this?
Hello all,
I will try to supply all of the information available to me to help generate some answers to the question I have. I am doing some benchmark testing of an application of how it deals with various database queries, for example oracle 10g, DB2 and MSSQL 2005.
I have a very simple database called "student" that has various tables, with various columns, all as mentioned very simplistic. Each table has a few hundred rows of data, the most being one table with 2000 rows. The same database (structure and dataset), is replicated across all 3 DB's.
In order to do the testing, I have been recording the same queries (select * from table_a, select * from table_b etc etc) for each database at an interface which monitors traffic between the client and db server, the problem starts here; The size of the tcpdumps are vastly greater for MSSQL vs oracle or db2. Some examples:
100 query or transaction dump:
mssql=3.7mb
oracl10g=133kb
50,000 query or transaction dump:
mssql=1.8gb
oracl10g=0.6gb
db2=0.6gb
as mentioned each database's tables and data are identical to my knowledge and all queries are the same. The bloated dumps are making mssql performance numbers look bad.
So my question is: What could be the reason for MSSQLs client/server queries to contain so much information, has anyone else come across this? Is there any setting or something I could try to minimize it?
Thank you for your time.
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?
ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "
And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.
Any help with this process?
Hello all,
We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.
This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>
Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.
The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.
Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.
Should have 330 rows if it works right.
Hi
While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears.
Does somebody knows why?
I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.
Thanks!!
Regards
Lautaro - Argentina.
Hi Every one,
I am using .Net 1.1 for my web application.
And my database server is SQL Server 2005.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Can any one please help me to solve this error?
With Regards,
Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
View 2 Replies View RelatedHi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation I have also searched many articles and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error?
View 2 Replies View RelatedWhen I try to update the site setting, I get this Error and I don't know how to fix.
Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub
Source File: C:DotNetNukeComponentsAdminDB.vb Line: 283
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:DotNetNukeComponentsAdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:DotNetNukeadminPortalSiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Please Help!
Thank you,
dlouanis
I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.
I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.
I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.
I have a test table with 10 images, not one more than 4 MB. I cannot complete a test run prior to receiving the general network error.
The pocketPC is connected via activesync to the desktop, and I connect to the database with:
Integrated Security=false;
user id=sa
password=admin.
Any help with this strange error would be greatly appreciated.
Wil
Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.
The Error details are as follows:
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
Hello all, I have question regarding the error message that I'm getting above. I have a program written in .NET that is suppose to traverse through a database and retrieve various records and then write a summary record. The code worked without issue. The database the used to hold the data was a SQL 7.0. However, recently I moved the server over to SQL 2005. Since that time I have been getting the following error:
Description: [Microsoft][SQL Native Client]Named Pipes Provider: No process is on the other end of the pipe.
ramdomly throughout the execution of the program. It doesn't happen on record and is intermittent when it occurs.
Here is the code that is having issues any help would be appreciated.
Thanks
Mike Gisonda
Dim mreleaseqty As Double
Dim mmakeqty As Double
Dim k As Integer
Dim mbackorderqty As Double
Dim mOnOrder As Double
Dim mOnHand As Double
Dim mMaximumqty As Double
Dim mMinimumQty As Double
Dim muomfactor As Double
Dim mSafetyStockQty As Double
Dim mQtyInTransit As Double
Dim mQtyAllocatedWip As Double
Dim mQtyAllocated As Double
Dim cnLean As New ADODB.Connection
Dim cnSyspro As New ADODB.Connection
Dim cnLean2 As New ADODB.Connection
Dim cmdPullItems As New ADODB.Command 'command to retrieve pull items
Dim cmdWHTotals As New ADODB.Command 'command to get combined warehouse totals
Dim cmdUpdatePull As New ADODB.Command
Dim cmdBkOrd As New ADODB.Command
Dim cmdInvMst As New ADODB.Command
Dim cmdInitPull As New ADODB.Command 'command to clean our old pull data
Dim prmStockCode As New ADODB.Parameter 'parameter to supply stockcode.
Dim rsPullItems As New ADODB.Recordset 'recordset to hold pull items.
Dim rsWHTotals As New ADODB.Recordset 'recordset to hold warehouse records
Dim rsBkOrd As New ADODB.Recordset
Dim rsInvMst As New ADODB.Recordset
Dim rsSalesOrders As New ADODB.Recordset
Dim rsWipMaster As New ADODB.Recordset
Dim mPullSQL As String
Dim mWHSql As String
Dim mBackOrderStr As String
Dim mInvSQL As String
Dim mStockCode As String
Dim mSalesSQL As String
Dim aBackOrderRec As Array
Dim mReqDate
Dim mShipDate As Date
Dim mcol As Integer
Dim mNewVal As Double
Dim mWipSql As String
Dim mAdjAmt As Double
Dim mStockStatus As Integer
Dim mBackOrder As Double
Dim mBackLate1 As Double
Dim mBackLate2 As Double
Dim mBackLate3 As Double
Dim mBackLate4 As Double
Dim mWeeklyStDev As Double
Dim mWeeklyUsage As Double
Dim mBackLog1 As Double
Dim mBackLog2 As Double
Dim mBackLog3 As Double
Dim mBackLog4 As Double
Dim mBackLog5 As Double
Dim mBackLog6 As Double
Dim mBackLog7 As Double
Dim mBackLog8 As Double
Dim mBackLog9 As Double
Dim mBackLog10 As Double
Dim mBackLog11 As Double
Dim mBackLog12 As Double
Dim mLEAN_BACKORDER_BFLAG As Integer
Dim mLEAN_LATE1_BFLAG As Integer
Dim mLEAN_LATE2_BFLAG As Integer
Dim mLEAN_LATE3_BFLAG As Integer
Dim mLEAN_LATE4_BFLAG As Integer
Dim mLEAN_BACKLOG1_BFLAG As Integer
Dim mLEAN_BACKLOG2_BFLAG As Integer
Dim mLEAN_BACKLOG3_BFLAG As Integer
Dim mLEAN_BACKLOG4_BFLAG As Integer
Dim mLEAN_BACKLOG5_BFLAG As Integer
Dim mLEAN_BACKLOG6_BFLAG As Integer
Dim mLEAN_BACKLOG7_BFLAG As Integer
Dim mLEAN_BACKLOG8_BFLAG As Integer
Dim mLEAN_BACKLOG9_BFLAG As Integer
Dim mLEAN_BACKLOG10_BFLAG As Integer
Dim mLEAN_BACKLOG11_BFLAG As Integer
Dim mLEAN_BACKLOG12_BFLAG As Integer
Dim mBFlagValue As Integer
Dim mFileNum As Integer
Dim mTrnFileNum As Integer
Dim mtest As String
Dim mCountOfRecords As Long
Dim mPullCount As String
Dim rsPullcount As ADODB.Recordset
Dim mCurRecordCount As Long
Dim mWipAllSQL As String
Dim rsWipAll As New ADODB.Recordset
'On Error GoTo ehbtnUpdateLean_Click
'open connection to springdesign
With cnLean
.ConnectionString = "DSN=SPRINGDESIGN;UID=sa;PWD="
.Open()
End With
With cnLean2
.ConnectionString = "DSN=SPRINGDESIGN;UID=sa;PWD="
.Open()
End With
'open connection to syspro
With cnSyspro
.ConnectionString = "DSN=COMPANYM;UID=sa;pwd="
.CommandTimeout = 300
.Open()
End With
btnUpdateLean.Enabled = False
Me.Cursor = Cursors.WaitCursor
**
Bunch of code to set up commands and select statements
**
'Initial command that will update the pull records as they are being processed.
With cmdUpdatePull
.let_ActiveConnection(cnLean)
.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
.CommandText = "sp_MX_Daily_UpdateMRPData"
.CommandTimeout = 300
.Parameters.Refresh()
End With
**
More Code
**
Try
rsPullItems.CursorLocation = ADODB.CursorLocationEnum.adUseClient
'Get all the pull items.
'rsPullItems = cmdPullItems.Execute
rsPullItems.Open(mPullSQL, cnLean2)
rsPullItems.ActiveConnection = Nothing
Catch ex As Exception
mtest = "Exception Message: " & ex.Message & vbCrLf & "SQLStatement: " & cmdPullItems.CommandText
LogError("", mtest)
rsPullItems = Nothing
End Try
Try
'Initialize debugging and transaction files.
mFileNum = FreeFile()
FileOpen(mFileNum, "MXtestdebug.txt", OpenMode.Output, OpenAccess.Default, OpenShare.Shared)
PrintLine(mFileNum, "Start " + Format(Now, "hh:mms"))
mTrnFileNum = FreeFile()
FileOpen(mTrnFileNum, "MXTrndebug.txt", OpenMode.Output, OpenAccess.Default, OpenShare.Shared)
Catch ex As Exception
End Try
mCurRecordCount = 0
'Start working.
If IsNothing(rsPullItems) = False Then
Do While rsPullItems.EOF = False
mCurRecordCount += 1
'Initialize parameter values
cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
cmdUpdatePull.Parameters("@MINIMUM_QTY").Value = 0
cmdUpdatePull.Parameters("@MAXIMUM_QTY").Value = 0
cmdUpdatePull.Parameters("@SAFETYSTOCKQTY").Value = 0
cmdUpdatePull.Parameters("@ON_HAND").Value = 0
cmdUpdatePull.Parameters("@ON_ORDER").Value = 0
cmdUpdatePull.Parameters("@BACKORDER_QTY").Value = 0
cmdUpdatePull.Parameters("@MAKE_QTY").Value = 0
cmdUpdatePull.Parameters("@RELEASE_QTY").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE1").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE2").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE3").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE4").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value = 0.0
'Initial flags used to determine if the individual sales order dates are
'before or after the request date.
cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEANMFG_STOCKSTATUS").Value = 0
**
**
Try
'Get warehouse totals
rsWHTotals = New ADODB.Recordset
rsWHTotals = cmdWHTotals.Execute
Catch ex As Exception
mtest = "Exception Message: " & ex.Message & vbCrLf & "SQLStatement: " & cmdWHTotals.CommandText
LogError(mStockCode, mtest)
rsWHTotals = Nothing
End Try
**
**
If IsNothing(rsWHTotals) = False Then
If rsWHTotals.EOF = False Then 'If there are values in the warehouse query.
**
BUNCH MORE CODE
**
cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
cmdUpdatePull.Parameters("@MINIMUM_QTY").Value = mMinimumQty
cmdUpdatePull.Parameters("@MAXIMUM_QTY").Value = mMaximumqty
cmdUpdatePull.Parameters("@SAFETYSTOCKQTY").Value = mSafetyStockQty
cmdUpdatePull.Parameters("@ON_HAND").Value = mOnHand
cmdUpdatePull.Parameters("@ON_ORDER").Value = mOnOrder
**
cmdUpdatePull.Parameters("@BACKORDER_QTY").Value = mbackorderqty
mmakeqty = (mMaximumqty - mOnHand)
If mmakeqty > 0 Then
cmdUpdatePull.Parameters("@MAKE_QTY").Value = mmakeqty
Else
cmdUpdatePull.Parameters("@MAKE_QTY").Value = 0
End If
'init varables.
cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE1").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE2").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE3").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_LATE4").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value = 0.0
cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value = 0.0
mBackOrder = 0.0
mBackLate1 = 0.0
mBackLate2 = 0.0
mBackLate3 = 0.0
mBackLate4 = 0.0
mBackLog1 = 0.0
mBackLog2 = 0.0
mBackLog3 = 0.0
mBackLog4 = 0.0
mBackLog5 = 0.0
mBackLog6 = 0.0
mBackLog7 = 0.0
mBackLog8 = 0.0
mBackLog9 = 0.0
mBackLog10 = 0.0
mBackLog11 = 0.0
mBackLog12 = 0.0
'Initiale Binary flags that represent if the ship date is
'before or after the request date.
cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value = 0
cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value = 0
mBackOrder = 0.0
mBackLate1 = 0.0
mBackLate2 = 0.0
mBackLate3 = 0.0
mBackLate4 = 0.0
mBackLog1 = 0.0
mBackLog2 = 0.0
mBackLog3 = 0.0
mBackLog4 = 0.0
mBackLog5 = 0.0
mBackLog6 = 0.0
mBackLog7 = 0.0
mBackLog8 = 0.0
mBackLog9 = 0.0
mBackLog10 = 0.0
mBackLog11 = 0.0
mBackLog12 = 0.0
mLEAN_BACKORDER_BFLAG = 0
mLEAN_LATE1_BFLAG = 0
mLEAN_LATE2_BFLAG = 0
mLEAN_LATE3_BFLAG = 0
mLEAN_LATE4_BFLAG = 0
mLEAN_BACKLOG1_BFLAG = 0
mLEAN_BACKLOG2_BFLAG = 0
mLEAN_BACKLOG3_BFLAG = 0
mLEAN_BACKLOG4_BFLAG = 0
mLEAN_BACKLOG5_BFLAG = 0
mLEAN_BACKLOG6_BFLAG = 0
mLEAN_BACKLOG7_BFLAG = 0
mLEAN_BACKLOG8_BFLAG = 0
mLEAN_BACKLOG9_BFLAG = 0
mLEAN_BACKLOG10_BFLAG = 0
mLEAN_BACKLOG11_BFLAG = 0
mLEAN_BACKLOG12_BFLAG = 0
mBFlagValue = 0
**
more Code
**
Try
rsSalesOrders = New ADODB.Recordset
rsSalesOrders.Open(mSalesSQL, cnSyspro)
Catch ex As Exception
mtest = "Exception Message: " & ex.Message & vbCrLf & "SQLStatement: " & mSalesSQL
LogError(mStockCode, mtest)
rsSalesOrders = Nothing
End Try
If IsNothing(rsSalesOrders) = False Then
Do While rsSalesOrders.EOF = False
**
More Code
**
Select Case mcol
Case Is <= -5
cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value = cmdUpdatePull.Parameters("@LEAN_BACKORDER").Value + mNewVal
'Check to see if the bit is marked. If not then mark it.
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value = cmdUpdatePull.Parameters("@LEAN_BACKORDER_BFLAG").Value + mBFlagValue
End If
mBackOrder = mBackOrder + mNewVal
Case Is = -4
cmdUpdatePull.Parameters("@LEAN_LATE4").Value = cmdUpdatePull.Parameters("@LEAN_LATE4").Value + mNewVal
'Check to see if the bit is marked. If not then mark it.
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value = cmdUpdatePull.Parameters("@LEAN_LATE4_BFLAG").Value + mBFlagValue
End If
mBackLate4 = mBackLate4 + mNewVal
Case Is = -3
cmdUpdatePull.Parameters("@LEAN_LATE3").Value = cmdUpdatePull.Parameters("@LEAN_LATE3").Value + mNewVal
'Check to see if the bit is marked. If not then mark it.
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_LATE3_BFLAG").Value + mBFlagValue)
End If
mBackLate3 = mBackLate3 + mNewVal
Case Is = -2
cmdUpdatePull.Parameters("@LEAN_LATE2").Value = cmdUpdatePull.Parameters("@LEAN_LATE2").Value + mNewVal
'Check to see if the bit is marked. If not then mark it.
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_LATE2_BFLAG").Value + mBFlagValue)
End If
mBackLate2 = mBackLate2 + mNewVal
Case -1 To 0
cmdUpdatePull.Parameters("@LEAN_LATE1").Value = cmdUpdatePull.Parameters("@LEAN_LATE1").Value + mNewVal
'Check to see if the bit is marked. If not then mark it.
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_LATE1_BFLAG").Value + mBFlagValue)
End If
mBackLate1 = mBackLate1 + mNewVal
Case Is = 1
cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG1").Value + mNewVal
'Check to see if the bit is marked. If not then mark it.
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG1_BFLAG").Value + mBFlagValue)
End If
mBackLog1 = mBackLog1 + mNewVal
Case Is = 2
cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG2").Value + mNewVal
'Check to see if the bit is marked. If not then mark it.
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG2_BFLAG").Value + mBFlagValue)
End If
mBackLog2 = mBackLog2 + mNewVal
Case Is = 3
cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG3").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG3_BFLAG").Value + mBFlagValue)
End If
mBackLog3 = mBackLog3 + mNewVal
Case Is = 4
cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG4").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG4_BFLAG").Value + mBFlagValue)
End If
mBackLog4 = mBackLog4 + mNewVal
Case Is = 5
cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG5").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG5_BFLAG").Value + mBFlagValue)
End If
mBackLog5 = mBackLog5 + mNewVal
Case Is = 6
cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG6").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG6_BFLAG").Value + mBFlagValue)
End If
mBackLog6 = mBackLog6 + mNewVal
Case Is = 7
cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG7").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG7_BFLAG").Value + mBFlagValue)
End If
mBackLog7 = mBackLog7 + mNewVal
Case Is = 8
cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG8").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG8_BFLAG").Value + mBFlagValue)
End If
mBackLog8 = mBackLog8 + mNewVal
Case Is = 9
cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG9").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG9_BFLAG").Value + mBFlagValue)
End If
mBackLog9 = mBackLog9 + mNewVal
Case Is = 10
cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG10").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG10_BFLAG").Value + mBFlagValue)
End If
mBackLog10 = mBackLog10 + mNewVal
Case Is = 11
cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG11").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG11_BFLAG").Value + mBFlagValue)
End If
mBackLog11 = mBackLog11 + mNewVal
Case Is = 12
cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value = cmdUpdatePull.Parameters("@LEAN_BACKLOG12").Value + mNewVal
If mBFlagValue <> (cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value And mBFlagValue) Then
cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value = (cmdUpdatePull.Parameters("@LEAN_BACKLOG12_BFLAG").Value + mBFlagValue)
End If
mBackLog12 = mBackLog12 + mNewVal
End Select
End If
rsSalesOrders.MoveNext()
Loop
rsSalesOrders.Close()
rsSalesOrders = Nothing
End If
**
More Code
**
cmdUpdatePull.Parameters("@LEANMFG_STOCKSTATUS").Value = mStockStatus
**
More Code
**
Else
cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
End If
rsWHTotals.Close()
rsWHTotals = Nothing
Else 'rswhtotal is nothing
cmdUpdatePull.Parameters("@stock_code").Value = mStockCode
End If 'rswhtotal is nothing
'Update the record in DesignLean
Try
*********
This is where it fails
*********
cmdUpdatePull.Execute()
Catch ex As Exception
mtest = "ERROR executing cmdupdatepull" & vbCrLf & "Exception Message: " & ex.Message & vbCrLf
LogError(mStockCode, mtest)
PrintLine(mTrnFileNum, mtest)
End Try
PrintLine(mTrnFileNum, "Finished to update cmdUpdatePull")
'Move to next record
rsPullItems.MoveNext()
PrintLine(mTrnFileNum, "Moving to next rsPullItems")
Loop
rsPullItems.Close()
rsPullItems = Nothing
cmdUpdatePull = Nothing
rsSalesOrders = Nothing
rsWipMaster = Nothing
End If
PrintLine(mTrnFileNum, "End of Pull Items LOOP")
FileClose(mTrnFileNum)
PrintLine(mFileNum, "ending" + Format(Now, "hh:mms"))
FileClose(mFileNum)
ProgressBar1.Value = mCountOfRecords + 100
btnUpdateLean.Enabled = True
Me.Cursor = Cursors.Default
MsgBox("done", MsgBoxStyle.OKOnly, "MXLean Calculation Status")
End
Exit Sub
I had to move my developed software onto another computer in order to demo this. The new computer has IIS installed as well as VS2005 and SQL Server 2005. When I try to execute I get this error.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
I have worked on this problem for two days now and have to demo it first thing Monday. Any help would be appreciated.
I've got a dilemma here. I'm currently reading records into EasyListBox (ELB) dropdownlist. The criteria in the dropdownlist is based on the select from another ELB dropdownlist. The problem is that the data contains rows with pipes that serve as separters. For example, one of the options that comes back now might be 123 | 456 | 789. I need to be able to make each of them its own row in the dropdownlist. Can anyone advice? Most records don't have any pipes and come throught fine, but some dont.
My code below:
Dim sAT As String = Replace(elbAttribute.SelectedValue, "'", "''")
Dim adapter As New SQLDataAdapter("Select Feature_Type As Attribute_Name, FEATURE_TEXT_VALUE as Attribute_Value, (select distinct FILTER_FAMILY_FEATURE_EXCLUDED.FEATURE_TYPE_ID from FILTER_PROFILES, FILTER_FAMILY_FEATURE_EXCLUDED, FAMILY_ALLOWED_FEATURE_TYPES, SHARED_FEATURE_TYPES, SHARED_FEATURE_VALUES where FILTER_PROFILES.FILTER_PROFILE_NAME = 'MAQ' And FILTER_PROFILES.FILTER_PROFILE_ID = FILTER_FAMILY_FEATURE_EXCLUDED.FILTER_PROFILE_ID And FAMILY_ALLOWED_FEATURE_TYPES.FAMILY_ID = FILTER_FAMILY_FEATURE_EXCLUDED.FAMILY_ID And FILTER_FAMILY_FEATURE_EXCLUDED.FEATURE_TYPE_ID = SHARED_FEATURE_TYPES.FEATURE_TYPE_ID And (SHARED_FEATURE_TYPES.Feature_Type_ID = SHARED_FEATURE_VALUES.Feature_Type_ID And left(FEATURE_TYPE, 4) <> 'CPLV' And Feature_Type = '" & sAT & "')) As ExclusionFlag From SHARED_FEATURE_TYPES, SHARED_FEATURE_VALUES, PRODUCT_FEATURE_VALUES Where PRODUCT_FEATURE_VALUES.FEATURE_VALUE_ID = SHARED_FEATURE_VALUES.Feature_Value_ID And SHARED_FEATURE_TYPES.Feature_Type_ID = SHARED_FEATURE_VALUES.Feature_Type_ID And left(FEATURE_TYPE, 4) <> 'CPLV' And Feature_Type = '" & sAT & "' UNION Select distinct Column_Name As Attribute_Name, SMALL_TEXT_VALUE As Attribute_Value, (select FILTER_ATTRIBUTES_EXCLUDED.EXT_ATT_ID from FILTER_PROFILES, FILTER_ATTRIBUTES_EXCLUDED where FILTER_PROFILES.FILTER_PROFILE_NAME = 'MAQ' And FILTER_PROFILES.FILTER_PROFILE_ID = FILTER_ATTRIBUTES_EXCLUDED.FILTER_PROFILE_ID And FILTER_ATTRIBUTES_EXCLUDED.EXT_ATT_ID = EXTENDED_ATTRIBUTES.EXT_ATT_ID) As ExclusionFlag From EXTENDED_ATTRIBUTE_VALUES, EXTENDED_ATTRIBUTES, PRODUCTS Where PRODUCTS.PRODUCT_ID = EXTENDED_ATTRIBUTE_VALUES.PRODUCT_ID And not SMALL_TEXT_VALUE is null And EXTENDED_ATTRIBUTE_VALUES.EXT_ATT_ID > 1499 And EXTENDED_ATTRIBUTE_VALUES.EXT_ATT_ID = EXTENDED_ATTRIBUTES.EXT_ATT_ID And Column_Name = '" & sAT & "'", myConnection) Dim dt As New DataTable() adapter.Fill(dt) elbValue.DataSource = dt elbValue.DataBind()
Sample Data
MemberID Codes
00000123 012|222|123|333
00000233 012|222|332
00000244 012|211
00000332 012
I am trying to get it so as following:
MemberID Code1, Code2, Code3, Code4
I tried using the XML method but in working with an example, I actually got stuck on one of the declare fields and cant seem to work around it.
Failed Attempt:
DECLARE @x xml;
DECLARE @line VARCHAR(MAX);
SET @x = Cast(
'<field>'
+ replace(@line, '|', '</field><field>')
+ '</field>' AS XML);
[code]...
Has any one managed to get Report Manager to have the option to export to pipe delimited? There are documents out there how to do it on SSRS; I need it on Report Manager. Any Suggestions?
DGraham
vbwrangler@yahoo.com
Hi all,
I was told recently that doing the following:
SELECT ProductName ||' , '|| Category FROM PRODUCTS
would add parentheses around the ProductName field data. However, after trying it out for myself I found it did no such thing.
Does this look familiar to anyone? Is it syntax I have wrong or something?
Butterfly82
Can somebody help me with a delimiter problem I have.I have several PIPE (|) delimted text files which I need to import toSQL.With one of the files I keep encountering the following error;"Error at Source for Row 27753. Errors encountered so far in this task:1. Column Delimter not found."I suspect the problem is that one record (and possibly more) has a PIPE(|) within a field, because some of the fields contain free text.Getting an export of the file again using a different delimter like tabor comma will not work as these characters occur throughout the file.I'm open to suggestions as to how to resolve this and really need toget a solution soon.One solution I was thinking of, but do not know how to execute is tocount the number of PIPEs on each record and then manually change therecords which have count which is inconsistent with the rest of thefile.I've also tried importing to Access first and then SQL, as this hasworked for me in the past, but it did not work.Regards,Ciarán
View 3 Replies View RelatedI can use SQL Server Management Studio Express to connect to my local database SQL 2005 database on bknjisqlexpress.
I am also able to connect to the database from Visual Studio, and this is where I copied the following connection string to be used in my C# code
string myConnectString = "Data Source=BKFNJI\SQLEXPRESS;" +
"Initial Catalog=cmiCompatibilityDataBase" +
"Integrated Security=True;Pooling=False";
// specify SQL Server Specific Connection string
SqlConnection cmiDBCompConnection = new SqlConnection(myConnectString);
cmiDBCompConnection.Open();
when I attempt to run the apps, I get the
"System.Data.SqlClient.SqlException was unhandled
Message="A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)".....
any idea what I am doing wrong, given that the connection string works using other means? I am using Windows authentication.
To add, the error in my log shows:
2007-03-17 21:10:55.82 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]
Thanks,
Klaus
Hi guys,
Running a clustered webserver, windows 2000, IIS v5, and a sql server, v2000. Using OLE Db as connection, running stored procedures, no sql created on the fly. The website handles about 5000 transaction a day.
Every now and again, we get a problem whereby an error 41 - Broken Pipe is reported. I can't find any info on this error on Technet, MSDN, etc. Google returns info, but only really affecting solaris, unix, linux, etc.
Anyone ever come across this error before? or know what might cause it? and possible resolutions?
Linked server is created as (from SQL 2005 to SQL 2000)
EXEC sp_addlinkedserver @server = @SPKServerName,
@srvproduct = '',
@provider = 'SQLOLEDB',
@datasrc = @SPKdatasrc //np:remoteservername
exec sp_serveroption @server = @SPKServerName
, @optname = 'rpc'
, @optvalue = 'on'
exec sp_serveroption @server = @SPKServerName
, @optname = 'rpc out'
, @optvalue = 'on'
exec sp_serveroption @server = @SPKServerName
, @optname = 'data access'
, @optvalue = 'on'
when asp.net applicaiton hits the Stored Procedure, it uses Linked server to get data from remote server. It fails with exception message
OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "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.".
Msg 5, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [5].
Any idea how to solve this?
Regards,
I had to un-install and re-install SQL Server 2005 for a different problem which has been resolved.
But now when I try to make a connection to the database I get the following error:
"...No process is on the other end of the pipe"
I have verified that the server allows named pipeing which seems to be the common answer I found after searching. I have also verified that the account I use is setup and has all the proper permissions.
Can someone help me in resolving this issue noting what I have verified above???
Thanks...
Hi All , I have been racking my head on this for the last two days and really it should be a no brainier. Anyways I can only assume that I€™m missing something here but...
In a nut shell I am attempting to connect to a new SQL Alias that i have created by simply adding the following in the client network utility
Current SQL server name DASQL
Default instance
Alias Name: TASQL
Server Name: DASQL
Pipe Name: \DASQLpipesqlquery
I can connect the new alias via the local (server consol) yet when i attempt to connect remotely it times out as if it can't find the server.
Any Thought?
Thanks
Hey everyone,
I'm working of a project that has each row of column data stored in this format: AAChieve Initiative - Business Development Consultant|Marketing|4F|210710
Is there a way I can break this rows apart with TSQL based of the | symbol? Thanks in advance!
Hi, all,
I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.
I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.
In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \192.168.1.100pipeMSSQL$SQLEXPRESSsqlquery -U * -P *), but I can not connect to server remotely using same command line.
According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.
Thanks.
Johonson Chan
Why can I no longer backup a database to a named pipe in SQL Server 2005? Named pipes are much easier to work with than VDI (and VDI is covered in obscurities). I really want the ability to dump a database to a named pipe reimplementation if it€™s been removed. I hate to think of the cost of redesigning our backup applications. Can I force a PIPE dump device into the sysdevices table? Any suggestions? (and DO NOT tell me to use VDI, as it is absurdly cumbersome and loaded with unnecessary dependencies)
BACKUP DATABASE <name> TO PIPE=\.pipeMyPipeName
i've read that it's possible and this is what i entered in my rsreportserver.config file.
<Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
<OVerrideNames>
<Name Language="en-US">PIPE Delimited CSV</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter>"%7C"</FieldDelimiter>
</DeviceInfo>
</COnfiguration>
</Extension>
I'm following the directions of the guide and it seems to crash my report server. can you help out? thanks in advance.
I downloaded MS Pet Shop 4.0 recently for best-practice training purposes. The installation went smoothly with a SQL Server 2005 backend. At first I had a problem authenticating the mspetshop4 user in the database, but that was solved by fixing some settings with the password policy. Now the mspetshop4 user is authenticated properly, but I came across this error instead:Server Error in '/Web' Application.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Source Error:
Line 216:
Line 217: if (conn.State != ConnectionState.Open)
Line 218: conn.Open();
Line 219:
Line 220: cmd.Connection = conn;
Source File: C:Program FilesMicrosoft.NET Pet Shop 4.0DBUtilitySQLHelper.cs Line: 218
Stack Trace:
[SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +117
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +619
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +224
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +113
System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +59
System.Data.SqlClient.TdsParserStateObject.ReadByte() +36
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +181
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +56
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1083
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +688
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +82
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +558
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +126
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +651
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +160
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122
System.Data.SqlClient.SqlConnection.Open() +229
PetShop.DBUtility.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in C:Program FilesMicrosoft.NET Pet Shop 4.0DBUtilitySQLHelper.cs:218
PetShop.DBUtility.SqlHelper.ExecuteReader(String connectionString, CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in C:Program FilesMicrosoft.NET Pet Shop 4.0DBUtilitySQLHelper.cs:127
PetShop.SQLServerDAL.Category.GetCategories() in C:Program FilesMicrosoft.NET Pet Shop 4.0SQLServerCategory.cs:27
PetShop.BLL.Category.GetCategories() in C:Program FilesMicrosoft.NET Pet Shop 4.0BLLCategory.cs:20
PetShop.Web.NavigationControl.BindCategories() in c:Program FilesMicrosoft.NET Pet Shop 4.0WebControlsNavigationControl.ascx.cs:53
PetShop.Web.NavigationControl.Page_Load(Object sender, EventArgs e) in c:Program FilesMicrosoft.NET Pet Shop 4.0WebControlsNavigationControl.ascx.cs:27
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +31
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +68
System.Web.UI.Control.OnLoad(EventArgs e) +88
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Control.LoadRecursive() +158
System.Web.UI.BasePartialCachingControl.LoadRecursive() +61
System.Web.UI.Control.LoadRecursive() +158
System.Web.UI.Control.LoadRecursive() +158
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3035
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42Now I'm clueless. What does No process at the other end of the pipe mean?
While checking the SQL server error logs, I notice that the pubs and msdb database are automatically being backed up, even though no job is set up to do so....in addition, its backing up to a directory that I cannot find on our network.....does anybody have an idea of whats going on ?
the path its backingup to is:
(FILE=1, TYPE=PIPE: {'.pipedbasql70dbagent0s0'}).
Thank you in advance
I have a single string "XYZ00001|Test_b|XYZ00002|Test_a|XYZ00003|Test_c" that will continue to grow over time.
Is there a way I can extract the values from the string into two separate columns?
XYZ0001 Test_b
XYZ0002 Test_a
XYZ0003 Test_c