BethanyW
4Penny.net
Points: 7400

11/15/2012 2:40:46 PM

The data type or table column '[eConnect_Out].[DBNAME]' does not exist or you do not have permission.

When doing a GP9 to GP 2010 upgrade, I got this error:

Msg 15148, Level 16, State 1, Procedure sp_bindefault, Line 230
The data type or table column '[eConnect_Out].[DBNAME]' does not exist or you do not have permission.

The 'more' window gave me this

 

The following SQL statement produced an error:
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[DOCTYPE]'
EXEC sp_bindefault N'[dbo].[TA_DATE]', N'[eConnect_Out].[DATE1]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[TABLENAME]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[DEX_ROW_ID]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX1]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX2]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX3]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX4]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX5]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX6]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX7]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX8]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX9]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX10]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX11]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX12]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX13]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX14]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX15]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[ACTION]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[REPLICATE]'
EXEC sp_bindefault N'[dbo].[TA_DBNAME]', N'[eConnect_Out].[DBNAME]'

GRANT REFERENCES , SELECT , INSERT , DELETE , UPDATE ON dbo.eConnect_Out TO DYNGRP

 

 

4Penny.net
Version: GP 2010
Section: Dynamics GP,eConnect
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3