I have written a VB6 application to work across a network, against a SQL Server database. The application has been installed on the same server as the database. Each PC has a shortcut on the desktop, which is linked to the exe file. The ODBC DSNs have all been created by an other VB app on all of the PCs. When called on some PCs it works without any problems. On others, forms with unbound combo boxs don't show any rows of data and forms with Datagrids are unable to display any data and the following message is shown 'Run-time '9': Subscript out of range'. Forms that should show one record are displayed with no data.
Has anyone come across this problem?