I'm using RDO to connect to SQL Server 6.5 from my VB5 application. When I make an update statement on one specific table I get the following message "Unable to bind foreign key constraint. Too many tables involved in query."
This specific table is references by 20 tables. If I do this update in Entreprise Manager it works fine. I guess that I encountered an ODBC limit, does somebody can confirm that? Does somebody knows where I can find the specification of SQL Server ODBC.
Thanks.