No Failover and client crashes ODBC DSN Setting for Failover in connection String

We have set up Mirroring with a witness server and everything works fine when we failover from the SQL Management console.

However, if we failover when our Maccola client is connected, the client blows up - clearly because it can no longer connect to the database.

The ODBC DSN used by the Maccola client shows a checkbox for the 'select a failover server' but the checkbox is grayed out.

Also the summary of settings for the DSN at the end of the wizard reveals that the failover to server (y/N) option is set to N.

The default setting for this DSN is 'populate the remaining values by querying the server' but it doesn't appear to be getting the settings for failover from the server or any other interactive DSN settings either. The server is clearly set for mirroring.

Another suspicious item is that the DSN cannot connect to the server with SA permissions, even though the server is set to mixed security and we use the correct authentication.

Is it possible that the client MACHINE is not authenticating with the domain or sql server properly. We are logged into the client with the domain account that is the SQL admin account on the sql server box.

We should be able to interact with the sql server settings through the ODBC DSN on the client shoulnd't we?

Are we missing a service pack on the client?

Thanks,

Kimball

Have you referred to Maccola vendor in this case about the compatibility, I would guess this is to with that drivers.

No Failover and client crashes ODBC DSN Setting for Failover in connection String

We have set up Mirroring with a witness server and everything works fine when we failover from the SQL Management console.

However, if we failover when our Maccola client is connected, the client blows up - clearly because it can no longer connect to the database.

The ODBC DSN used by the Maccola client shows a checkbox for the 'select a failover server' but the checkbox is grayed out.

Also the summary of settings for the DSN at the end of the wizard reveals that the failover to server (y/N) option is set to N.

The default setting for this DSN is 'populate the remaining values by querying the server' but it doesn't appear to be getting the settings for failover from the server or any other interactive DSN settings either. The server is clearly set for mirroring.

Another suspicious item is that the DSN cannot connect to the server with SA permissions, even though the server is set to mixed security and we use the correct authentication.

Is it possible that the client MACHINE is not authenticating with the domain or sql server properly. We are logged into the client with the domain account that is the SQL admin account on the sql server box.

We should be able to interact with the sql server settings through the ODBC DSN on the client shoulnd't we?

Are we missing a service pack on the client?

Thanks,

Kimball

Have you referred to Maccola vendor in this case about the compatibility, I would guess this is to with that drivers.

no external connections are permitted while trying to connect to SQL server

ok so this is my code:

private void iDListBox_SelectedIndexChanged(object sender, EventArgs e)

{

string connectionString = GetConnectionString();

using (SqlConnection connection = new SqlConnection(connectionString))

{

SqlCommand cmd = new SqlCommand("SELECT * FROM Table1 WHERE Naam=@.Naam", connection);

cmd.Parameters.AddWithValue("@.Naam", iDListBox.SelectedValue);

connection.Open();

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())

{

naamTextBox.Text = reader.GetString(1);

}

reader.Dispose();

connection.Dispose();

}

}

static private string GetConnectionString()

{

return "Data Source=(local);Initial Catalog=AdventureWorks;"

+ "Integrated Security=SSPI;";

}

but when I change the selected index of the listbox, then this error comes up:

System.Data.SqlClient.SqlException was unhandled
Message="An error occured while setting up a connection with the server. At making a connection with SQL server 2005, this jamming is possibly caused by the fact that at the standardinstitutions of SQL server no external connections have been permitted (provider: Provider of named pipes, error: 40 - no connection with SQL could open server)"

If the error sounds a bit weird, sry I tried to translate as most of my errors come in my language

someone knows what the problem is and a solution to it?

(btw sry if this is in the wrong part of the sql forum, but there are so much parts, I didn't know which to choose lol )

thx in advance

Please see http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx to see if any of the suggestions solves your case.

Jimmy

No connection to local SQL Server when no network connection

The soluition is to use named pipes to connect as
Enterprise manager will if IP: 127.0.0.1 cannot connect.
Change your connection string to :
'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
ID=Bis;Initial Catalog=BIS;Data Source=(local)'
This should fix the problem.

>--Original Message--
>Hi !
>We are using Windows XP,
>ADO in our application,
>MS SQL Server 2000.
>(Programming language: Delphi 5;
> ADO components: from Adonis;
> The computer is a SONY notebook).
>SQL server is running on the same machine as the
application.
>The application has worked in many, many cases under W2K
and even XP.
>But on that computer it doesn't work:
>When there is no network connection, then the application
CANNOT connect to
>our DB.
>On the other hand, Enterprise Manager CAN connect.
>When we plug in the network and restart the computer,
then the application
>CAN connect.
>However, SQL Server is running locally !
>The connection string for connecting our app to the
database is something
>like:
> 'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
>ID=Bis;Initial Catalog=BIS;Data Source=127.0.0.1'
>How can we fix that problem ?
>Is this a problem of MS SQL Server administration ?
>Your kind help would be appreciated.
>Peter
>
>.
>
> Change your connection string to :
> 'Provider=SQLOLEDB.1; Password="";Persist Security
> Info=True;User
> ID=Bis;Initial Catalog=BIS;Data Source=(local)'
It worked.
Thanks a lot !

No "Left" function in Expression Builder?

Anyone know the reaon the Left function was left out of the list of string functions in the Expression Builder?

Danno

DannoCoy wrote:

Anyone know the reaon the Left function was left out of the list of string functions in the Expression Builder?

Danno

No. Annoying isn't it?

Instead you can use REVERSE(RIGHT())

-Jamie

|||I think SUBSTRING would be slightly faster for simple operations. You got your nesting the wrong way round as well, but we know what you mean.|||

DarrenSQLIS wrote:

I think SUBSTRING would be slightly faster for simple operations. You got your nesting the wrong way round as well, but we know what you mean.

Oh you're so picky :)

Next Item in String

I'm creating a report and wish to use field {Session_Starts.Special_Date}. It is a string field and I want to create a formula where this field automatically draws in the next string item.
Example if the special date is March 26, 2007, I want it to use the next string item, which is April 9, 2007. I can't use +14, because the next string item isn't always +14 days.
Can anyone help me with the formula to use?
Thanks so much in advance!So you want the {Session_Starts.Special_Date} value of the next record? Use the Next function! Look in the help.

newline in format string

Can I insert a newline character within a reporting services format string?
I guess \n doesn't work since it is interpreted as a VisualBasic format
string...? Is there an alternative?
Thanks,
Michael CarrvbNewLine
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> Can I insert a newline character within a reporting services format
string?
> I guess \n doesn't work since it is interpreted as a VisualBasic format
> string...? Is there an alternative?
> Thanks,
> Michael Carr
>|||Hmm I think I may have located a bug...
1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
"h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
least) out to a linefeed in the HTML textfile which does NOT translate into
a linefeed in the browser.
2. On the other hand, if I use vbNewline in the VALUE itself, i.e. =Format(Fields!Date.Value, "M/dd/yy") & vbNewline & Format(Fields!Date.Value,
"h:mm tt"), then the vbNewline is rendered out as <br/>
This seems to be an inconsistency in the HTML renderer ... ?
Michael Carr
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> vbNewLine
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > Can I insert a newline character within a reporting services format
> string?
> >
> > I guess \n doesn't work since it is interpreted as a VisualBasic format
> > string...? Is there an alternative?
> >
> > Thanks,
> > Michael Carr
> >
> >
>|||Please clarify the steps to reproduce. I tried the first expression on SP1
and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
"12:00:00".
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:OhZEbx0eEHA.2604@.TK2MSFTNGP12.phx.gbl...
> Hmm I think I may have located a bug...
> 1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
> "h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
> least) out to a linefeed in the HTML textfile which does NOT translate
into
> a linefeed in the browser.
> 2. On the other hand, if I use vbNewline in the VALUE itself, i.e. => Format(Fields!Date.Value, "M/dd/yy") & vbNewline &
Format(Fields!Date.Value,
> "h:mm tt"), then the vbNewline is rendered out as <br/>
> This seems to be an inconsistency in the HTML renderer ... ?
> Michael Carr
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> > vbNewLine
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > > Can I insert a newline character within a reporting services format
> > string?
> > >
> > > I guess \n doesn't work since it is interpreted as a VisualBasic
format
> > > string...? Is there an alternative?
> > >
> > > Thanks,
> > > Michael Carr
> > >
> > >
> >
> >
>|||Ravi,
Please see the report below (and attached) for an example. Note that this
renders correctly in the Report Editor Preview, but does not render
correctly in the Report Manager.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Date">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>= "M/d/yyyy" & vbNewline & "h:mm tt"</Format>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>Date</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Date_1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Date_1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Format(Fields!Date.Value, "M/d/yyyy") & vbNewline &
Format(Fields!Date.Value, "h:mm tt")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Top>0.5in</Top>
<Width>4.33333in</Width>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Left>1.125in</Left>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="SkyScheduler">
<rd:DataSourceID>6617abfe-bebd-49ae-a365-417ab349c748</rd:DataSourceID>
<DataSourceReference>SkyScheduler</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Date">
<DataField>Date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>SkyScheduler</DataSourceName>
<CommandText>SELECT CONVERT(smalldatetime, '1/1/2000 3:00pm') AS
Date</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>6c9977cc-7283-416b-a107-65d98a0c8dd2</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ODeNfFnfEHA.708@.TK2MSFTNGP09.phx.gbl...
> Please clarify the steps to reproduce. I tried the first expression on SP1
> and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
> "12:00:00".
begin 666 BRExample.rdl
M/#]X;6P@.=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@.B/SX-"CQ297!O
M<G0@.>&UL;G,](FAT=' Z+R]S8VAE;6%S+FUI8W)O<V]F="YC;VTO<W%L<V5R
M=F5R+W)E<&]R=&EN9R\R,# S+S$P+W)E<&]R=&1E9FEN:71I;VXB('AM;&YS
M.G)D/2)H='1P.B\O<V-H96UA<RYM:6-R;W-O9G0N8V]M+U-13%-E<G9E<B]R
M97!O<G1I;F<O<F5P;W)T9&5S:6=N97(B/@.T*(" \4FEG:'1-87)G:6X^,6EN
M/"]2:6=H=$UA<F=I;CX-"B @./$)O9'D^#0H@.(" @./%)E<&]R=$ET96US/@.T*
M(" @.(" @./%1A8FQE($YA;64](G1A8FQE,2(^#0H@.(" @.(" @.(#Q(96EG:'0^
M,"XW-6EN/"](96EG:'0^#0H@.(" @.(" @.(#Q3='EL92 O/@.T*(" @.(" @.(" \
M2&5A9&5R/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.(" @.(" @.(" @.(" \
M5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^,"XR-6EN/"](96EG
M:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @.
M(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.(" \4F5P;W)T271E
M;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X($YA;64](G1E>'1B
M;W@.Q(CX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO
M5&5X=$%L:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F="
M;W1T;VT^,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q:26YD97@.^-3PO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#QR9#I$969A=6QT3F%M93YT97AT8F]X,3PO<F0Z1&5F875L
M=$YA;64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO
M0V%N1W)O=SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64^1&%T93PO
M5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO5&5X=&)O>#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.
M/"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.
M(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O>#(B/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0
M861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%1E>'1!;&EG;CY,969T/"]497AT06QI9VX^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O='1O;3XR<'0\+U!A9&1I;F="
M;W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR
M<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E
M>#XT/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U
M;'1.86UE/G1E>'1B;W@.R/"]R9#I$969A=6QT3F%M93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#86Y'<F]W/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q686QU93Y$871E/"]686QU93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @./"]486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @./"]486)L95)O
M=SX-"B @.(" @.(" @.(" \+U1A8FQE4F]W<SX-"B @.(" @.(" @./"](96%D97(^
M#0H@.(" @.(" @.(#Q$971A:6QS/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.
M(" @.(" @.(" @.(" \5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^
M,"XR-6EN/"](96EG:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*
M(" @.(" @.(" @.(" @.(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X
M($YA;64](D1A=&4B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A
M9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$9O<FUA=#X]
M(")-+V0O>7EY>2(@.)F%M<#L@.=F).97=L:6YE("9A;7 [(")H.FUM('1T(CPO
M1F]R;6%T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1!;&EG;CY,
M969T/"]497AT06QI9VX^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9T)O='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN
M9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E>#XQ/"]:26YD97@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/D1A=&4\+W)D.D1E9F%U
M;'1.86UE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\
M+T-A;D=R;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&:65L
M9',A1&%T92Y686QU93PO5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO
M5&5X=&)O>#X-"B @.(" @.(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.
M(" @.(" @.(" @.(" @.(" @./"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M/%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB1&%T95\Q(CX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO5&5X=$%L
M:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^
M,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M/%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#QR9#I$969A=6QT3F%M93Y$871E7S$\+W)D.D1E9F%U;'1.86UE
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\+T-A;D=R
M;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&;W)M870H1FEE
M;&1S(41A=&4N5F%L=64L(")-+V0O>7EY>2(I("9A;7 [('9B3F5W;&EN92 F
M86UP.R!&;W)M870H1FEE;&1S(41A=&4N5F%L=64L(")H.FUM('1T(BD\+U9A
M;'5E/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO
M5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.
M(" @.(" @.(" \+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*
M(" @.(" @.(" \+T1E=&%I;',^#0H@.(" @.(" @.(#Q$871A4V5T3F%M93Y$871A
M4V5T,3PO1&%T85-E=$YA;64^#0H@.(" @.(" @.(#Q4;W ^,"XU:6X\+U1O<#X-
M"B @.(" @.(" @./%=I9'1H/C0N,S,S,S-I;CPO5VED=&@.^#0H@.(" @.(" @.(#Q&
M;V]T97(^#0H@.(" @.(" @.(" @./%1A8FQE4F]W<SX-"B @.(" @.(" @.(" @.(#Q4
M86)L95)O=SX-"B @.(" @.(" @.(" @.(" @./$AE:6=H=#XP+C(U:6X\+TAE:6=H
M=#X-"B @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" @.
M(" @./%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M
M<SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O
M>#<B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^,G!T
M/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A
M9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(#Q:26YD97@.^,SPO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(#QR9#I$969A=6QT3F%M93YT97AT8F]X-SPO<F0Z1&5F875L=$YA;64^#0H@.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO0V%N1W)O=SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64@.+SX-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @.(" \5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" @.(" @./%)E
M<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \5&5X=&)O>"!.86UE
M/2)T97AT8F]X."(^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%-T>6QE/@.T*
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=,969T/C)P=#PO4&%D
M9&EN9TQE9G0^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O
M='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @./%I);F1E>#XR/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/G1E>'1B;W@.X/"]R9#I$969A=6QT
M3F%M93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#
M86Y'<F]W/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q686QU92 O/@.T*(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO5&%B;&5#96QL
M/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" \
M+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*(" @.(" @.(" \
M+T9O;W1E<CX-"B @.(" @.(" @./$QE9G0^,2XQ,C5I;CPO3&5F=#X-"B @.(" @.
M(" @./%1A8FQE0V]L=6UN<SX-"B @.(" @.(" @.(" \5&%B;&5#;VQU;6X^#0H@.
M(" @.(" @.(" @.(" \5VED=&@.^,BXQ-C8V-VEN/"]7:61T:#X-"B @.(" @.(" @.
M(" \+U1A8FQE0V]L=6UN/@.T*(" @.(" @.(" @.(#Q486)L94-O;'5M;CX-"B @.
M(" @.(" @.(" @.(#Q7:61T:#XR+C$V-C8W:6X\+U=I9'1H/@.T*(" @.(" @.(" @.
M(#PO5&%B;&5#;VQU;6X^#0H@.(" @.(" @.(#PO5&%B;&5#;VQU;6YS/@.T*(" @.
M(" @./"]486)L93X-"B @.(" \+U)E<&]R=$ET96US/@.T*(" @.(#Q3='EL92 O
M/@.T*(" @.(#Q(96EG:'0^,FEN/"](96EG:'0^#0H@.(#PO0F]D>3X-"B @./%1O
M<$UA<F=I;CXQ:6X\+U1O<$UA<F=I;CX-"B @./$1A=&%3;W5R8V5S/@.T*(" @.
M(#Q$871A4V]U<F-E($YA;64](E-K>5-C:&5D=6QE<B(^#0H@.(" @.(" \<F0Z
M1&%T85-O=7)C94E$/C8V,3=A8F9E+6)E8F0M-#EA92UA,S8U+30Q-V%B,S0Y
M8S<T.#PO<F0Z1&%T85-O=7)C94E$/@.T*(" @.(" @./$1A=&%3;W5R8V52969E
M<F5N8V4^4VMY4V-H961U;&5R/"]$871A4V]U<F-E4F5F97)E;F-E/@.T*(" @.
M(#PO1&%T85-O=7)C93X-"B @./"]$871A4V]U<F-E<SX-"B @./%=I9'1H/C8N
M-6EN/"]7:61T:#X-"B @./$1A=&%3971S/@.T*(" @.(#Q$871A4V5T($YA;64]
M(D1A=&%3970Q(CX-"B @.(" @.(#Q&:65L9',^#0H@.(" @.(" @.(#Q&:65L9"!.
M86UE/2)$871E(CX-"B @.(" @.(" @.(" \1&%T849I96QD/D1A=&4\+T1A=&%&
M:65L9#X-"B @.(" @.(" @.(" \<F0Z5'EP94YA;64^4WES=&5M+D1A=&54:6UE
M/"]R9#I4>7!E3F%M93X-"B @.(" @.(" @./"]&:65L9#X-"B @.(" @.(#PO1FEE
M;&1S/@.T*(" @.(" @./%%U97)Y/@.T*(" @.(" @.(" \1&%T85-O=7)C94YA;64^
M4VMY4V-H961U;&5R/"]$871A4V]U<F-E3F%M93X-"B @.(" @.(" @./$-O;6UA
M;F1497AT/E-%3$5#5"!#3TY615)4*'-M86QL9&%T971I;64L("<Q+S$O,C P
M," S.C P<&TG*2!!4R!$871E/"]#;VUM86YD5&5X=#X-"B @.(" @.(" @./')D
M.E5S94=E;F5R:6-$97-I9VYE<CYT<G5E/"]R9#I5<V5'96YE<FEC1&5S:6=N
M97(^#0H@.(" @.(" \+U%U97)Y/@.T*(" @.(#PO1&%T85-E=#X-"B @./"]$871A
M4V5T<SX-"B @./$QE9G1-87)G:6X^,6EN/"],969T36%R9VEN/@.T*(" \<F0Z
M4VYA<%1O1W)I9#YT<G5E/"]R9#I3;F%P5&]'<FED/@.T*(" \<F0Z1')A=T=R
M:60^=')U93PO<F0Z1')A=T=R:60^#0H@.(#QR9#I297!O<G1)1#XV8SDY-S=C
M8RTW,C@.S+30Q-F(M83$P-RTV-60Y.&$P8SAD9#(\+W)D.E)E<&]R=$E$/@.T*
M(" \0F]T=&]M36%R9VEN/C%I;CPO0F]T=&]M36%R9VEN/@.T*(" \3&%N9W5A
>9V4^96XM55,\+TQA;F=U86=E/@.T*/"]297!O<G0^
`
end|||Ravi,
Did you get a chance to look at the example I posted?
Michael Carr
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> Ravi,
> Please see the report below (and attached) for an example. Note that this
> renders correctly in the Report Editor Preview, but does not render
> correctly in the Report Manager.|||I will look into this today.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Ravi,
> Did you get a chance to look at the example I posted?
> Michael Carr
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > Ravi,
> >
> > Please see the report below (and attached) for an example. Note that
this
> > renders correctly in the Report Editor Preview, but does not render
> > correctly in the Report Manager.
>|||I have logged this as a bug in HTML renderer which may be fixed in a future
release. Thanks for reporting this issue.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:OXh8fEThEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I will look into this today.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> > Ravi,
> >
> > Did you get a chance to look at the example I posted?
> >
> > Michael Carr
> >
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > > Ravi,
> > >
> > > Please see the report below (and attached) for an example. Note that
> this
> > > renders correctly in the Report Editor Preview, but does not render
> > > correctly in the Report Manager.
> >
> >
>

newline character

I want to append a newline character to a string.
what is a new-line character in SQL Server 2000?
Can someone help me.
Thank You.select 'gola' + char(13) + 'Munjal'
try this
cheers
gola

Originally posted by swatisk
I want to append a newline character to a string.
what is a new-line character in SQL Server 2000?

Can someone help me.
Thank You.|||thanx for ur help..

Originally posted by golamunjal
select 'gola' + char(13) + 'Munjal'
try this
cheers
gola