Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmedbadak
Starting Member
2 Posts |
 Posted - 2010-07-16 : 04:22:14
|
| Hi,SSAS project has worked in the following conditions;We use two database : Mssql and AS/400 and used providers are IBM DB2 UDB for iSeries IBMDA400 OLE DB and SQL Server Native Client OLE DB Provider.Windows server 2003 standard edition (eng) and SQL server 2005 and EN (USA) run regional and language options irreproachable When the language turn into Turkish, those errors occur:"OLE DB error: OLE DB or ODBC error: SQL0104: ,1 is not valid. Valid tokens: , FROM INTO.Cause . . . . . : A syntax error was detected at ,1. ,1, is not valid token. A partial list of valid tokens are , FROM INTO. This list assumes that the statement is correct up to the token.The error may be earlier in the statement, but the syntax of the statement appears to be valid up to this point. Recovery . . . : Do one or more operation which are stated below and repeat them which are requested: -- Inspect the SQL statement in the area of the ,1 .. The error could be a missing comma or quotation mark, it could be a misspelled word, or it could be related to the order of clauses. -- If the error token is <END-OF-THE STATEMENT>, correct the SQL statement because it does not end with a valid clause.; 42601. "Error arises from the code which is created by the SSAS on itself so we could not step in it.When the project runs with TR regional option in a different test environment (Windows server 2003 standard edition (eng) and SQL server 2005 in standard edition), I have taken the same error message. However, when language option turns into EN(USA),the program works correctly.However,when we have tried it without change anything in the following day, the same error has occured.We tested the SSAS project following environment Windows server 2008 standard edition (Turkish), SQL server 2005 in standard edition and ENG(USA) in Regional and Language Options, it deos not work. In the following day it has worked. Usually works with in English mode.As a result SSAS can be seen unstable. Our main server language is Turkish.Any insight would be greatly appreciated. |
|
|
|
|
|
|
|
SSAS Deploy error