cannot display chinese

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as '.
My website connect to MS SQL Server 2005 and all the chinese data are
displayed as '.
I try to fix the problem for several days, but still can't fix it. Please
help me to solve this problem.
here is the detail of my system.
* SQL Server 2005 via TCP/IP
* the connection string is "Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
Source=xx.xx.xx.xx;Password=xx;"Hi
A client displaying ?'s is when it can't interpret the character value,
therefore look at things like the codepage or Locale settings for the page
etc.
This may help:
http://databases.aspfaq.com/general/can-i-fix-this-mm/dd/yyyy-dd/mm/yyyy-confusion-once-and-for-all.html
John
"HK newsgroup" wrote:
> I cannot display Chinses at ASP page. All chinese data (whatever is
> Traditional or Simply Chinese) are displayed as '.
> My website connect to MS SQL Server 2005 and all the chinese data are
> displayed as '.
> I try to fix the problem for several days, but still can't fix it. Please
> help me to solve this problem.
> here is the detail of my system.
> * SQL Server 2005 via TCP/IP
> * the connection string is "Provider=SQLOLEDB.1;Persist Security
> Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
> Source=xx.xx.xx.xx;Password=xx;"
>
>

Cannot create subscription in with Report Manager

While on the Report Delivery Options page if I click "Select Schedule" or
"OK" nothing happens; no error message, no postback, nothing in the logs,
nothing in a SQL Trace. I cannot create a File Share nor an e-mail
subcription.
I am able to programmaticaly (using ReportServer WebService and
ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
ideas?have you checked who you are logged into report manager as. What user. do
they have permissions to create a schedule?
"mbianco21" wrote:
> While on the Report Delivery Options page if I click "Select Schedule" or
> "OK" nothing happens; no error message, no postback, nothing in the logs,
> nothing in a SQL Trace. I cannot create a File Share nor an e-mail
> subcription.
> I am able to programmaticaly (using ReportServer WebService and
> ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
> ideas?sql

Cannot Connect to the Analysis Server

I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO in
an ASP.NET page.
Here's my sample code:
Dim dsoServer As New DSO.Server
Dim dsoDB As DSO.MDStore
Dim dsoCube As DSO.MDStore
dsoServer.Connect ("LocalHost")
For Each dsoDB In dsoServer.MDStores
If dsoDB.Name = "XXX" Then
For Each dsoCube In dsoDB.MDStores
Debug.Print dsoCube.Name
Next
End If
Next
Here's the message i got:
"System.Runtime.InteropServices.COMException: Cannot
connect to the Analysis server on computer 'J.B.'.
Connection to the server is lost"
I've tried to follow this technical article but still result the same.
http://support.microsoft.com/default.aspx?kbid=823066
Any idea? Or is there any other way i can get what i want, other that connec
ting to DSO? I've been stuck with this problem for days. hope i can find a n
ew way to solve this.
Thnx in advanced.
J.B.I was just working on something similiar. Here are a few things you
may want to check.
1) Make sure anonymous authentication on your virtual directory in IIS
is off.
2) make sure your windows login is part of the olap_administrators
group.
3) and as it is stated in the KB articly you referenced below that you
add the <Identity impersonate ="true"/> to the web.config
turning off anonymous authentication on the virtual directory solved
the probliem in my situation.
Hope this helps
bmal
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...

quote:

---

> I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO
in an ASP.NET page.
> Here's my sample code:
> Dim dsoServer As New DSO.Server
> Dim dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
> dsoServer.Connect ("LocalHost")
> For Each dsoDB In dsoServer.MDStores
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
> Here's the message i got:
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
> I've tried to follow this technical article but still result the same.
> http://support.microsoft.com/default.aspx?kbid=823066
> Any idea? Or is there any other way i can get what i want, other that conn
ecting to DSO? I've been stuck with this problem for days. hope i can find a
new way to solve this.
> Thnx in advanced.
> J.B.

---

|||Thanks for your advice.
It works now.
~~
J.B.
-- bmal wrote: --
I was just working on something similiar. Here are a few things you
may want to check.
1) Make sure anonymous authentication on your virtual directory in IIS
is off.
2) make sure your windows login is part of the olap_administrators
group.
3) and as it is stated in the KB articly you referenced below that you
add the <Identity impersonate ="true"/> to the web.config
turning off anonymous authentication on the virtual directory solved
the probliem in my situation.
Hope this helps
bmal
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...[QUOTE]
> I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO
in an ASP.NET page.
> Here's my sample code:
> Dim dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
> http://support.microsoft.com/default.aspx?kbid=823066
> Thnx in advanced.

Cannot connect to sql through asp app.

iis and sql on same box. asp lan app.
I can open the initial page but get this error when i try to look up a
customer or other db dependant actions.
Microsoft OLE DB Provider for SQL Server (0x80040e4d)
Login failed for user 'sa'
/ctservice/view_edit_service/getindex.asp, line 22
the code on line 21-22:
Set connEditService = Server.CreateObject("ADODB.Connection")
connEditService.Open conString
This started when i tried to change the sa password so that i could
access the db for a mail merge. I don't have the original sa password
and i don't know if i enabled it by accident. If so how do i remove it
or fix this error? thanks jho.
On Jan 13, 4:36Xpm, jho <jhogan0...@.yahoo.com> wrote:
> iis and sql on same box. asp lan app.
> I can open the initial page but get this error when i try to look up a
> customer or other db dependant actions.
> Microsoft OLE DB Provider for SQL Server (0x80040e4d)
> Login failed for user 'sa'
> /ctservice/view_edit_service/getindex.asp, line 22
> the code on line 21-22:
> Set connEditService = Server.CreateObject("ADODB.Connection")
> connEditService.Open conString
> This started when i tried to change the sa password so that i could
> access the db for a mail merge. I don't have the original sa password
> and i don't know if i enabled it by accident. If so how do i remove it
> or fix this error? thanks jho.
I found the password for sa after searching all of the pages in the
site for, you guessed it, password duh....

Cannot connect to sql through asp app.

iis and sql on same box. asp lan app.
I can open the initial page but get this error when i try to look up a
customer or other db dependant actions.
Microsoft OLE DB Provider for SQL Server (0x80040e4d)
Login failed for user 'sa'
/ctservice/view_edit_service/getindex.asp, line 22
the code on line 21-22:
Set connEditService = Server.CreateObject("ADODB.Connection")
connEditService.Open conString
This started when i tried to change the sa password so that i could
access the db for a mail merge. I don't have the original sa password
and i don't know if i enabled it by accident. If so how do i remove it
or fix this error? thanks jho.On Jan 13, 4:36=A0pm, jho <jhogan0...@.yahoo.com> wrote:
> iis and sql on same box. asp lan app.
> I can open the initial page but get this error when i try to look up a
> customer or other db dependant actions.
> Microsoft OLE DB Provider for SQL Server (0x80040e4d)
> Login failed for user 'sa'
> /ctservice/view_edit_service/getindex.asp, line 22
> the code on line 21-22:
> Set connEditService =3D Server.CreateObject("ADODB.Connection")
> connEditService.Open conString
> This started when i tried to change the sa password so that i could
> access the db for a mail merge. I don't have the original sa password
> and i don't know if i enabled it by accident. If so how do i remove it
> or fix this error? thanks jho.
I found the password for sa after searching all of the pages in the
site for, you guessed it, password duh....