Login problem

hi list!

when i login to Jde in client its gives this error in log file and i am unable to login.

1088/936 Tue Mar 11 10:07:50 2003 ODBC_U1.C930
ODB0000171 - SQLNumResultsCols failed in Table F986101
Column OMENHV
Database System - B7333

1088/936 Tue Mar 11 10:07:50 2003 ODBC_U1.C933
SQLNumResultsCols failed, See Log

1088/936 Tue Mar 11 10:07:50 2003 ODBC_U1.C934
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'F986101'. - SQLSTATE: S0002

I am using sql sever as database ,SP20

Can any one give me the registry deatils of SQL it will be help for me

thanx in advance whose going taking care for this issue...

Hi There

I was having this issue as well, mine turned out that the ODBC was pointing at the wrong default database. Check this out. Also run porttest and see if successful. You also will need to check that the jde superuser can access the database, login to SQL query analyser using thw jde superuser account and see if you can run statement to look in tables especially trhe one mentioned.


Regards