connectiong to crystal report from vb

hi
i have used "Main.reports.Connect = "ODBC;Driver={SQL Server};UID=saadia;PWD=;DSQ=databasename;Data Source=servername"
but when i moved the reports to another server , reports does not redpond to new connection.it tries to find the previous server.
i have to give my application to a client but reports are not refreshing unless i manually open up the report and refresh it there ,but that means client should have crystal report installed. what shall i do.
another problem is that when i install my application it gives me error that "pdssql.dll not found" and i can't find this dll anywhere.
i am using crystal report 7
thanks
saadia

saadia

I can't help with the server issue, but I have found that the error messages from crystal can be misleading. I'd search seagate's site for the dll error message. I've had several occaisions where the dll that was missing was actually a different name than the one specified in the message.

thanx/good luck,
adam