Changing the Language Noise Words

Hi,
I have searched high and low for an answer to this question. Please
tell me that it is a simple process...!
I have created a website in English using SQL 2000 as the database.
Now I have just launched the same website in French using exactly the
same schema (and same server) as the english website. Both use
full-text search. BUT...I notice that the noise word file being used
for both is English so, naturally, I need to change my French language
site to French. How can I do this?
I have already tried changing the database and field collation in the
French database and re-creating and re-populating the full-text index
but the English noise word file is still being used. Please, somebody
help!!
Darren,
You can switch to another language via dropping the existing FT Catalog and
re-creating it via the FT Indexing Wizard and when you pick the column (Text)
to be FT Indexed, click on the drop down box marked "Language for Word
Breaker" and select your language and then run a full population.
(Thanks to John for telling that trick!-)
Regards, Gerald.
"Darren Jensen" wrote:

> Hi,
> I have searched high and low for an answer to this question. Please
> tell me that it is a simple process...!
> I have created a website in English using SQL 2000 as the database.
> Now I have just launched the same website in French using exactly the
> same schema (and same server) as the english website. Both use
> full-text search. BUT...I notice that the noise word file being used
> for both is English so, naturally, I need to change my French language
> site to French. How can I do this?
> I have already tried changing the database and field collation in the
> French database and re-creating and re-populating the full-text index
> but the English noise word file is still being used. Please, somebody
> help!!
>
|||Darren,
Garald is correct. Just some additional info for future reference... You can
find out which noise.* is linked to what language via the Schema.txt file
under \FTDATA\SQLServer\Config, for example for noise.FRA is the noise word
file for French:
<stoplist
language="French_French"
file="noise.fra"
primarylanguage=12
sublanguage=1>
Regards,
John
"Gerald Baeck" <GeraldBaeck@.discussions.microsoft.com> wrote in message
news:209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com...
> Darren,
> You can switch to another language via dropping the existing FT Catalog
and
> re-creating it via the FT Indexing Wizard and when you pick the column
(Text)[vbcol=seagreen]
> to be FT Indexed, click on the drop down box marked "Language for Word
> Breaker" and select your language and then run a full population.
> (Thanks to John for telling that trick!-)
> Regards, Gerald.
> "Darren Jensen" wrote:
|||Thanks, that worked a treat and very easy to do too!
Gerald Baeck <GeraldBaeck@.discussions.microsoft.com> wrote in message news:<209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com>...
> Darren,
> You can switch to another language via dropping the existing FT Catalog and
> re-creating it via the FT Indexing Wizard and when you pick the column (Text)
> to be FT Indexed, click on the drop down box marked "Language for Word
> Breaker" and select your language and then run a full population.
> (Thanks to John for telling that trick!-)
> Regards, Gerald.
|||I have one follow up question on the subject of fulltext indexing with
French and that is how can I get the search to ignore accents? For
example if I search 'hopital' I would like the results to show all
places where it finds 'hpital' or 'hopital'. Is this possible?
Thanks.
jensendarren@.hotmail.com (Darren Jensen) wrote in message news:<c2c1a066.0411171919.75ce4862@.posting.google. com>...[vbcol=seagreen]
> Thanks, that worked a treat and very easy to do too!
> Gerald Baeck <GeraldBaeck@.discussions.microsoft.com> wrote in message news:<209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com>...
|||Darren,
Unfortunately, the issue of accent sensitivity vs. accent insensitivity FTS
is more difficult to answer. This is a well known bug that has been around
for a long time (since SQL Server 7.0) and is truly only going to be fixed
in SQL Server 2005 <sigh>. As there are only workarounds for this bug in SQL
Server 2000 that require the use of duplicate data where you store the
non-accented search words, such as 'hopital'. You would then FT Index and FT
Search this column, while returning the accented search data (such as
'hpital') from another column back to the user. You will need to develop
accent removal procedures as well as use triggers (insert & update) to
maintain the currency of the two columns...
Regards,
John
"Darren Jensen" <jensendarren@.hotmail.com> wrote in message
news:c2c1a066.0411222026.3278d8fe@.posting.google.c om...
> I have one follow up question on the subject of fulltext indexing with
> French and that is how can I get the search to ignore accents? For
> example if I search 'hopital' I would like the results to show all
> places where it finds 'hpital' or 'hopital'. Is this possible?
> Thanks.
> jensendarren@.hotmail.com (Darren Jensen) wrote in message
news:<c2c1a066.0411171919.75ce4862@.posting.google. com>...[vbcol=seagreen]
news:<209E46D0-5BEE-4531-8145-A9B8DEDFCF50@.microsoft.com>...[vbcol=seagreen]
Catalog and[vbcol=seagreen]
(Text)[vbcol=seagreen]
|||Darren,
my workaround for this problem is to replace all special chars before
filling the index. I know it could take a while, but till Yukon is released
its the only way i think.
UPDATE [table] SET [field] = REPLACE([field], '', 'o')
Regards, Gerald.
"Darren Jensen" <jensendarren@.hotmail.com> schrieb im Newsbeitrag
news:c2c1a066.0411222026.3278d8fe@.posting.google.c om...[vbcol=seagreen]
>I have one follow up question on the subject of fulltext indexing with
> French and that is how can I get the search to ignore accents? For
> example if I search 'hopital' I would like the results to show all
> places where it finds 'hpital' or 'hopital'. Is this possible?
> Thanks.
> jensendarren@.hotmail.com (Darren Jensen) wrote in message
> news:<c2c1a066.0411171919.75ce4862@.posting.google. com>...

Changing Reporting Website Language

Hi

We use English Server Operating Systems and Applications and German Client Software.
When we use our for German language configured Internet Explorers the Reporting Website is displayed in somewhat horrible translations.

How are we supposed to get the English website without changing the language settings at each IE we use?

You can remove the de driectory in the Report Manager\bin directory. This will disable the German translation. Just tried it myself and it works.

|||Thanks, it worked :).

Changing my database path in web.config

Hey guys,

I uploaded my website from VWD Express to ipower. My database did not work, which I have learned upon some research should have not been a shock to me, but most definetely was. When I contacted tech support they told my that my web.config files were pointing to my local paths. That I should change them and I should be fine. Elsewhere, in the knowledge base I found the strConnect that I am under the impression I need to use.

strConnect = "Provider=SQLOLEDB; Server=SQL-A1; UID=account_username; PWD=account_password; Database=user_db_name"
oSQLServer.Connect strServer,strLogin,strPwd

The problem is, I'm a complete newbie, learning as I go and I can't find anything on where or how I insert this into my web.config to correct my paths. IPower will not help with coding. I know my current connection string is in web.config in the appsettings, that's about as far as my knowledge goes.

So, could anyone show me how I go about putting this into my web.config? Examples are very helpful :]

On a side note, I've been reading that this is a common problem among newbies like myself. So, is changing these files actually going to work, or am I wasting my time? Also, before I get knee-deep into it, is the database-publishing kit put out by MS the way to go here?

Thanks for any and all replies, you guys are always awesome.

your HOST company should have either emailed you or given you information about your database access and login information. you basically change the Server, Username, and password values in your connection string in web.config to match this.

heres a good article about connection strings in web.config .

http://weblogs.asp.net/owscott/archive/2005/08/26/Using-connection-strings-from-web.config-in-ASP.NET-v2.0.aspx

|||

Ok

I know my account id, password, and I think that I can replace. I looked at the article you gave me but, what I'm still confused about is this (what I do have and what the examples in the article look like):

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

doesn't look anything like this: (what IPower shows me I need to connect my sql database)

strConnect = "Provider=SQLOLEDB; Server=SQL-A1; UID=account_username; PWD=account_password; Database=user_db_name"

oSQLServer.Connect strServer,strLogin,strPwd

Is this strConnect not what I really need? I have no idea what I'm supposed to be doing

|||

the strConnect is the code you would use if it declare your connection in your code and NOT in the web.config file. So everytime you wanted to access the database you would put line of code. By placing the connection in the web.config if you change sqlservers you only need to change it in one location and not every time you make a call to the server. Here is what my web.config file looks like as far as a connection string (using your info above - not sure about the server name).

<connectionStrings>

<clear/>

<addname="MydbConnection"connectionString="Data Source=SQL-A1;Initial Catalog=user_db_name;User ID=account_username;Password=account_password;"providerName="System.Data.SqlClient"/>

</connectionStrings>

then add this code to your project to access the conenction.

Dim dbConnAs SqlConnection =New SqlConnection(ConnectionStrings("MydbConnection").ConnectionString)

then it would be like

dbconn.open()

|||

Thank you very much for trying to help.

strConnect is out the window.

I added the connection string in the web.config

grbourque:

then add this code to your project to access the conenction.

Dim dbConnAs SqlConnection =New SqlConnection(ConnectionStrings("MydbConnection").ConnectionString)

Where? I tried to put that in web.config as well and it didn't want to go there. I tried to put it in the code behind and that didn't work.

I'm sorry I sound like an idiot, I sure feel like one. I have more or less followed some type of tutorial to do everything I've done so far. I'm so frustrated right now that I can't get this to work I can't stand it.

I know your already being very specific and I should be able to pick it up from what you've already told me, but can you tell me where to put the other lines.

|||

Okay a couple things. When you placed the connection string in the web.config file did you keep the same name and only change the user info? If so then the name of that connection string will be MydbConnection. You can actually name it anything you want and have more than one connection if you like, just call up the connection you want by name. Second, I could be completely out to lunch but I do not like the server name they gave you. When I ping that name it comes back as not being able to find it. When I ping the hosted sql server that I am using it comes back with the IP address of that server. So that might be problem #1 and needs to be resolved prior to trying the rest.

Okay as far as the code goes. you would place that where you want to access the database.

private sub GetData()

Dim dbconn as sqlconnection = new sqlconnection(connectionstrings("MydbConnection").ConnectionString)
Dim dbReaderAs SqlDataReader
Dim dbQueryAs String ="SELECT * FROM Table"
Dim dbCommandAs New SqlCommand(dbQuery, dbConn)

dbConn.Open()
dbReader = dbCommand.ExecuteReader()

DO something here with reader

dbconn.close()

End Sub

|||

hi want to just use access db for smaple comments how to use server.mappath in web.config or in tire application classes thanks in advance