I have VB app which is on a machine running SQL Server 7.0. This VB App is not able to make a connection to another server which is running SQL Server 2000. Can anyone please help me with this issue and guide me.
As stated, you can update the MDAC on your SQL 7.0 machine to MDAC 2.6 or you could create an alias for your SQL 2000 instance on your SQL 7.0 machine. For more information about aliases, refer to this KB article: http://support.microsoft.com/kb/265808/en-us