images loading slow corrupts the report

I have a report with an embedded image which appears in every row(static), it
also has a report that it drills down to. This page that calls this report
uses the reportviewer. the report loads quick, but the images take a while
longer. If I hit the column that drills to the next report, I can see the
page call the server, but the report stays on the same page. Yet the
reportviewer showbackbutton becomes active. If you hit the backbutton on
the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
be found .
How do I get the images quicker?
How do I keep the above problem from happening?On Jul 5, 5:32 pm, NeedToKnow <NeedToK...@.newsgroups.nospam> wrote:
> I have a report with an embedded image which appears in every row(static), it
> also has a report that it drills down to. This page that calls this report
> uses the reportviewer. the report loads quick, but the images take a while
> longer. If I hit the column that drills to the next report, I can see the
> page call the server, but the report stays on the same page. Yet the
> reportviewer showbackbutton becomes active. If you hit the backbutton on
> the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
> be found .
> How do I get the images quicker?
> How do I keep the above problem from happening?
It seems like you are using too many resources while trying to render
several images. If your images are MPEG, I would suggest converting
them to JPG/JPEG/GIF which should conserve space and improve
performance a little. It seems from your description that the
execution error is related to the resource utilization (of the
rendering). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||My resource is one gif that is 925 bytes in size. It appears on every line
of the table. It is not a resource error. It comes from the reportviewer
when it is trying to load the drill down report.
"EMartinez" wrote:
> On Jul 5, 5:32 pm, NeedToKnow <NeedToK...@.newsgroups.nospam> wrote:
> > I have a report with an embedded image which appears in every row(static), it
> > also has a report that it drills down to. This page that calls this report
> > uses the reportviewer. the report loads quick, but the images take a while
> > longer. If I hit the column that drills to the next report, I can see the
> > page call the server, but the report stays on the same page. Yet the
> > reportviewer showbackbutton becomes active. If you hit the backbutton on
> > the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
> > be found .
> > How do I get the images quicker?
> > How do I keep the above problem from happening?
>
> It seems like you are using too many resources while trying to render
> several images. If your images are MPEG, I would suggest converting
> them to JPG/JPEG/GIF which should conserve space and improve
> performance a little. It seems from your description that the
> execution error is related to the resource utilization (of the
> rendering). Sorry that I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Images in header shifting...

I have placed various images in my page header. I am finding that on the
first page, my image is shifting about an inch to the left, but on the
second page, it is placed correctly. Has anyone found this to be true or
know how to fix it?
Thanks,
LisaMany of these issues were addressed in SP1. Have you installed it?
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:Oe3ZmusXEHA.3476@.tk2msftngp13.phx.gbl...
> I have placed various images in my page header. I am finding that on the
> first page, my image is shifting about an inch to the left, but on the
> second page, it is placed correctly. Has anyone found this to be true or
> know how to fix it?
> Thanks,
> Lisa
>|||Yes I have.
Lisa
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:%23eVZV6sXEHA.2940@.TK2MSFTNGP09.phx.gbl...
> Many of these issues were addressed in SP1. Have you installed it?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
> news:Oe3ZmusXEHA.3476@.tk2msftngp13.phx.gbl...
> > I have placed various images in my page header. I am finding that on
the
> > first page, my image is shifting about an inch to the left, but on the
> > second page, it is placed correctly. Has anyone found this to be true
or
> > know how to fix it?
> >
> > Thanks,
> >
> > Lisa
> >
> >
>|||I have noticed that HTML does not handle overlapping of controls very well.
In PDF format the control positions do not move if they overlap.
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:Oe3ZmusXEHA.3476@.tk2msftngp13.phx.gbl...
> I have placed various images in my page header. I am finding that on the
> first page, my image is shifting about an inch to the left, but on the
> second page, it is placed correctly. Has anyone found this to be true or
> know how to fix it?
> Thanks,
> Lisa
>|||If overlapping is the problem, you could try making a composite image of
your seperate images and set it as a BackGroundImage (No Repeat).
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:Oe3ZmusXEHA.3476@.tk2msftngp13.phx.gbl...
> I have placed various images in my page header. I am finding that on the
> first page, my image is shifting about an inch to the left, but on the
> second page, it is placed correctly. Has anyone found this to be true or
> know how to fix it?
> Thanks,
> Lisa
>

image size

Hello

I added a background jpg file into my report. It seems the image is bigger then my page size, is there any way I can say fit the image size to page size?

Sounds like your image is huge! Why not make a smaller image and do a repeating background?

Background Image Repeat

You can have a background image repeat vertically (y), horizontally (x), in both directions, or in neither direction.

CSS Code:

p {
background-image: url(smallPic.jpg);
background-repeat: repeat; }
p {
background-image: url(smallPic.jpg);
background-repeat: repeat-y; }
p {
background-image: url(smallPic.jpg);
background-repeat: repeat-x; }
p {
background-image: url(smallPic.jpg);
background-repeat: no-repeat; }

Image in Page Header

I'm running into an problem where I have an image in the page header of my report and I added sorting options to my column headers. When I sort the column when viewing the report, the image in the page header does not appear anymore (the little red box appears instead of the image.) Has anyone run into this same problem and figured out to fix it?

Thanks!

I think you want to post your question to SQL Server Reporting Services (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)

Ovidiu

Image control in RDLC report page.

Using RDLC report file, How can i set the image path on image control to the image in my folder \images.

I don't see any ImageURL property in such control.

thanks,

Hi,

From your description, it seems that you want to add a image in your report, right?

You can include stored images in a report by specifying a URL to the image. When you use an external image in a report, the image source is set to External and the value for the image is the URL address to the image. For a report published to a report server configured for native mode, use a full or relative path. For example,http://<servername>/images/image1.jpg. For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL. For example,http://<SharePointservername>/<site>/Documents/images/image1.jpg.

For more information, see:

http://msdn2.microsoft.com/en-us/library/ms156482.aspx

Thanks.

image causing extra page in PDF export

HI

I have a report, on the first page I have:

Single Line of text

Single Line of text

IMage 2.04 " by 2.04 " (centered)

Single Line of Text

Single line of text

Looks fine in report viewer, but when exported to PDF, all the text lines are on the first page, and the image is on the second page by itself off center.

Any ideas?

Thanks

Bob

bump

Image .BMP only shows on first page, place holder on the rest

I am printing a batch of Explanation of Benefits and the image only shows on the first page for each person. If they have additional pages all I get is the little red X.
Thanks,
Phil

Bump - If I want an image on every page where do I put it.|||

This should work fine if you:

Put the image in the report header|||

As I had said in the initial post, the image is ther on page one but not on page two. Now the report may consist of 100 invoices. The ones with more detail that cause the individual report to go over spread over two or more pages do not display the image on page 2,3....

It is a page header and therefor print on ever page. It is not in the report header.

|||

I wasn't clear on that from the initial post. It really depends on the report layout. From what you say I'm assuming that you have a list control that's grouped by person with page break option checked. In addition to that some users data spans multiple pages. What's confusing is that you mention that you get a red X (image place holder) but no image. Where is the image placed? In the header, the body, a list control?

To my knowledge there are 2 things you can have repeated when paging:

The overall report header|||Why isn't the page header repeated on every page. Am I missing something in what I expect the definiton of a page header would be. The globabl function for printing page number ? knows that it is a new page. So why doesn't the image print on the second page. I eneded up telling the user SSRS wasn't cable of what we wanted and I removed the functionality for printing images based on a selection in a list box. Back to sw.writeline.|||

I'm afraid I'm still not clear on exactly what you are trying to do in the report and how it's set up. based on your comments i can only guess that you have a parameter who's value you are using to display an image. Is that correct?

You'll need to post some more details about the report setup.

Im not able to insert data from a form into a database table

Hello. As the subject heading says, I'm not able to insert data typed into the contact form on my page into a database table. I'm using an SqlDataSource object. Here's the code for this page:

<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@. Page Language="VB" Debug="True" Explicit="True" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.Odbc" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<div align="center">
<asp:label ID="label1" runat="server" Font-Name="Arial" Font-Size="24" ForeColor="#00FF00" />
</div>
<div align="center">
<asp:label ID="label2" runat="server" Font-Name="Verdana" Font-Size="18" ForeColor="#0000FF" />
</div>
<form runat="server" id="new_form">
<table width="50%" border="1" align="center" id="form_table">
<tr>
<td nowrap="nowrap">
<asp:label Font-Bold="true" Font-Size="10" runat="server" Font-Name="CarlysHand" Text="First Name" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("FirstName") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="15" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="first" TabIndex="1" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="first" Type="String" ErrorMessage="Please enter your first name." Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Middle Initial" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("MI") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="1" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="mi" TabIndex="2" /></td>
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Last Name" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("LastName") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="18" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="last" TabIndex="3" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="last" Type="String" ErrorMessage="Please enter your last name." Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Number & Street" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("NoAndStreet") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="40" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="no_and_street" TabIndex="4" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="no_and_street" Type="String" ErrorMessage="Please enter your number and street." Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Unit #" BackColor="#FFE1E1" ForeColor="#FF0000" />
</td>
<td><asp:textbox text='<%#Bind("Unit") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="6" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="unit" TabIndex="5" /></td>
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="City" BackColor="#FFE1E1" ForeColor="#FF0000" />
</td>
<td><asp:textbox text='<%#Bind("City") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="20" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="city" TabIndex="6" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="city" Type="String" ErrorMessage="Please enter your city." Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="State" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("State") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="2" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="state" TabIndex="7" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="state" ErrorMessage="Please enter your state." Type="String" Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Zip Code" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("ZipCode") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="5" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="zip" TabIndex="8" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="zip" ErrorMessage="Please enter your zip code." Type="Integer" Display="Dynamic" />
<asp:regularexpressionvalidator Display="Dynamic" runat="server" ValidationExpression="[0123456789]{5}" ControlToValidate="zip" ErrorMessage="Please enter a valid US Zip Code" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Phone #" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("PhoneNumber") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="10" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="phone" TabIndex="9" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="phone" ErrorMessage="Please enter your phone number." Type="Double" Display="Dynamic" />
<asp:rangevalidator runat="server" ControlToValidate="phone" MinimumValue="2002000000" MaximumValue="9999999999" Type="Double" ErrorMessage="Please enter a valid US Phone Number." Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Email" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("Email") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="40" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="email" TabIndex="10" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="email" ErrorMessage="Please enter your email address." Type="String" Display="Dynamic" />
<asp:regularexpressionvalidator runat="server" ControlToValidate="email" ErrorMessage="Please enter a valid email address." ValidationExpression=".*@..{2,}\..{2,}" Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Username" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox text='<%#Bind("Username") %>' BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="12" TextMode="SingleLine" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="username" TabIndex="11" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="username" ErrorMessage="Please enter your username." Type="String" Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Password" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td> <asp:textbox text='<%#Bind("Password") %>' Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="12" TextMode="Password" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="password" TabIndex="12" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="password" ErrorMessage="Please enter your password." Type="String" Display="Dynamic" />
</tr>
<tr>
<td nowrap="nowrap">
<asp:label Font-Size="10" Font-Bold="true" runat="server" Font-Name="CarlysHand" Text="Confirm Password" BackColor="#FFE1E1" ForeColor="#FF0000" /></td>
<td><asp:textbox Font-Size="10" BorderColor="#BF0000" BorderStyle="Groove" BorderWidth="2" BackColor="#FFCCFF" ForeColor="#FF0000" Columns="12" TextMode="Password" Font-Bold="true" Font-Name="CarlysHand" runat="server" ID="confirm" TabIndex="13" /></td>
<asp:requiredfieldvalidator runat="server" ControlToValidate="confirm" ErrorMessage="Please confirm your password." Type="String" Display="Dynamic" />
<asp:comparevalidator runat="server" ControlToValidate="confirm" ControlToCompare="password" Type="String" ErrorMessage="Please input matching passwords." Display="Dynamic" />
</tr>
<tr>
<td colspan="2" align="center" nowrap="nowrap"><asp:linkbutton BorderColor="#0000FF" BorderWidth="3" BorderStyle="Dotted" ToolTip="Click me!" Text="Submit" Font-Name="CarlysHand" Font-Size="15" Font-Bold="true" BackColor="#CCCCCC" ForeColor="#FF0000" runat="server" ID="submit" TabIndex="14" /></td>
</tr>
</table>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="driver={MySQL ODBC 3.51 Driver};server=mysql01.discountasp.net;
data source=bkfwebdesi1_mysqlConn;database=MYSQLDB_316823;uid=bkfwebdesi1;
password=bkf2065"
ProviderName="System.Data.Odbc"
InsertCommand="INSERT INTO ContactInfo VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?)">
<InsertParameters>
<asp:Parameter Name="ContactID" Type="Int32" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="MI" Type="String" />
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="NoAndStreet" Type="String" />
<asp:Parameter Name="Unit" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="ZipCode" Type="Int32" />
<asp:Parameter Name="PhoneNumber" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="Username" Type="String" />
<asp:Parameter Name="Password" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</form>
</body>
</html>

Thanks in advance for your help in this matter!

Brian

You need to put your contact form inside a databound control - such as a FormView. Then you need to associate the FormView with your datasource. At the moment, your fields have no connection with the SqlDataSource.

The other problem is that the SqlDataSource will ONLY work with an SQL Server database. Download a free version of SQL Server Express, or if you HAVE to use MySQL (yuk), you need to use another way of passing commands to the datasource. I don't know which one, but probably the ODBC provider for .NET <me shudders>.

I'm confused with the non-unicode

I was confused with the non-unicode when i insert chinese characters in
a varchar field using asp page, it accepted the characters and
displayed correctly. It is good for me, but i was wondering what
exactly non-unicode is and why acting like that way(I expected to
receive strange characters in the feedback asp page but i didn't). Can
anyone tell me the reason?What is the collation of the column in the table? Also, did you try
comparing two columns with that data?
MC
"jane" <bidepan@.msn.com> wrote in message
news:1167926378.282209.127980@.6g2000cwy.googlegroups.com...
>I was confused with the non-unicode when i insert chinese characters in
> a varchar field using asp page, it accepted the characters and
> displayed correctly. It is good for me, but i was wondering what
> exactly non-unicode is and why acting like that way(I expected to
> receive strange characters in the feedback asp page but i didn't). Can
> anyone tell me the reason?
>|||Thanks for your reply MC, it's all default setting. I can't understand
your other question. It appears to be like ऒझ stored in the
database but it is displayed correctly(the correct character)in asp
pages. what i'm conserning is why the Unicode data can be stored in a
varchar(for non-Unicode) column and retrieved correctly, which i
suppose should not.
On Jan 4, 1:03 pm, "MC" <marko.NOSPAMc...@.gmail.com> wrote:
> What is the collation of the column in the table? Also, did you try
> comparing two columns with that data?
> MC
> "jane" <bide...@.msn.com> wrote in messagenews:1167926378.282209.127980@.6g2000cwy.googlegroups.com...
>
> >I was confused with the non-unicode when i insert chinese characters in
> > a varchar field using asp page, it accepted the characters and
> > displayed correctly. It is good for me, but i was wondering what
> > exactly non-unicode is and why acting like that way(I expected to
> > receive strange characters in the feedback asp page but i didn't). Can
> > anyone tell me the reason... Hide quoted text -- Show quoted text -|||Well, basically you're reading the same characters you inserted. My second q
was, did you try comparing on those characters? For example:
Table1 has col1 varchar(100)
Table2 has col2 varchar(100)
Insert same string in both tables (chinese chars). Then see what happens
when you say WHERE col1 = col2 or something like that (thats what I meant by
comparing values). Try the same thing with parameter and comparing values
in columns to parameter...
MC
"jane" <bidepan@.msn.com> wrote in message
news:1167936168.510779.204100@.s80g2000cwa.googlegroups.com...
> Thanks for your reply MC, it's all default setting. I can't understand
> your other question. It appears to be like ऒझ stored in the
> database but it is displayed correctly(the correct character)in asp
> pages. what i'm conserning is why the Unicode data can be stored in a
> varchar(for non-Unicode) column and retrieved correctly, which i
> suppose should not.
> On Jan 4, 1:03 pm, "MC" <marko.NOSPAMc...@.gmail.com> wrote:
>> What is the collation of the column in the table? Also, did you try
>> comparing two columns with that data?
>> MC
>> "jane" <bide...@.msn.com> wrote in
>> messagenews:1167926378.282209.127980@.6g2000cwy.googlegroups.com...
>>
>> >I was confused with the non-unicode when i insert chinese characters in
>> > a varchar field using asp page, it accepted the characters and
>> > displayed correctly. It is good for me, but i was wondering what
>> > exactly non-unicode is and why acting like that way(I expected to
>> > receive strange characters in the feedback asp page but i didn't). Can
>> > anyone tell me the reason... Hide quoted text -- Show quoted text -
>

I'm confused with the non-unicode

I was confused with the non-unicode when i insert chinese characters in
a varchar field using asp page, it accepted the characters and
displayed correctly. It is good for me, but i was wondering what
exactly non-unicode is and why acting like that way(I expected to
receive strange characters in the feedback asp page but i didn't). Can
anyone tell me the reason?What is the collation of the column in the table? Also, did you try
comparing two columns with that data?
MC
"jane" <bidepan@.msn.com> wrote in message
news:1167926378.282209.127980@.6g2000cwy.googlegroups.com...
>I was confused with the non-unicode when i insert chinese characters in
> a varchar field using asp page, it accepted the characters and
> displayed correctly. It is good for me, but i was wondering what
> exactly non-unicode is and why acting like that way(I expected to
> receive strange characters in the feedback asp page but i didn't). Can
> anyone tell me the reason?
>|||Thanks for your reply MC, it's all default setting. I can't understand
your other question. It appears to be like ऒझ stored in the
database but it is displayed correctly(the correct character)in asp
pages. what i'm conserning is why the Unicode data can be stored in a
varchar(for non-Unicode) column and retrieved correctly, which i
suppose should not.
On Jan 4, 1:03 pm, "MC" <marko.NOSPAMc...@.gmail.com> wrote:[vbcol=seagreen]
> What is the collation of the column in the table? Also, did you try
> comparing two columns with that data?
> MC
> "jane" <bide...@.msn.com> wrote in messagenews:1167926378.282209.127980@.6g2
000cwy.googlegroups.com...
>
>|||Well, basically you're reading the same characters you inserted. My second q
was, did you try comparing on those characters? For example:
Table1 has col1 varchar(100)
Table2 has col2 varchar(100)
Insert same string in both tables (chinese chars). Then see what happens
when you say WHERE col1 = col2 or something like that (thats what I meant by
comparing values). Try the same thing with parameter and comparing values
in columns to parameter...
MC
"jane" <bidepan@.msn.com> wrote in message
news:1167936168.510779.204100@.s80g2000cwa.googlegroups.com...
> Thanks for your reply MC, it's all default setting. I can't understand
> your other question. It appears to be like ऒझ stored in the
> database but it is displayed correctly(the correct character)in asp
> pages. what i'm conserning is why the Unicode data can be stored in a
> varchar(for non-Unicode) column and retrieved correctly, which i
> suppose should not.
> On Jan 4, 1:03 pm, "MC" <marko.NOSPAMc...@.gmail.com> wrote:
>

IIS Virtual Directory Manager and IIS 6: Template requests not being actioned.

Hi,
I have XML Data Islands on my page that are correctly requesting data
from the Virtual Directory. I can see the requests in the IIS log.
However the virtual directory doesn't seem to be returning anything -
no error message no nothing. When I run the same query from IE6
directly it runs fine.
I have run a trace on the database and nothing is being requested.
How can I debug this - is there an error log somewhere that I could
look at? What am I missing?
Info: SQL Server 2000 SP4 is on a separate database. I am using
Integrated Windows Authentication and delegation.
Cheers,
JamesSorry, this was specific to our setup... ignore.
JimLad wrote:

> Hi,
> I have XML Data Islands on my page that are correctly requesting data
> from the Virtual Directory. I can see the requests in the IIS log.
> However the virtual directory doesn't seem to be returning anything -
> no error message no nothing. When I run the same query from IE6
> directly it runs fine.
> I have run a trace on the database and nothing is being requested.
> How can I debug this - is there an error log somewhere that I could
> look at? What am I missing?
> Info: SQL Server 2000 SP4 is on a separate database. I am using
> Integrated Windows Authentication and delegation.
> Cheers,
> James

IIS is not running

Hi,
I have MS 2000 server with IIS. When I type http://localhost, it bring me t
o Lycos search page. How do I know if IIS has started? Is this info displa
yed in the Admin tool's Services sreen? Thank you.
ChrisHi Chris,
Yes go to the IIS admin snap in and check the status of the default web
site. This will tell you if it is running.
Or from the cmd prompt type in
Net start and look for World Wide Web Publishing Service
You can type
net start "world wide web publishing service"
to start the service.
"yingjian ma" <yingjian.ma@.cox.net> wrote in message
news:On5GnguCEHA.3024@.tk2msftngp13.phx.gbl...
Hi,
I have MS 2000 server with IIS. When I type http://localhost, it bring me
to Lycos search page. How do I know if IIS has started? Is this info
displayed in the Admin tool's Services sreen? Thank you.
Chris