Changing the server in the connection strings in infopath 2003

[Sher]

When I modify the infopath connection strings to use my test server instead
of the production server, I am not able to retrieve any data. I have cofimed
that the query is not even being run against my test server by viewing what
statements are run via sql profiler.

Does anyone know how I could successfully switch servers and retrieve data?

thanks,
sherazad.