changed. For ex, if you use "bmssa" user to connect to sql server, and
if owner of many tables in AXDB is "dmo", you can't select records. So
this message occurs. You should change the owners of tables.
Regards
Anil
_____
From: mchiat [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 5:22 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] SQL error when log into Axapta - Invalid
Object Name 'SQLSYSTEMVARIABLES'
Hi all,
Could anyone of you help me to resolve the problem? When i want to
log into axapta the following SQL error occurs
SQL has reported the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object
name `SQLSYSTEMVARIABLES'
You may refer to the error log file for further details.
Retry the operation?
If i click 'Yes' the same message box will keep on emerging. However
if i click 'No' the following message will appear:
Cannot select a record in ().
The SQL database has issued an error.
If i proceed the following message will appear:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name `SQLSYSTEMVARIABLES'. [SELECT VALUE FROM SQLSYSTEMVARIABLES
WHERE PARM = `SYSVARID']
If i continue the system will ask me to enter System Variables:
One or more SQL system variables are unknown.
System variable STR
Permitted values Text
New value
After i enter the New Value as VARCHAR(%u)the system will
automatically exit and if i want to log into Axapta again the same
SQL error will appear.
May i know what is happening? Is there anyway to resolve the
problem?
Hope you all can reply to me as soon as possible. Thank you in
advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/SIG=129t3vmva/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1085209839/A=2128215/R=0/SIG=10se96mf6/*http:/c
ompanion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=504037943>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
