thanks ramesh, but the problem is that the servers are different and hence i might have to provide DSN (opendatabaseconnection()) thats where the problem kicks in.