p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Changing the SQL Server name using pdsoldeb.dll


Message #1 by Bunmi <Bunmi@a...> on Mon, 30 Apr 2001 16:48:23 -0400
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.



Thanks.

'Bunmi.


  Return to Index