Printable View
I created a report using RDC(report design component) with 'Microsoft OLE DB Provider for SQL Server' to a stored procedure.
Everything is fine on my computer. But after installed on another computer, when the program loads the report, following error happens:
CystalViewer Error:
Server has not be opened
Any suggestion? Thanks
May be on end Pc you do not have sql drivers, you do not have access to database, you do not have database you're looking for. However, this is only a guess.
Good luck
Special thanks to Lothar "the Great" Haensler. Come back soon, you Guru.
well, I am using SQL7 database and my vb program can access the database even on another computer. Only Reports cann't be loaded with that error.
When I create crystal report, I use OLEDB connection with either a user name and password or trust connection. But when I load Crystal report in VB code I just give parameters and assign crystal viewer's report source to that crystal report.
Any idea what could be problem?
Most likely I know why. You should config the DB network library in that PC too. So you can use DB alias to acess that DB as same as in your PC.
For example, in the registary, there should be a entry for the alias, under HKEy_local_machine\software\microsoft\mssqlserver\client\connectto
and the value is like
<ur db alais> Reg_SZ "DBMSSOCN,<ipadress>,1433"
That's all