I'm using Crystal reports 7, and SQL Server 7...and its giving me some
headache. My report is designed on a different machine than the production
machine...after design, I need to move the report to the production machine,
and change the SQL Server name, but Crystal gives so much trouble in doing
this simple task. The problem is that when you click on the "Database"
menu, CR tries to access the SQL server as currently defined, and if its not
available, it takes a long while and when it gets back, it prompts for a
server name. Normally, I would do "Set Location", and "Log on Server", and
then point my tables to the new connection, but when I use OLE DB and the
currently set server in the report is not on the network, then I have
troubles. I'm able to solve this problem by using pdssql.dll in "Convert
Driver", instead of pdsoledb.dll but my VB6 client program fails when I do
so...saying "pdssql.dll" is not registered or something like that, and I
can't find this file on my system!
Any help/ideas would be so appreciated.