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 connect/login error message

I am trying to connect to a virtual directory where there is an application
that was developed in .asp.net - it is linked to a sql server database. I am
using IIS, Server 2003 and SQL Server 2000 - same server - Any ideas where
this may be coming from? I posted this message under connect and security
sections. Thanks.
Server Error in '/Admin' Application.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\NETWORK SERVICE'.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ut.hfrp.asap.DAO.BaseDAO.getConnection() +83
[DAOException: Unable to create connection to database]
ut.hfrp.asap.DAO.BaseDAO.getConnection() +154
ut.hfrp.asap.DAO.UserDAO.GetList() +70
ut.hfrp.asap.BusObj.Settings.AirlineSettings.GetUs erList() +30
ut.hfrp.asap.ManagerApp.Login.SubmitLogin_Click(Ob ject sender, EventArgs
e) +51
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
LizW
The ASP service Account is running under Networkservice Account which
is not priviledged in the SQL Server database. Either you change the
authentication in your application to SQL Server authentication
(Checkout the connectionstrings on www.connectionstrings.com for that)
or you change the service account of ASP to a domain or local account
which has to be priviledged in SQL Server.
HTH, Jens Suessmeyer.

cannot connect/login error message

I am trying to connect to a virtual directory where there is an application
that was developed in .asp.net - it is linked to a sql server database. I am
using IIS, Server 2003 and SQL Server 2000 - same server - Any ideas where
this may be coming from? I posted this message under connect and security
sections. Thanks.
Server Error in '/Admin' Application.
----
--
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information abou
t
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\NETWORK SERVICE'.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ut.hfrp.asap.DAO.BaseDAO.getConnection() +83
[DAOException: Unable to create connection to database]
ut.hfrp.asap.DAO.BaseDAO.getConnection() +154
ut.hfrp.asap.DAO.UserDAO.GetList() +70
ut.hfrp.asap.BusObj.Settings.AirlineSettings.GetUserList() +30
ut.hfrp.asap.ManagerApp.Login.SubmitLogin_Click(Object sender, EventArgs
e) +51
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
LizWThe ASP service Account is running under Networkservice Account which
is not priviledged in the SQL Server database. Either you change the
authentication in your application to SQL Server authentication
(Checkout the connectionstrings on www.connectionstrings.com for that)
or you change the service account of ASP to a domain or local account
which has to be priviledged in SQL Server.
HTH, Jens Suessmeyer.

cannot connect/login error message

I am trying to connect to a virtual directory where there is an application
that was developed in .asp.net - it is linked to a sql server database. I am
using IIS, Server 2003 and SQL Server 2000 - same server - Any ideas where
this may be coming from? I posted this message under connect and security
sections. Thanks.
Server Error in '/Admin' Application
----
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\NETWORK SERVICE'.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ut.hfrp.asap.DAO.BaseDAO.getConnection() +83
[DAOException: Unable to create connection to database]
ut.hfrp.asap.DAO.BaseDAO.getConnection() +154
ut.hfrp.asap.DAO.UserDAO.GetList() +70
ut.hfrp.asap.BusObj.Settings.AirlineSettings.GetUserList() +30
ut.hfrp.asap.ManagerApp.Login.SubmitLogin_Click(Object sender, EventArgs
e) +51
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
--
LizWThe ASP service Account is running under Networkservice Account which
is not priviledged in the SQL Server database. Either you change the
authentication in your application to SQL Server authentication
(Checkout the connectionstrings on www.connectionstrings.com for that)
or you change the service account of ASP to a domain or local account
which has to be priviledged in SQL Server.
HTH, Jens Suessmeyer.

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 SQLServer2000

Hello everyone,

My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.

Hi,

"SQL Server does not exist or access denied" is a generic Microsoft Data Access Components (MDAC) message that indicates that the computer that is running Microsoft SQL Server cannot be contacted. Since your problem occurs radomly. So it has many potential causes, the following link may provide some detail information.

http://support.microsoft.com/kb/328306/en-us

Thanks.

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....

Cannot connect to SQL Server 2005 DB from ASP.NET Configuration Tool

Hello,

I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:

--
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
--

The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:

<connectionStrings>

<removename="LocalSqlServer" />

<addname="LocalSqlServer"

connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"

providerName="System.Data.SqlClient" />

</connectionStrings>

ABC is a mock :)

Could anyone pls help? It is much appreciated.

Can you ping the servername successully? Try to use IP address instead of servername as Data Source. Also make sure no firewall is blocking the TCP/IP port used by the SQL Server service (check the port in SQL Server Configuration Manager->SQL Server 2005 Network Configuration)|||

Iori_Jay:

Can you ping the servername successully? Try to use IP address instead of servername as Data Source. Also make sure no firewall is blocking the TCP/IP port used by the SQL Server service (check the port in SQL Server Configuration Manager->SQL Server 2005 Network Configuration)

I can ping the server name successfully. The VWD Express can also connect to the server just fine. So, the firewall does not block the port. But ASP.NET Configuration tool cannot connect to the server. Why? Any ideas are much appreciated.

|||

It did not help to replace the server name by IP address either...

|||

I solved the problem. The process WebDev.WebServer.exe was not allowed to access the internet by the Zone Alarm Firewall. This is a default Zone Alarm setting, which has to be changed manually.

Cannot connect to MSOLAP Provider

I could not get my ASP pages to connect to the Analysis services
Server on a different box. The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")
cat.ActiveConnection = "Data Source=asServer;Initial
Catalog=MyMart;Provider=msolap;"
My environment is:
The web server box (Server A) : Windows 2003 Server with IIS6, SQL
Server Client sp3 and Analysis Service Client sp3 are both installed.
All other asp pages not using ADOMD all work fine. Most of the web
applications on this server are ASP.NET.
The AS Server box: Windows 2000 with SQL Server 2000 SP3 (8.00.760)
The problem page works fine on other Windows 2000 server with IIS 5.
And the strange thing is: from Server A, the MDX Sample Application
works fine.
Any help is greatly appreciatedHello Tommy,
I noticed that the issue was posted in several groups
(microsoft.public.sqlserver.olap, microsoft.public.sqlserver,
microsoft.public.sqlserver.datawarehouse
)._ I have added a reply to you at
http://msdn.microsoft.com/newsgroup...t.public.sqlser
ver.olap&lang=en&cr=US
If you have follow up questions, please post there and I will work with
you. Thanks.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Cannot connect to MSOLAP Provider

I could not get my ASP pages to connect to the Analysis services
Server on a different box. The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")
cat.ActiveConnection = "Data Source=asServer;Initial
Catalog=MyMart;Provider=msolap;"
My environment is:
The web server box (Server A) : Windows 2003 Server with IIS6, SQL
Server Client sp3 and Analysis Service Client sp3 are both installed.
All other asp pages not using ADOMD all work fine. Most of the web
applications on this server are ASP.NET.
The AS Server box: Windows 2000 with SQL Server 2000 SP3 (8.00.760)
The problem page works fine on other Windows 2000 server with IIS 5.
And the strange thing is: from Server A, the MDX Sample Application
works fine.
Any help is greatly appreciated
Hello Tommy,
I noticed that the issue was posted in several groups
(microsoft.public.sqlserver.olap, microsoft.public.sqlserver,
microsoft.public.sqlserver.datawarehouse
).X I have added a reply to you at
http://msdn.microsoft.com/newsgroups...public.sqlser
ver.olap&lang=en&cr=US
If you have follow up questions, please post there and I will work with
you. Thanks.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.