how to add support for russian language to Full Text search?

Hi all.
I'm using MS SQL Server 2K SP3. I need to implement full text search in
Russian.
Now if I execute smth like:
Select id_article From Articles Where FreeText (*, N' some words in
russian ')
I get an error:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query
contained only ignored words.
though with english words it works OK.
Buy the way, russian is not present in master..syslanguages.
thanks,
vlad.
I've just changed 'default full-text language' parameter to 'neutral' and
still have the same problem...
vlad.
|||Hi!
Did you manage to solve the problem?
I also have the same problem - only my words are in croatian :-)
"vlad" <vlad@.august-n.com.ua> wrote in message
news:dn1ma5$1l05$1@.pandora.alkar.net...
> I've just changed 'default full-text language' parameter to 'neutral' and
> still have the same problem...
> vlad.
>

How to add reference in C# SQL Server Project (June CTP)

Hi,

I'm using June CTP Visual studio .NET Framework. I have created SQL Server Project in C# language. In that i want to add external dll's to that Project. But when i click the Add reference in the References, it shows only two Tabs 1. Projects 2. SQL Server.

I cant able to add external dll's located in some other location to my References. How to do this? Please let me know if anybody know the solution.

Thanks,
Vinoth
Vinoth@.gsdindia.com

SQL Server projects in Visual Studio 2005 allow you to add references to other SQL Server projects and assemblies registered in the database you are connected to. Apart from these you cannot add references to assemblies on disk.
If you need to use an assembly, register it inside SQL Server using CREATE ASSEMBLY statement from SQL Server Management Studio (refer SQL Server Books Online for more help) and then you would see this assembly in the SQL Server tab.
A question: What are the external dll's you want to use? Are they developed by you or are they coming from somewhere else?

Thanks,
-Vineet.|||

Thanks for ur reply,

A question: What are the external dll's you want to use? Are they developed by you or are they coming from somewhere else?

Yes Vineet,

The external dll's are developed by me.It's not related to SQL server Project. Can i register the external dll's(eventhough its not related to SQL Server Project) using CREATE ASSEMBLY statement from SQL Server Management Studio and can i use it?

Thanks,
Vinoth

How to access to database with c# using DSN

Hello, im new in c# language.

Can someone show me, step by step(with simples code) how can i connect to a DSN connection that aconfigure in my odbc connection in my machine, to connect to mydatabase ?

I need only a simple class that use a DSN connection to retreive information from the database.

Best regards

You don't want to use a System DSN. A System DSN uses ODBC which is a wrapper for OLE DB, meaning that you're talking about a lot of unnecessary overhead. The .Net System.Data.SqlClient classes talk directly to the SQL Server, without having to use OLE DB OR ODBC. Instead, you need to figure out how to build your Connection correctly.

TryConnectionStrings.com.

|||

Im not use SQL server, my database is db2 in AS/400.

Do u know how to connect directly to an as/400 database ?

|||

Hi,

From you description, it seems that you want to connect to your DB2 database by using DSN, right?

I suggest that you can try DB2OdbcFileConnectionString class which describes a DB2 ODBC file connection string.

To create a DSN file and associated connection string

Call the constructor for DB2OdbcFileConnectionString, DB2OdbcSysConnectionString, or DB2OdbcUserConnectionString.
Calling the constructor creates a connection string with default settings. These default settings can be set only through the Data Access Tool user interface.

If you use a file path for a file that currently exists, the system loads the connection string information in that file instead.

Fill in the relevant connection string properties with a call to the properties of the object created.
You can also fill in the connection string with GetString, which returns the connection string as a text string. Once you finish modifying the relevant values, you can return the connection string to the object with a call to SetString.

Save the connection string information back into storage with a call to Save.

For more information, see:
http://msdn2.microsoft.com/en-us/library/ms945575.aspx

Thanks.