|
Subject:
|
Chart Server dosen't send message
|
|
Posted By:
|
chenglong
|
Post Date:
|
7/31/2006 12:02:41 PM
|
Hi there
I'm new here. nice to meet everybody here.
I installed chat server on my 2003 server. I used setup to install chat server to my machine. everything seems work ok. but when I type in some message and click send. nothing i show up in upper message area and there are click sound keep coming out every second. is there any one so nice to tell me what hapen here?
Thanks
Tim
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/16/2007 4:30:21 PM
|
Hello,
I incorporated the chat server into my website and it's not showing the messages either. I'm using SQL Server 2000 and I was able to add all of the tables/prcoedures/views (with the exception of 1 column in the view that uses the CASE statement.. wasn't allowed). I checked the message table and it's saving my messages but not displaying them. Any ideas?
Thanks,
Doug
www.fire-church.org
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/16/2007 4:42:08 PM
|
Hi Doug,
Does it work for you on SQL Server 2005?
What did you do to fix the error in the view? I didn't write this chapter, but I assume the case statement is there for a reason...
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/16/2007 4:55:33 PM
|
Hi Imar,
Well, actually I'm not sure which version it is, I just assumed 2000. How can you tell? Also, yeah, I assume that statement was there for a reason too but wasn't sure how to fix it. Would you happen to know? :)
Thanks,
Doug
www.fire-church.org
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/16/2007 5:00:05 PM
|
It's important to find out the version of SQL Server first. How do you connect to it?
If you can access a Query Analyzer, try this:
SELECT @@VERSION
and then hit F5
Alternatively, try this:
sp_server_info
and hit F5.
In both cases, you should get info about the server.
Also, try running the site on SQL Server Express 2005. The database that comes with the downloads is a SQL 2005 database.
Hope this helps,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/16/2007 5:04:09 PM
|
ok, I will try that. One quick note though, is I'm incorporating this into my website that is already using SQL Server which is why I copied the tables, etc. and didn't try using the Server Express.
www.fire-church.org
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/16/2007 5:16:21 PM
|
I see.
There may be features in the database that are 2005 specific. Not sure, but it's worth looking out for that....
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/17/2007 9:29:38 AM
|
Ok, this is what I get with Select @@Version
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
So with that in mind is there anyway you can help me?!? :)
Thanks,
Doug
www.fire-church.org
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/17/2007 12:04:27 PM
|
I'll see if I can cook up a script for SQL Server 2000. That might take a while though so I hope you're not in a hurry...
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/17/2007 12:59:51 PM
|
No, no hurry. I'll take all of the help I can get! Thank You! :)
www.fire-church.org
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/17/2007 1:08:45 PM
|
Hey Imar,
I just noticed something... the timestamp field in the "message" table was empty. I updated the timestamp field with data (within 1 hour) and it's showing up now in the chat screen. So I guess the problem must be in saving the message with the timestamp in SQL Server.
Thought I'd let you know.
Doug
www.fire-church.org
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/17/2007 2:19:11 PM
|
That explains a lot. The timestamp column has GetDate() as the default value. So, whenever you add a record, the column is automatically filled with today's date (provided the insert / update statement doesn't provide a different value).
Other columns have defaults too, so be sure to check those out. To do this, locate your database in the Server Explorer / Database panel. Then right click the table and choose Open Table Definition.
Then for each column check out the "Default value or databinding" option in the Column Properties grid.
With the defaults setup, things should work. If not, let me know, and I'll look into it again and make a SQL 2000 script if necessary and possible.
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/18/2007 1:57:26 PM
|
Hi Imar,
Everything is working fine now with 1 exception. It's not grabbing all of the chat rooms from the table because of the "CASE" statment I mentioned that was in the "viewAllChatRoomsWithActiveNotation". If you could let me know how to translate that for SQL Server that would be great! :) SQL Server didn't allow case statements within the view.
Thanks for all of the help!
Doug
www.fire-church.org
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/19/2007 5:14:29 PM
|
I had no problem running the view in a SQL Server 2000 database.
Here's what I did you make it work:
1. Change the following columns from nvarchar(max) to something like nvarchar(50) or nvarchar(100), depending on the type of data the column is to store:
Room.Name
Room.Description
Category.Name
Category.Description
User.Email
2. Changed all remaining nvarchar(max) to ntext
3. Changed all occurences of
SELECT TOP (100) PERCENT
to
SELECT TOP 100 PERCENT
as SQL server 2000 doesn't seem to like the parentheses.
From there, the views could be created successfully...
Hope this helps,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
|
|
Reply By:
|
FollowTheSon
|
Reply Date:
|
1/24/2007 12:08:33 PM
|
Ok, I see my problem. It says my "Query Designer" does not support the case statement even though it is valid. Grrr... How can I create it outside of my query designer?
www.fire-church.org
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/24/2007 2:12:01 PM
|
Although it doesn't give you design time support, I think it still saves the query / view just fine.
Otherwise, use the Query Analyzer (choose Tools | Query Analyzer in Enterprise Manager) and execute your CREATE statement from there.
Hope this helps,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Inamorala by VAS (Track 2 from the album: Sevdance) What's This?
|
