(2000) Unable to connect to debugger

On my development maching, I have three different SQL Server instances:

..\SQL2000
..\SQL2005EXPRESS
..\SQL2005

When i try to debug a stored procedure in Query Analyzer, I get the
following error:

"Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger
on MYPC\SQL2000 (Error = 0x800401f3). Ensure that client-side components,
such as SQLLE.DLL, are installed and registered on MYPC. Ddebugging disable
for connection 53."

Client side components _are_ installed. What gives? Any ideas?

J. Jespersen
DenmarkJeppe Jespersen (jdj krlledims jdj punktum dk) writes:

Quote:

Originally Posted by

On my development maching, I have three different SQL Server instances:
>
.\SQL2000
.\SQL2005EXPRESS
.\SQL2005
>
When i try to debug a stored procedure in Query Analyzer, I get the
following error:
>
"Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to
debugger on MYPC\SQL2000 (Error = 0x800401f3). Ensure that client-side
components, such as SQLLE.DLL, are installed and registered on MYPC.
Ddebugging disable for connection 53."
>
Client side components _are_ installed. What gives? Any ideas?

Which service pack of SQL 2000 are you running, and which OS do you
have?

If you are running Windows XP SP2, you should upgrade to SP4 of SQL 2000.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql

(2000) Unable to connect to debugger

On my development maching, I have three different SQL Server instances:
.\SQL2000
.\SQL2005EXPRESS
.\SQL2005
When i try to debug a stored procedure in Query Analyzer, I get the
following error:
"Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect
to debugger
on MYPC\SQL2000 (Error = 0x800401f3). Ensure that client-side components,
such as SQLLE.DLL, are installed and registered on MYPC. Ddebugging disable
for connection 53."
Client side components _are_ installed. What gives? Any ideas?
J. Jespersen
DenmarkThe files might be corrupted or you don't have permission for the program. T
o
check the permission check the sp_sdidebug.
"Jeppe Jespersen" wrote:

> On my development maching, I have three different SQL Server instances:
> ..\SQL2000
> ..\SQL2005EXPRESS
> ..\SQL2005
> When i try to debug a stored procedure in Query Analyzer, I get the
> following error:
> "Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to conne
ct to debugger
> on MYPC\SQL2000 (Error = 0x800401f3). Ensure that client-side components,
> such as SQLLE.DLL, are installed and registered on MYPC. Ddebugging disabl
e
> for connection 53."
> Client side components _are_ installed. What gives? Any ideas?
> J. Jespersen
> Denmark
>
>
>

#&^%@#$ Report services...... OMG how do you set a report parameter in code....

Here's the error message..

Unable to cast object of type 'Microsoft.Reporting.WinForms.ReportParameter' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WinForms.ReportParameter]'.

Here is the code

Dim rp = New Microsoft.Reporting.WinForms.ReportParameter

Me.RV1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote

Me.RV1.ServerReport.ReportServerUrl = New Uri("http://10.1.1.138/ReportServer/")

Me.RV1.ServerReport.ReportPath = "/test/rEmailInvoice"

rp.Name = "InvoiceNumber"

rp.Values.Add("0618050")

Me.RV1.ServerReport.SetParameters(rp) < get error message here.

Me.RV1.ShowParameterPrompts = False

Me.RV1.RefreshReport()

is it that hard to set a query parameter in code? I have looked through this newsgroup, looked through MSDN, read people's blogs and still can't find the answer. Why couldn't MS create a sample that uses reportparameters?

Has anyone done this in code. Will the world end tomorrow?

Help!?!

D

Hi Maniac,

ServerReport.SetParameters method is expecting a ReportParameters collection not a single ReportParameter

here is a sample:

ReportParameter[] reportParams = new [1];

reportParams[0] = new Microsoft.Reporting.WebForms.ReportParameter("InvoiceNumber", "0618050");

RV1.ServerReport.SetParameters(reportParams);

That's it!

|||

I tried your code..

Dim reportparams() As ReportParameter = New (1) <-- on the open paren I get a "Type expected" error

reportparams(0) = New Microsoft.Reporting.WinForms.ReportParameter("invoicenumber", "0618050")

Me.RV1.ServerReport.SetParameters(reportparams)

What am I missing?

|||

I'm not sure of the syntax in VB but I think the syntax to declare an array of 1 element is a bit different isn'it ?

something like Dim reportParams() As new ReportParameter(1) ?

Don't know exactly how to declare an array in VB but it should be something like that

|||

THANKS! for your help. I got it working..

Here's the code for anyone else who might have the this problem.

Dim reportparams(0) As ReportParameter

Me.RV1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote

Me.RV1.ServerReport.ReportServerUrl = New Uri("http://blah.blah.blah.blah/ReportServer/")

Me.RV1.ServerReport.ReportPath = "/test/remailinvoice"

reportparams(0) = New Microsoft.Reporting.WinForms.ReportParameter("InvoiceNumber", _Invoice)

'note: _Invoice is a public property

Me.RV1.ServerReport.SetParameters(reportparams)

Me.RV1.ShowParameterPrompts = False

Me.RV1.RefreshReport()

and it works!

Thanks for your help.