Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Installation and Administration
  New Posts New Posts RSS Feed - Error on Great Plains!!!
  FAQ FAQ  Forum Search   Register Register  Login Login


Error on Great Plains!!!

 Post Reply Post Reply
Author
Message
-=J4cKa5s=- View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: June 05 2006
Location: Singapore
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote -=J4cKa5s=- Quote  Post ReplyReply Direct Link To This Post Topic: Error on Great Plains!!!
    Posted: June 05 2006 at 10:43pm
I faced some problem when i wan to enter my DB after the authentication successful.

The prompt out msg is
"a get/change first operation on table 'SY_ResourceActivity" (0). If i click 'More Info' butoon on the msg box... the following details showed.

[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'TTTTTTTTTTTTTT?'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'TTTTTTTTTTTTTT?'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'TTTTTTTTTTTTTT? ORDER BY RSRCID ASC ,RSRCSBID ASC ,RULEID ASC ,CMPANYID ASC ,USERID ASC '.

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'TTTTTTTTTTTTTT? ORDER BY RSRCID ASC ,RSRCSBID ASC ,RULEID ASC ,CMPANYID ASC ,USERID ASC '.

[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'TTTTTTTTTTTTTT? ORDER BY RSRCID ASC ,RSRCSBID ASC ,RULEID ASC ,CMPANYID ASC ,USERID ASC '.

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'TTTTTTTTTTTTTT? ORDER BY RSRCID ASC ,RSRCSBID ASC ,RULEID ASC ,CMPANYID ASC ,USERID ASC '.

The 'TTTTT.." are chinese character so i dunno how to get rid of it.. hope some1 can help

Back to Top
Sponsored Links


Back to Top
GPProff View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: July 02 2006
Location: Singapore
Status: Offline
Points: 26
Post Options Post Options   Thanks (0) Thanks(0)   Quote GPProff Quote  Post ReplyReply Direct Link To This Post Posted: July 02 2006 at 11:41pm

Hi Pals,

Please Check your SQL Server Collation Settings....

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com