SQl 2000 and ROWID Error

[karunya]

Hello all,

We are having an issue in one environment where we have SQL 2000. I am running a report and for some odd reason for one table(F0002), it is writing on Valid Oracle Statement. It is suppose to be looking at SQL 2000. Below is the log file statement. As far as I remember SQL 2000 doesnt have a ROWIF feature in it. I checked all the OCM mappings, they have JDBODBC.dll. It happens only for F0002 control table. The other control tables are getting the correct SQL statements. Is there something special with the next number table? It works fine in other environments though.

Thanks for your time
-K



------------------------------JDE log----------
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ROWID'. - SQLSTATE: S0022

1584/3096 Mon Apr 28 08:44:42 2008 JDB_DRVM.C986
JDB9900401 - Failed to execute db request

1584/3096 Mon Apr 28 08:44:42 2008 jdbodbc.C2793
ODB0000003 - Wrong commitment mode for DataSource Control Tables - CRP

1584/3096 Mon Apr 28 08:44:43 2008 jdbodbc.C2148
ODB0000183 - SQLExecute failed
--------------------------------------------------
-----------------JDE DEBUG LOG---------------------

ODBC version which the driver supports : 03.52
The DBMS product accessed by the driver : - Microsoft SQL Server
Apr 28 08:44:43 ** 1584/3096 ODBC:O DBInitConnection envr=01D01978 conn=01D083E8 cur=6 sep=. act=1 USCNDB28 A (user245@Control Tables - CRP)
Apr 28 08:44:43 ** 1584/3096 ODBC:O DBInitRequest(new) conn=01D083E8 hd=03D40A60 dr=03C6ABF8 USCNDB28 A (user245@Control Tables - CRP)
Apr 28 08:44:43 ** 1584/3096 SELECT CRPCTL.F0002.*, ROWID FROM CRPCTL.F0002 WHERE ( NNSY = '02' ) FOR UPDATE OF NNN001, NNN002, NNN003, NNN004, NNN005, NNN006, NNN007, NNN008, NNN009, NNN010

 

[karunya]

We figured it out. We had server map on one of your app servers pointing to Oracle. Thanks for taking your time to read through.

-K