Support forums - SQLDatabase Problem

Support forums » Products » Cute Chat and Cute Web Messeng... » Re: SQLDatabase Problem

SQLDatabase Problem

Last post 05-26-2005, 10:41 AM by Adam. 5 replies.


	Sort Posts: Previous Next

05-25-2005, 3:26 PM 7000

Carolyn
Joined on 05-20-2005
Posts 32

SQLDatabase Problem

Reply Quote

I'm trying to set up the demo for CuteChat Standalone:

Can someone look at the below connect strings to tell me if they are correct. I am getting "Login failed for user lsux730". I have lsux730 set up as a user in the SamplePortal database.

<addkey="ConnectionString"value="server=testsql01\testsql01_2k;database=SamplePortal;uid=lsux730;pwd=xxxxxx"/>

<addkey="OnlineTimeout"value="300"/>

<addkey="CuteChat.SqlClient.ConnectionString"value="server=testsql01\testsql01_2k;database=sampleportal;uid=lsux730;pwd=xxxxx;connection reset=false;;Application Name=ChatWeb"/>

Thanks.

05-25-2005, 3:27 PM 7001 in reply to 7000

Carolyn
Joined on 05-20-2005
Posts 32

Re: SQLDatabase Problem

Reply Quote

By the way the error is on line 105 of /Web/Default.aspx.cs

Thanks.

05-25-2005, 3:58 PM 7002 in reply to 7001

Carolyn
Joined on 05-20-2005
Posts 32

Re: SQLDatabase Problem

Reply Quote

It looks like the script code in Default.aspx is trying to execute the following:

private Chat_Lobby[] GetAllCuteChatLobbies()
{
return ChatWebUtility.Api.GetLobbies();
}

I'm not sure where to look for the GetLobbies() routine to see why my sql application login won't work.

05-25-2005, 4:18 PM 7003 in reply to 7002

Carolyn
Joined on 05-20-2005
Posts 32

Re: SQLDatabase Problem

Reply Quote

Here's the whole error messge page if it will help:

Login failed for user 'lsux730'.

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

Source Error:

Line 110:		private Chat_Lobby[] GetAllCuteChatLobbies()
Line 111:		{
Line 112:			return ChatWebUtility.Api.GetLobbies();
Line 113:		}
Line 114:

Source File: D:\Inetpub\Wwwroot\hcsd\mclno\SamplePortal\Web\default.aspx Line: 112

Stack Trace:

[SqlException: Login failed for user 'lsux730'.]
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
   System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
   System.Data.SqlClient.SqlConnection.Open() +384
   CuteSoft.Chat.CDQ.Providers.DBQueryProvider.Open() +16
   CuteSoft.Chat.CDQ.QueryConnection.Open() +57
   n.a(UserIdentity A_0) +605
   CuteSoft.Chat.Impl.ServiceLayerChatApiDecorator.BeforeInvoke() +416
   CuteSoft.Chat.DynamicAssembly.ServiceLayerChatApiDecoratorProxy.GetConfig_InterceptedCall(String configname) +78
   CuteSoft.Chat.DynamicAssembly.WebLayerChatApiDecoratorProxy.GetConfig_InterceptedCall(String configname) +78
   CuteSoft.Chat.ChatWebUtility.GetUserAdapter() +71
   CuteSoft.Chat.ChatWebUtility.get_CurrentIdentity() +61
   CuteSoft.Chat.Impl.WebLayerChatApiDecorator.BeforeInvoke() +185
   CuteSoft.Chat.DynamicAssembly.WebLayerChatApiDecoratorProxy.GetLobbies_InterceptedCall() +77
   ASP.Default_aspx.GetAllCuteChatLobbies() in D:\Inetpub\Wwwroot\hcsd\mclno\SamplePortal\Web\default.aspx:112
   ASP.Default_aspx.Page_Load(Object sender, EventArgs e) in D:\Inetpub\Wwwroot\hcsd\mclno\SamplePortal\Web\default.aspx:105
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750

05-25-2005, 6:17 PM 7015 in reply to 7003

Carolyn
Joined on 05-20-2005
Posts 32

Re: SQLDatabase Problem

Reply Quote

If it helps, the Chat_Lobby database table is empty...

05-26-2005, 10:41 AM 7039 in reply to 7015

Adam
Joined on 09-23-2003
Aurora, ON
Posts 18,678

Re: SQLDatabase Problem

Reply Quote

Carolyn,

For some reasons, the connection string you are using is not accepted by database.

Please contact your DBA.

asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
asp wysiwyg html editor: http://cutesoft.net/ASP
asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
Live Support: http://cutesoft.net/live-support/default.aspx