Hi,
When we are installing Dynamics GP on an employee computer we are getting the error:
The following SQL statement produced an error:
CREATE TABLE [dbo].[syCompanyImages]( [RELID] [int] NOT NULL [BinaryBlob] [varbinary](max) NOT NULL, CONSTRAINT [PK_syCompanyImages] PROMARY KEY NONCLUSTERED ( [RELID] ) ON [PRIMARY], ) ON [PRIMARY]
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]Line 1: Incorrect syntax near 'max'
*This post is locked for comments
It was an ODBC issue...Thank you!
You have been a great help!
Have you 'ever' had this client computer connected to GP - any version - any time?
If so, there may be some 'old' registry key hanging in the system for the old verison of GP.
If this is new workstation, I would consider looking at the ODBC connection. Of course logged in as Admin - make sure that the ODBC connection works first. IF not, solve that first and then re-install the GP Client
Hi,
We are using MS SQL 2012 and we already have employees connecting to it through the client version installed on their PC.
Is it something that we are doing wrong during the install that make the install think that we are trying to connect on another SQL server?
Thank you,
Sylvain
This is a compatibility error related to SQL server. If this is a client installation, you need to make sure that you are installing the exact same Dynamics GP version on the same SQL server.
Dynamics GP 2013 is compatible with SQL Server 2012 and 2008 R2 SP1 or later.
The case has been reported previously on the community, and it was due to incompatible SQL server, here is there link
This is a compatibility error related to SQL server. If this is a client installation, you need to make sure that you are installing the exact same Dynamics GP version on the same SQL server.
Dynamics GP 2013 is compatible with SQL Server 2012 and 2008 R2 SP1 or later.
The case has been reported previously on the community, and it was due to incompatible SQL server, here is there link https://community.dynamics.com/gp/f/32/t/118294.aspx
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (