ITCN ASP.NET Discussion Forum

Forum Topics > Installation Support > Problem with Database connection... > Post a Reply to this Thread

Problem with Database connection...

Share/Bookmark: Add this Thread to Digg Digg   Add this Thread to StumbleUpon Stumble Upon   Add this Thread to Del.icio.us Del.icio.us   Add this Thread to Reddit Reddit   Add this Thread to Facebook Facebook
RE: Problem with Database connection...
by bwise on Mon, Apr 14 2008 9:10 PM
Last Edit: Mon, Apr 14 2008 9:12 PM
In the current version you can't translate the search result text unless you have the Developer version, we are working on moving them into a configurable file for the next version. You can change the "subscribe" text in the threadView.aspx file, though.


If you are subscribed to a thread it means you will receive an email everytime someone replies to that thread.
ITCN Web Design and Marketing is a web design and application programming firm located in Morristown, New Jersey.
bwise
bwise
Joined: Sat, Sep 18 2004
Location: Morristown, NJ
Posts: 326
RE: Problem with Database connection...
by jasonsky on Mon, Apr 14 2008 8:38 PM
Yes. It fix again!! 2 questions now.....

Question1:
I would like to change the following wording into Chinese, is it possible?
In search.aspx, : "sorry, but your query..... returned no result"
In ThreadView.aspx: "Edit Your Post" button and "Subscribe to this thread".

Question2:
What is the meaning of "Subscribe to this thread" or "Unsubscribe to this thread" ?

Thanks.

bwise Wrote:
jasonsky Wrote:It fixed. However, after I create 3 different 'Topic'; I can't access the index page of each topic, e.g. topic2.aspx. it has the following message: The resource cannot be found. In fact, I can't find those pages of topic1.aspx, topic2.aspx... why?


That is due to the global.asax file and the url-rewriting. Make sure the global.asax file is in the root of your website.
Hello World.
jasonsky
jasonsky
Joined: Mon, Mar 17 2008
Posts: 16
RE: Problem with Database connection...
by bwise on Sun, Apr 13 2008 10:39 PM
jasonsky Wrote:It fixed. However, after I create 3 different 'Topic'; I can't access the index page of each topic, e.g. topic2.aspx. it has the following message: The resource cannot be found. In fact, I can't find those pages of topic1.aspx, topic2.aspx... why?


That is due to the global.asax file and the url-rewriting. Make sure the global.asax file is in the root of your website.
ITCN Web Design and Marketing is a web design and application programming firm located in Morristown, New Jersey.
bwise
bwise
Joined: Sat, Sep 18 2004
Location: Morristown, NJ
Posts: 326
RE: Problem with Database connection...
by jasonsky on Sun, Apr 13 2008 9:49 PM
It fixed. However, after I create 3 different 'Topic'; I can't access the index page of each topic, e.g. topic2.aspx. it has the following message: The resource cannot be found. In fact, I can't find those pages of topic1.aspx, topic2.aspx... why?


bwise Wrote:We don't use master pages because they currently don't support full headers, which will hurt your website in search engine rankings. But if you want to use them you can, just make sure you include the link to the codebehind files. It's the first line in each aspx file, which looks something like this:
<%@ Page language="VB" Inherits="dotForumClientUsers.viewAllUsers" %>
Hello World.
jasonsky
jasonsky
Joined: Mon, Mar 17 2008
Posts: 16
RE: Problem with Database connection...
by bwise on Sun, Apr 13 2008 11:00 AM
Last Edit: Sun, Apr 13 2008 11:01 AM
We don't use master pages because they currently don't support full headers, which will hurt your website in search engine rankings. But if you want to use them you can, just make sure you include the link to the codebehind files. It's the first line in each aspx file, which looks something like this:
<%@ Page language="VB" Inherits="dotForumClientUsers.viewAllUsers" %>
ITCN Web Design and Marketing is a web design and application programming firm located in Morristown, New Jersey.
bwise
bwise
Joined: Sat, Sep 18 2004
Location: Morristown, NJ
Posts: 326
RE: Problem with Database connection...
by jasonsky on Sun, Apr 13 2008 9:51 AM
Yes! It works!!! Thanks so much!!!

Another question:
My web application is used MasterPage at each page. I then delete the header: clientHeader.inc.asp and footer: clientFooter.inc.asp included in each page. But such action affect data display, e.g. userlist.aspx display only the layout without data.

Anything I got wrong?

bwise Wrote:Jason;
Change the data type in the database. In the database table forumCategories, change ctTitle from varchar to nvarchar, and change ctDesc from text to ntext. This will allow unicode characters in the database table.
Hello World.
jasonsky
jasonsky
Joined: Mon, Mar 17 2008
Posts: 16
RE: Problem with Database connection...
by bwise on Sun, Apr 13 2008 8:28 AM
Jason;
Change the data type in the database. In the database table forumCategories, change ctTitle from varchar to nvarchar, and change ctDesc from text to ntext. This will allow unicode characters in the database table.
ITCN Web Design and Marketing is a web design and application programming firm located in Morristown, New Jersey.
bwise
bwise
Joined: Sat, Sep 18 2004
Location: Morristown, NJ
Posts: 326
RE: Problem with Database connection...
by jasonsky on Sun, Apr 13 2008 1:18 AM
Last Edit: Sun, Apr 13 2008 4:45 AM
The DB connection has been solved. Thanks.

I am now testing the Forum. Because it run in Chinese, so Chinese character display is very important part. I have changed the config of web.config as follows, it works in almost all of pages, except of categoryAdd.aspx and categoryEdit.aspx. I can't input/ edit data as Chinese character. Could you suggest solution?

<globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="en-US" uiCulture="en-US" />

bwise Wrote:Jason;
That will not work. Please use the connection string example in the web.config file that comes with the forum, more like this:
Provider=sqloledb;Data Source=localhost;Initial Catalog=itcnForum;User Id=USERNAME;Password=PASSWORD
Hello World.
jasonsky
jasonsky
Joined: Mon, Mar 17 2008
Posts: 16
RE: Problem with Database connection...
by bwise on Sat, Apr 12 2008 3:24 PM
Last Edit: Sat, Apr 12 2008 3:25 PM
Jason;
That will not work. Please use the connection string example in the web.config file that comes with the forum, more like this:
Provider=sqloledb;Data Source=localhost;Initial Catalog=itcnForum;User Id=USERNAME;Password=PASSWORD
ITCN Web Design and Marketing is a web design and application programming firm located in Morristown, New Jersey.
bwise
bwise
Joined: Sat, Sep 18 2004
Location: Morristown, NJ
Posts: 326
Problem with Database connection...
by jasonsky on Sat, Apr 12 2008 9:45 AM
I have just bought this Forum. I follow the installation instruction from you, but I face problem in setting up my Database. My current web application contains its Database connection string:

<add name="EcarConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\EcarDB.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

I try to use the same way to config ITCNForum, but I obtain the following error: System.InvalidOperationException: The 'System.Data.SqlClient' provider is not registered on the local machine

Could you give me suggestion on this case? THanks .

Jason
Hello World.
jasonsky
jasonsky
Joined: Mon, Mar 17 2008
Posts: 16