2

The connection is working because I can select the table but when updating getting following error message with Microsoft SQL Server 2012.

Msg 7399, Level 16, State 1, Line 4
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider reported an unexpected catastrophic failure.

Msg 7343, Level 16, State 4, Line 4
The OLE DB provider "MSDASQL" for linked server "(null)" could not UPDATE table "[MSDASQL]". Unknown provider error.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Manju Mehta
  • 21
  • 2
  • Can you execute the UPDATE statement through the Pervasive Control Center (or other tool outside of SQL Server)? Does it throw an error? If so, what error? – mirtheil Oct 27 '18 at 00:56
  • Yes, I can update through Pervasive Control Center and even with SQL 2008 and Microsoft Access. – Manju Mehta Oct 30 '18 at 13:48
  • So the error only happens with the linked server and SQL Server 2012? Is the SQL Server 2012 64 bit? If so, are you using the 64 bit Pervasive ODBC drivers? What version of Pervasive are you using? – mirtheil Oct 30 '18 at 14:50
  • Yes. I can use select command with out any problems but can't update In SQL 2012. We are using Pervasive 11 and 64 bit Pervasive ODBC driver. Thanks – Manju Mehta Oct 31 '18 at 15:40
  • 1
    @ManjuMehta Did you get some solution? I'm facing similar issue on SQL Server 2016 Enterprise Edition. – Rajesh Ranjan Jul 05 '19 at 07:09

1 Answers1

0

We had this issue running an INSERT INTO query from MSSQL/MSSMS to a linked MySQL server. The problem in our case was the MySQL instance required that some fields be provided, even if they were blank. We tested the INSERT INTO via PHPMyAdmin and it was failing on those fields. We added those fields to the INSERT statement with null values and it ran just fine.

If you are having this issue, check your MySQL instance as you may have a required value you are not passing.

Turk
  • 1