Error 207 " Invalid column name suid" when application makes a ODBC Connnection to MSSQL2000
Posted on 2003-10-28
We have a VB Application, that, on some computers, when we try to make a connection to MSSQL2000, it comes up with Error 207: Invalid column name suid.
Now, I'm aware that the suid column is not being used in MSSQL2000 any more, so I'm thinking that when the app try to make the odbc connection, it pics up some old (Maybe SQL7 or SQL6.5) driver, that's looking for the suid.
I've UnInstalled and ReInstalled MDAC 2.7
I've UnInstalled and ReInstalled the MSSQL2000 ClientConnectivity, with SP3.
Where do I start troubleshooting this error?