I receive a 7619 error message when I run a full text query that
contains certain Turkish character strings on an instance of SQL Server
2000 that is running on a Windows 2000-based computer. How can I solve
this problem?
The parser is interpreting these characters as noise or noise words. Which
word breaker are you using? I am assuming you are using the neutral word
breaker.
If this is the case the problem could be in your code page setting in the
web page. You should set the session.codepage to match the lcid for Turkish.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ismail H. AYDIN" <dicisay@.hotmail.com> wrote in message
news:1117203863.089340.322710@.g49g2000cwa.googlegr oups.com...
>I receive a 7619 error message when I run a full text query that
> contains certain Turkish character strings on an instance of SQL Server
> 2000 that is running on a Windows 2000-based computer. How can I solve
> this problem?
>
|||I am running the query from SQL Query Analyzer and then error occurs.
Not from asp.net or asp page. The noise word is 'Ak'. And the other
noise charactes are '', '', ''.
*** Sent via Developersdex http://www.codecomments.com ***
Showing posts with label server2000. Show all posts
Showing posts with label server2000. Show all posts
Sunday, March 11, 2012
Monday, February 13, 2012
400 Linked Server to SQL Server via IBMDA400
I am running V5R2 on client and am trying to link a 400 from SQL Server
2000.
Can this be done using IBMDA400?
I have gotten to a point with the IBM DB2 UDB that I can connect without
error. But now I can't see my tables.
This is what I am using for my provider string:
User ID=USERNAME;Password=PASSWORD;Initial Catalog=DATABASE_NAME;Data
Source=AS_400_SERVER_NAME
I have also checked the In Process checkbox that some have talked about
needing to be checked.
Any assistance is appreciated.
Thanks,
JasonHi,
I had the the same problem for a time, and I don't want to check all the NG
you have crossposted to, so I don't know if you already had an answer, but
here it is anyway :
Add "Catalog Library List=Lib1 Lib2 Lib3" in the connect string where "Lib1
Lib2 Lib3" is the list of your iseries library you want to browse the tables
and views. The list can be space separated or coma separated.
HTH
Christophe Niel
Remove 'nospam' to mail me.
"Jason Penner" <pennerjason@.hotmail.com> a crit dans le message de
news:%23SqrM%23A8DHA.2028@.TK2MSFTNGP10.phx.gbl...
> I am running V5R2 on client and am trying to link a 400 from SQL Server
> 2000.
> Can this be done using IBMDA400?
> I have gotten to a point with the IBM DB2 UDB that I can connect without
> error. But now I can't see my tables.
> This is what I am using for my provider string:
> User ID=USERNAME;Password=PASSWORD;Initial Catalog=DATABASE_NAME;Data
> Source=AS_400_SERVER_NAME
> I have also checked the In Process checkbox that some have talked about
> needing to be checked.
> Any assistance is appreciated.
> Thanks,
> Jason
>
2000.
Can this be done using IBMDA400?
I have gotten to a point with the IBM DB2 UDB that I can connect without
error. But now I can't see my tables.
This is what I am using for my provider string:
User ID=USERNAME;Password=PASSWORD;Initial Catalog=DATABASE_NAME;Data
Source=AS_400_SERVER_NAME
I have also checked the In Process checkbox that some have talked about
needing to be checked.
Any assistance is appreciated.
Thanks,
JasonHi,
I had the the same problem for a time, and I don't want to check all the NG
you have crossposted to, so I don't know if you already had an answer, but
here it is anyway :
Add "Catalog Library List=Lib1 Lib2 Lib3" in the connect string where "Lib1
Lib2 Lib3" is the list of your iseries library you want to browse the tables
and views. The list can be space separated or coma separated.
HTH
Christophe Niel
Remove 'nospam' to mail me.
"Jason Penner" <pennerjason@.hotmail.com> a crit dans le message de
news:%23SqrM%23A8DHA.2028@.TK2MSFTNGP10.phx.gbl...
> I am running V5R2 on client and am trying to link a 400 from SQL Server
> 2000.
> Can this be done using IBMDA400?
> I have gotten to a point with the IBM DB2 UDB that I can connect without
> error. But now I can't see my tables.
> This is what I am using for my provider string:
> User ID=USERNAME;Password=PASSWORD;Initial Catalog=DATABASE_NAME;Data
> Source=AS_400_SERVER_NAME
> I have also checked the In Process checkbox that some have talked about
> needing to be checked.
> Any assistance is appreciated.
> Thanks,
> Jason
>
Subscribe to:
Posts (Atom)