Sunday, February 12, 2012

Cannot connect to Database

HI,
I have a simple report which i am trying to execute. The ODBC datasource
returns success when the tested.
I get the following error when i try to run the report :
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does
not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()).
----
How do i go about debugging it.
regards
-sarabsarab wrote:
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
> does
> not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionOpen (Connect()).
On the machine with sql-server ->klick start -> run -> type
svrnetcn.exe ->enter
a window with sql-server-network-configuration appears->watch into right
window
there should be ("normally") two activated protocolls (named pipes and
tcp/ip)
If not activate the missing protocoll
Hope that helps
regards
Frank

No comments:

Post a Comment