Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In the organisation we have an application that was developed using VB 6 and access 2003, the database is on SQL 2005 and is currently running on windows server 2008.
We migrated the application to another server which is running windows server 2012 and also on the Database is SQL server 2017.
The application is working on the new environment the only challenge we have is when we insert the new record on the database, am get this error “3155 ODBC – insert on a linked table ‘Table name’ failed.” Can you please help.

What I have tried:

I tiered to relink the tables from database to the application but it still give me the same problem.
Posted
Updated 13-Aug-19 1:18am
Comments
Maciej Los 13-Aug-19 6:47am    
What method do you use?

1 solution

I'd suggest to install proper Sql Native Client driver[^] then to relink tables. You probably use older version of Sql Native Client driver, which might be the cause of such of error.

In case when it won't help, please, follow the suggestion in my previous answer: On error resume next stopped working[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900