Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : RE : Product : Troubleshooting

Syntax error (missing operator) in query expression a.rsm_menu_id

Syntax error (missing operator) in query expression 'a.rsm_menu_id

while opening the client machine Following message are coming :

Syntax error (missing operator) in query expression 'a.rsm_menu_id = b.rem_menu_id and
rsm_screen_enabled=1 and rem_emp_id = and rem_profile= '' and REM_COMP_ID=1'.
&
see the RE-6 log check message
ErrMessage : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Problem is in SQL-2005 SQL server pipe line is not shared :
see the following steps how to share the sql pipe line,

Step : 1 Start --> Go to >>Run<< type >>cliconfg<< and press the enter key.
Step : 2 In General tab select the Named Pipes & TCP/IP then press Enable >> button both
Named Pipes & TCP/IP will be shown in Enabled Protocols by order.
Step : 3 Tick mark the Enable shared memory protocol. in left bottom of the screen.
Step : 4 In Alias Tab click the Add button >>Add Network Library Configuration<< window will pop up
In server alias box add your server system name with instance name
ex : SERVER/GFT and click ok button.

Following issue will be resolved.

See the logchk Error msg :
-----
ErrNo : -2147467259
ErrMessage : [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
ErrEvent : ConnectToAccounts
-----
ErrNo : -2147217900
ErrMessage : Syntax error (missing operator) in query expression 'a.rsm_menu_id = b.rem_menu_id
and rsm_screen_enabled=1 and rem_emp_id = and rem_profile= '' and REM_COMP_ID=1'.
ErrForm : ErrEvent : UnderAddMenufunction
-----
border="0">

Regards
Sivaraaj G

Related Articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB