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

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

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.

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

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.

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

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.

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

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.

No, no hurry. I'll take all of the help I can get! Thank You! :)

www.fire-church.org