Might be the ODBC driver. One way to find out is to set up Excel or Access and write some quick VBA with ADO to test the functionality from a client PC and see if it can work when set up from scratch. If it does work, then look at the differences and see if the drivers for ODBC are the same or not.