eReq error

[Luvsql]

I moved our data to a new server on the weekend. I changed the ODBC on our webserver to point to the new server. All sql logins and data exist on the new server. Users can log into eReq. However, when they attempt to add an item on a new req:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition.

/DBUtilities.inc, line 15

If they click on Review Requistion, then click on a Req:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'DEX_ROW_ID', table 'DYNAMICS.dbo.ReqMUKeys'; column does not allow nulls. INSERT fails.

/DBUtilities.inc, line 15


It has not worked in 3 days and we are getting back logged on our purchasing. We are using GP 7.5 with eReq 7.03 (only version available). I have tried uninstalling and reinstalling ereq completely (even deleting site and recreating).

 

[jazgeek]

did you try nuking the old connectin and recreating a new ODBC connection or did you just try repointing the old one?



-----------
and they wonder why they call it Great Pains!

jaz

 

[Luvsql]

I've managed to get it working, but only up to a certain point. Now I have weird little errors for certain users.

 

[jazgeek]

might want to try reinstalling the latest mdac on the affected pc's

-----------
and they wonder why they call it Great Pains!

jaz