Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL error after upgrade from 6.0 to 7.5

Status
Not open for further replies.

leksdn

Programmer
Jan 13, 2004
1
RU
Hi guys
I have the problem with customer search in GP 7.5
I installed GP 7.5 and configure it to use GP 6.0 databases. Then i run GP Utilities and updated the databases without any errors.
But when i try to search customer (Customer Maintenance->Customer and prospects->Search Customer form) i get the "[ODBC SQL Server Driver][SQl Server]: Insert erorr: column name or number of supplied value does not match table definition"
I analized odbc tracing log file and was suprised that GP creates temprorary table and then inserts incorrect data structure into the table.
Could anybody help ?
Thank you.
 
Have you run a check links on your Sales tables?

Thanks!
Barb E.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top