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!
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 RelatedIs it possible to include a currency symbol in an amount-field in PowerPivot/Pivottable based on a Currency column in a table? Something as the same as with SSAS MD. And I don't want fixed values in my code.
View 3 Replies View RelatedSample 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]...
I want to add $ symbol to column values and convert the column values to western number system
Column values
Dollar
4255
25454
467834
Expected Output:
$ 4,255
$ 25,454
$ 467,834
My Query:
select ID, MAX(Date) Date, SUM(Cost) Dollars, MAX(Funded) Funding from Application
COST is the int datatype and needs to be changed.
the text file format use the length of character to define the field
for example,
0001130130HAUT BAGES AVEROUS 03
9 chars <0001130130> is a field
1 char <H> is a field
20 chars <AUT BAGES AVEROUS 03> is a field
one record by one record store in db
no space, no symbol, no line break between each record
----------------------------------------------------------
I try bcp method, but some error happens. Please give me suggestions. thx
I run the following code in query analyzer.
BULK INSERT Chain.dbo.POLL59
FROM 'D:POLL59.DWN'
WITH (FORMATFILE = 'D:cp.fmt')
?????
it shows the error
Server: Msg 4839, Level 16, State 1, Line 1
Cannot perform bulk insert. Invalid collation name for source column 4 in format file 'D:cp.fmt'.
***
For your information
data file
000000011301220051222000192000000000011301320051222000030000000000019067420051222000000001<there are many space >
bcp.fmt file <I use tab to separate and use ascii>
8.0
4
1 SQLCHAR 0 4 "" 1 PLUEVT ""
2 SQLCHAR 0 9 "" 2 PLUSKU ""
3 SQLCHAR 0 8 "" 3 PLUFRD ""
4 SQLCHAR 0 9 "" 4 PLUPRC ""
!!!!
I try to edit collation name in Chinese_Taiwan_Stroke_CI_AS or others, but the error also happens.
Hi,
I want to display data that is 10 as $10.00 or 10.1 as $10.10..
and i tried giving this expression
=IIf(Fields!Nav.Value = "n/a","n/a",(cstr(Format(Fields!Nav.Value,"C2"))))
But when i run the report its giving it as C2 and not $10.00 or whatever it should be.
any help will be appreciated.
Regards
Karen
Is there any function that tokenizing a string?
any similar function that works like Split in VB?
for example @inputParam = 'test1,test2,test3'
select fnSomeFunc(@inputParam, ',')
returns
-----------
test1
test2
test3..
Hi,
I am a bit confused on the many uses of the @ symbol, such as in assignments and in use by stored procedures. I am not quite clear on when it needs to be used and when it doesn't, what it means, etc. Could someone either point me to a good reference, or explain? (I have read several books on MS Sql server, but somehow missed this.) I use the symbol, but I don't understand when to use it and when not to, without referencing an example.
Thanks,
I have SQL Server 2000 SP3 and the default Code Page is:
I have a Table with a column of the type 'text'.
In this column sometimes it's necessary introduce the euro symbol (€). Now, when we write this symbol, after the SQL Server show it with a '?'.
I tried change the column collation to 'Latin1_General_CI_AI', ‘SQL_Latin1_General_CP1_CI_AI’ and ‘SQL_Latin1_General_CP850_CI_AI’ but there is the same problem.
Does any know what the cause off this problem is?
Thanks in advance!
hi..
sql statement
db.query(
INSERT INTO student(name, course, email) "+
"VALUES('" + name +"' , "+
"'" + course+"' , "+
"'" + email+"' ");
this sql statement doesn't content any error but if the sentences that want to insert into table contain symbol ' then it will process error when enter into table. ( data contain symbol ' can't insert into table).
May i know how to solve this problem.
i did refer to my friends they said need include java class, but they not sure what's the class that i need.
So i help i can get the help here.
Thank in advance
SELECT ROW_NUMBER() OVER (ORDER BY BM.BILL_NUMBER_V) AS [SL_NO],PP.KID_ID_NO_V AS [KID_NO],(PP.FIRSTNAME_V + SPACE(1) + PP.LASTNAME_V)AS [PATIENT_NAME],
CONVERT(VARCHAR(10),PP.UPDATEDDATE_D,101)AS [VISIT_DATE],BM.BILL_NUMBER_V AS [BILL_NUMBER],CONVERT(VARCHAR(10),BM.BILL_DATE_D,101) AS [BILL_DATE],
ROUND(BM.BILL_AMOUNT_M,2) AS [BILL_AMOUNT],ROUND(BM.CONCESSION_AMOUNT_M,2) AS [CONCESSION_AMOUNT],ROUND(BM.TOTAL_AMOUNT_M,2) AS [TOTAL_AMOUNT],
[Code] .....
In the above query i want to concat symbol '%' for output of percentage column. How to do that?
Eg: PERCENTAGE
30.00%
50.00%
Dear experts,
I'm having a problem with the Euro symbol on my SQLServers which all have characterset 850 and Unicode collation 1033. As far as I can see charset 850 does not contain the € symbol, but if I run a query
DECLARE @nstring nchar(12)
SET @nstring = N'€'
SELECT UNICODE(@nstring), NCHAR(UNICODE(@nstring))
Result: 8364 €
So the Unicode character 8364 is the Euro symbol. My question now is how do I have to write a statement so that the € symbol is shown in the output.
I need to use something like the following:
Select 'Costs:'+ € + convert(money, table1.costs)
Result: € 123.00
I tried several options but never get the right output. Is there any way of doing it or do I have to change the characterset.
Markus
We are running SQL Version 7.0.
I recently set up a simple snapshot replication. After restarting enterprise manager a hand symbol showed up under the database barrel as if a share symbol.
Am I correct in assuming the symbol means replication. Is there a source that explains what the various symbols mean?
We are getting 67.2,62.4,81.9 these are percentages these are rounded values..so in my report I would like to add % symbol for them I have written expression like this
=left(Fields!Sales_Margin_TY____.Value,4) &
"%"
but I was getting 67.1Â in place of 67.2Â
I dont want to change the figures which is coming from source...
Just I want to add % for those values... how to do that ..
I am looking for a way to remove the printer symbol from the report manger because it dows not work on some client machines because they are locked down. For us it is completely sufficient to export to PDF.
Is there a setting or an entry in the web config or something else. A hint would be helpful
Thanks
HANNES
I have such Function:
IF EXISTS (SELECT * FROM sys.objects WHERE name = 'TwoDigitsNumber' AND type = 'FN')
DROP FUNCTION MinimumOFThree;
GO
CREATE FUNCTION TwoDigitsNumber(@a int)
RETURNS nvarchar(20)
[Code] ....
The only first letter 'f', 's', 'e' is inserted in value instead 'first', 'second', 'equal'.
Why ? How can i insert whole string
Have an App using SQL CE 2.0.
If the App is open and the device is powered off and then back on; the following happens when an update of the data base is attempted:
1. Pocket PC 2003 €“ IPAQ No problem all is well.
2. WM 2005 €“ Dell No problem all is well
3. WM 2005 €“ Symbol MC70 SQL error 0x80004005.**
App is compiled under eVC 4.0
** Some results if App is compiled under VS2005
Is this:
a.) My problem ?
b.) WM 2005 problem ?
c.) Symbol problem ?
d.) SQLCE 2.0 problem?
Any input would be appreicated
Thanks
JEK
Hai
I have amount field in my table as decimal. I need a query to display the amount with dollar or euro symbol based on country selection. The country also in same table.
For example If country is US then Amount $1200, If country is UK then Amount €1200.
Thanks in advance.
Hi
We are having problems getting Reporting Services 2005 to export to an ASCII CSV file and correctly produce a £(GBP sign).
I have changed my report server .config file to read:
<Extension Name="CSV1" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-8</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-8</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV2" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-7</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-7</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV3" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - ASCII</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
And so far so good I get the three options to export to,
If I Export using the ASCII Rendering my pound signs come out as question marks (?) and subsequently loads into Excel as a general data type and is not sum-able.
If I Export using UTF-8 Rendering my pound signs come out as a weird character followed by a pound sign, again opened in excel loads as a General data type and is not summable.
If I export using UNICODE rendering, by file sizes are doublesd as you would expect, and then when you open in excel it is all bunched up in column 1, both un-acceptable.
Interestingly enough If I take the UTF-8 file I have and convert it to ASCII using Ultraedit, notepad or wordpad, everything works fine, the £ is correctly encoded, Excel loads it OK and it is summable, result, but I can not use get my end users to perform this "kludge" for an export.
Any help would be appreciated
Thanks
Tim
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 would like to know how to split the phone number into two columns based on - symbol Dynamically.
for example
Phone Number
123-12323
1234-1222
so output should be
code number
123 12323
1234 1222
I'd like the state of the function bars to stay at whatever it was as the user moves from one report to the next rather than opening to full each time a new report is opened. Can this be done through a setting or programatically at teh report level? Is there a <default_toolbars_OpenState> tag or something?
Thanks in advance.
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()
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
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
I have a table with Million plus records. Due to Running Totals article, I have been able to calculate the Trial_Balance for all months.
Now I am trying to provide a Beginning Balance for all months and the Logic is the Beginning Balance of July would be the Trial_Balance of June. I need to be able to do this for multiple account types. So the two datasets that need to be included in logic is actindx and Calendar_Month.
For actindx of 2 and Calendar_Month of 2014-01-01The Trial_Balance_Debit is 19585.46 This would make the Beginning_Balance of actindx 2 and Calendar_Month of 2014-02-01 19585.46
I am trying to do some type of self join, but not sure how to include each actindx number differently.
Table creation and data insert is below.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TrialBalance](
[Trial_Balance_ID] [int] IDENTITY(1,1) NOT NULL,
[Code] ....
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,