Click here to Skip to main content
14,265,797 members
Rate this:
Please Sign up or sign in to vote.
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 4 days ago
Comments
Maciej Los 4 days ago
   
What method do you use?

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

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[^]
   

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100