Cannot debug activated CLR Stored Procedure

Hi

I'm having a problem debugging (with VS2005,) a CLR Stored Procedure which is activated on a queue. I know it is working because it is consuming and processing messages when one appears in the queue.

I can debug it 'manually' by either right-clicking on the SP within VS2005 and selecting 'Step into Stored Procedure' or by attaching to the SQL Server Management Studio process, setting a breakpoint and executing the stored procedure from a Management Studio query window.

However, if I send a message to my queue within Management Studio, my breakpoints are NOT being hit within VS2005, but the message IS reaching my queue and it IS being processed by the SP.

Can anyone help?

Thanks

The only way to debug this is by attaching VS debugger directly to sqlservr.exe (i.e. the database engine) for managed debugging. You will need to install the Visual Studio Remote Debugger on the machine running the engine and you will need to add symbols to your assembly.

Hope that helps,

Rushi

Cannot debug activated CLR Stored Procedure

Hi

I'm having a problem debugging (with VS2005,) a CLR Stored Procedure which is activated on a queue. I know it is working because it is consuming and processing messages when one appears in the queue.

I can debug it 'manually' by either right-clicking on the SP within VS2005 and selecting 'Step into Stored Procedure' or by attaching to the SQL Server Management Studio process, setting a breakpoint and executing the stored procedure from a Management Studio query window.

However, if I send a message to my queue within Management Studio, my breakpoints are NOT being hit within VS2005, but the message IS reaching my queue and it IS being processed by the SP.

Can anyone help?

Thanks

The only way to debug this is by attaching VS debugger directly to sqlservr.exe (i.e. the database engine) for managed debugging. You will need to install the Visual Studio Remote Debugger on the machine running the engine and you will need to add symbols to your assembly.

Hope that helps,

Rushi

Cannot create Merge Replication in 2005

Hi to All,
I had sql 2005 with sp3 and i was working succesfully with merge
replication on Sql ce.
Yestarday i upgrade to sql 2005 (first upgrate my sql200 with sp4)
Now i am here in sql 2005 trying to create a new merge replication on
windows mobile 2005 and i get to the final step this error
------
TITLE: New Publication Wizard
New Publication Wizard encountered one or more errors while retrieving
publication names.
For help, click:
http://go.microsoft.com/fwlink?ProdN...s&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'snapshot_jobid'.
Invalid column name 'use_partition_groups'.
Invalid column name 'replicate_ddl'.
Invalid column name 'publication_number'.
Invalid column name 'allow_subscriber_initiated_snapshot'.
Invalid column name 'allow_web_synchronization'.
Invalid column name 'web_synchronization_url'.
Invalid column name 'allow_partition_realignment'.
Invalid column name 'retention_period_unit'.
Invalid column name 'decentralized_conflicts'.
Invalid column name 'generation_leveling_threshold'.
Invalid column name 'automatic_reinitialization_policy'.
Invalid column name 'snapshot_jobid'.
Invalid column name 'use_partition_groups'.
Invalid column name 'replicate_ddl'.
Invalid column name 'publication_number'.
Invalid column name 'allow_subscriber_initiated_snapshot'.
Invalid column name 'allow_web_synchronization'.
Invalid column name 'web_synchronization_url'.
Invalid column name 'allow_partition_realignment'.
Invalid column name 'retention_period_unit'.
Invalid column name 'decentralized_conflicts'.
Invalid column name 'generation_leveling_threshold'.
Invalid column name 'automatic_reinitialization_policy'. (Microsoft SQL
Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
------
Can anyone please help ?
Thanks
Savvas
What all did you do when you upgraded?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1139562228.104138.260770@.f14g2000cwb.googlegr oups.com...
> Hi to All,
> I had sql 2005 with sp3 and i was working succesfully with merge
> replication on Sql ce.
> Yestarday i upgrade to sql 2005 (first upgrate my sql200 with sp4)
> Now i am here in sql 2005 trying to create a new merge replication on
> windows mobile 2005 and i get to the final step this error
> ------
> TITLE: New Publication Wizard
> --
> New Publication Wizard encountered one or more errors while retrieving
> publication names.
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...s&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'snapshot_jobid'.
> Invalid column name 'use_partition_groups'.
> Invalid column name 'replicate_ddl'.
> Invalid column name 'publication_number'.
> Invalid column name 'allow_subscriber_initiated_snapshot'.
> Invalid column name 'allow_web_synchronization'.
> Invalid column name 'web_synchronization_url'.
> Invalid column name 'allow_partition_realignment'.
> Invalid column name 'retention_period_unit'.
> Invalid column name 'decentralized_conflicts'.
> Invalid column name 'generation_leveling_threshold'.
> Invalid column name 'automatic_reinitialization_policy'.
> Invalid column name 'snapshot_jobid'.
> Invalid column name 'use_partition_groups'.
> Invalid column name 'replicate_ddl'.
> Invalid column name 'publication_number'.
> Invalid column name 'allow_subscriber_initiated_snapshot'.
> Invalid column name 'allow_web_synchronization'.
> Invalid column name 'web_synchronization_url'.
> Invalid column name 'allow_partition_realignment'.
> Invalid column name 'retention_period_unit'.
> Invalid column name 'decentralized_conflicts'.
> Invalid column name 'generation_leveling_threshold'.
> Invalid column name 'automatic_reinitialization_policy'. (Microsoft SQL
> Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...7&LinkId=20476
> ------
> Can anyone please help ?
> Thanks
> Savvas
>

cannot create connection

I created a report using Report Designer. The Dataset is working fine. In
fact, the Data tab shows me the expected query result. But...
when going to the Preview tab, I get "Cannot create a connection to data
source <name> . Login failed for user 'sa'.
Further info:
1) if I go to Tools / Connect to database and enter the info in "Datalink
properties" (server name / specific user name passw / database name) and hit
Test connection, I get "Connection succeeded"
2) During creation of data source for a SQL Server machine on the network
when connecting with winNT security I get an error while trying to access the
database list.
What am I doing wrong ' THnksHi,
Go to your "Shared Data Sources" click on the datasource you use for your
reports, open the properties by double clicking on the "credientials" tab
enter your password again and save it.
It should work.
Amarnath
"julio" wrote:
> I created a report using Report Designer. The Dataset is working fine. In
> fact, the Data tab shows me the expected query result. But...
> when going to the Preview tab, I get "Cannot create a connection to data
> source <name> . Login failed for user 'sa'.
> Further info:
> 1) if I go to Tools / Connect to database and enter the info in "Datalink
> properties" (server name / specific user name passw / database name) and hit
> Test connection, I get "Connection succeeded"
> 2) During creation of data source for a SQL Server machine on the network
> when connecting with winNT security I get an error while trying to access the
> database list.
> What am I doing wrong ' THnks
>|||Amarnath,
thanks a lot. It works like a charm.
Julio
"Amarnath" wrote:
> Hi,
> Go to your "Shared Data Sources" click on the datasource you use for your
> reports, open the properties by double clicking on the "credientials" tab
> enter your password again and save it.
> It should work.
> Amarnath
>
> "julio" wrote:
> > I created a report using Report Designer. The Dataset is working fine. In
> > fact, the Data tab shows me the expected query result. But...
> >
> > when going to the Preview tab, I get "Cannot create a connection to data
> > source <name> . Login failed for user 'sa'.
> >
> > Further info:
> >
> > 1) if I go to Tools / Connect to database and enter the info in "Datalink
> > properties" (server name / specific user name passw / database name) and hit
> > Test connection, I get "Connection succeeded"
> >
> > 2) During creation of data source for a SQL Server machine on the network
> > when connecting with winNT security I get an error while trying to access the
> > database list.
> >
> > What am I doing wrong ' THnks
> >
> >

Cannot create an instance of OLE DB provider "VFPOLEDB"

I created a view refer to a visual foxpro with ole db for visual foxpro which was working fine before. But now, I received an error while select the view

Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server "ORST3".

Please advise. Thanks in advance

Hi Stephanie,

You posted this question to microsoft.public.data.oledb on April 3. Later in the thread you said you were successful getting it working, partly due to enabling "Allow inprocess" in the OLE DB setup.

Is this a new problem since you posted on April 3?

Cannot convert to decimal

I have a money field in SQL that when i try and get the sum of it i cannot convert it to decimal. This was working now its not, and nothing was changed.

Any reason for the error?

DECLARE @.TEST decimal(10,2)
SET @.Test = (SELECT SUM(INV_Net) FROM abc.dbo.iSplit_Details WHERE LoanID='0000010604')
Print @.Test

RETURNS: 160471.24
----------------------------------------------------

Specified cast is not valid.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.InvalidCastException: Specified cast is not valid.

Source Error:

Line 3576: // CURRENT TOTAL
Line 3577: cmd.CommandText = "SELECT SUM(INV_Net) FROM abc.dbo.iSplit_Details WHERE LoanID=@.LoanID";
Line 3578: decimal split_currentamt = ((decimal)cmd.ExecuteScalar());

Check if you have NULLs. Its a good idea to set a default of 0 for these type of columns to avoid errors like these.

SELECT SUM(ISNULL(INV_Net,0)) FROM abc.dbo.iSplit_Details WHERE LoanID='0000010604'

|||

that was good information to know, i can use that in a lot of other spots. Thanks

but im still getting the same error.

|||

Was the error at the front end (converting the value to decimal) or at the backend? IF you run the query in query analyzer do you see any errors?

|||

when i run it in query analyzer it works.

|||Oh ok. It wasnt clear if it was a front end issue or a back end one. Can you create a new post again in WebForms section? Sorry for the inconvenience. I dont code in .NET so I may not be able to help you there.|||If you are formatting your currency column in your front end, you may need to strip out the dollar sign($) before you send it back to your database.

Cannot convert SQL Server 2005 Database to SQL Server 2000

Hi all,
can anybody tell how to use sql server 2005 database in sql server 2000? i thought it will work easily but its ont working. do i need conversion? Please help me.

hi you cant use a 2005 database in 2000 server

this is not possible in any way

|||One workaround is to setup a snapshot replication.|||

You could use "Import and Export Wizard" to copy Tables and views and data to target SQL 2000 server.

Using Management Studio, connect to SQL 2005 Server and Right click on database and select Tasks -> Export Data

If any of your table leverages new functionality in SQL 2005, you cannot copy those tables

You could use Generate Scripts Wizard to script functions and stored procs. As long as they dont use new SQL 2005 features , you could apply those scripts on target SQL 2000 Server

Thanks

Sethu Srinivasan

SQL Server Manageability Dev Team

|||You can use this.

http://sql-articles.com/index.php?page=articles/migrating_2005_2000.html

Hope This Helps

Cannot connect to SQLServer2000

Hello everyone,

My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.

Hi,

"SQL Server does not exist or access denied" is a generic Microsoft Data Access Components (MDAC) message that indicates that the computer that is running Microsoft SQL Server cannot be contacted. Since your problem occurs radomly. So it has many potential causes, the following link may provide some detail information.

http://support.microsoft.com/kb/328306/en-us

Thanks.

Cannot connect to MSOLAP Provider

I could not get my ASP pages to connect to the Analysis services
Server on a different box. The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")
cat.ActiveConnection = "Data Source=asServer;Initial
Catalog=MyMart;Provider=msolap;"
My environment is:
The web server box (Server A) : Windows 2003 Server with IIS6, SQL
Server Client sp3 and Analysis Service Client sp3 are both installed.
All other asp pages not using ADOMD all work fine. Most of the web
applications on this server are ASP.NET.
The AS Server box: Windows 2000 with SQL Server 2000 SP3 (8.00.760)
The problem page works fine on other Windows 2000 server with IIS 5.
And the strange thing is: from Server A, the MDX Sample Application
works fine.
Any help is greatly appreciatedHello Tommy,
I noticed that the issue was posted in several groups
(microsoft.public.sqlserver.olap, microsoft.public.sqlserver,
microsoft.public.sqlserver.datawarehouse
)._ I have added a reply to you at
http://msdn.microsoft.com/newsgroup...t.public.sqlser
ver.olap&lang=en&cr=US
If you have follow up questions, please post there and I will work with
you. Thanks.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Cannot connect to MSOLAP Provider

I could not get my ASP pages to connect to the Analysis services
Server on a different box. The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")
cat.ActiveConnection = "Data Source=asServer;Initial
Catalog=MyMart;Provider=msolap;"
My environment is:
The web server box (Server A) : Windows 2003 Server with IIS6, SQL
Server Client sp3 and Analysis Service Client sp3 are both installed.
All other asp pages not using ADOMD all work fine. Most of the web
applications on this server are ASP.NET.
The AS Server box: Windows 2000 with SQL Server 2000 SP3 (8.00.760)
The problem page works fine on other Windows 2000 server with IIS 5.
And the strange thing is: from Server A, the MDX Sample Application
works fine.
Any help is greatly appreciated
Hello Tommy,
I noticed that the issue was posted in several groups
(microsoft.public.sqlserver.olap, microsoft.public.sqlserver,
microsoft.public.sqlserver.datawarehouse
).X I have added a reply to you at
http://msdn.microsoft.com/newsgroups...public.sqlser
ver.olap&lang=en&cr=US
If you have follow up questions, please post there and I will work with
you. Thanks.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Cannot connect to database using SQL Authentification !!!!!!

I cannot connect to my database using SQL Authentification for a user who is working fine. I know I'm putting the right username and password because I just recently logged in using Windows Authentification to my database, and retyped the password just to be sure it's right. I even tried createing a new sql login and tried that, no luck.

And yes, SQL is in mixed mode for Authentification as it has been all along.

error when trying to connect is:

TITLE: Connect to Server

Cannot connect to (local).

ADDITIONAL INFORMATION:
Login failed for user 'sqlapps'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

BUTTONS:
OK

Out of curiosity, can you login as sa?

Cannot connect to a datasource error

I have been working on a report for a while now and just when I go to deploy it, the bloody thing stops working.

I have been testing it mainly under my account (Admin + Domain Admin) and peridocally under another admins account. I have also been testing it under a dummy normal account (domain user only) and up until now it has worked fine.

Originally it did not work although I found that if I Rebuilt & Redeployed the project to the server and then started Reporting services and selected the datasource1 and supplied my credentials and checked Use as Windows Credentials and also the Impersonate check, it all worked perfectly.

However now this does not appear to be the case

The exact error I get is

'An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DashboardSQL-2K5'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors'

The connection string under the properties of datasource1 are

INTEGRATED SECURITY=SSPI;INITIAL CATALOG=DashboardSQL-2K5;DATA SOURCE=XXXXXXXX;

XXXXXXXXX is obviously the name of my server blanked out

Please help as I wish to deploy this report and it is just sods law that it stops working today.

Regards

Further poking around etc showed me that there were a couple of setting adrift in the various places.

I am now at the point where I have got it to work, the only problem I now have is that unless I grant DomainName\Domain Users as sysadmin in the permissions for the database, I get an error similar to below when I try to go to

http://ServerName/Reports

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'srcqry_weeklydatadate'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

Now that query it is trying to run is a select query in the report that populates the first parameter box on the report selection criteria. What do I need to change in the report to prevent this from happening. I can't very well allow all and sundrey in as sysadmin for obvious reasons.

Regards

|||Open data source props and make sure that credentials are set to "Windows integrated security" or "Use as Windows credentials when connecting to the data source"

Cannot connect SQL server 2005 Express with VWD 2005

I have installed MS Visual Web Developer 2005 Express Edition on my Notebook (WinXP Pro SP2). And it's working fine. Then I tried installed SQL Server 2005 Express Edition SP1. There is no error during installation and it seems to be working as I can see the SQL Server (MSSQLServer) service is running. As SQL server configulation manager., the protocal shared memory , named Pipes and TCP/IP are enabled.

But when I want to add connection using VWD 2005 by pointing to datasource (MS SQL Server database file and selecing file from .mdf file from SQL sample database file. Then test connection, I got a error that
"An error has occurred while establishing a conneciton to the server. when connecting to SQL server 2005, this failure may be casued the the fact that under the default settings SQL server does not allow remote connections. (provider: SQL Interfaces, error: 26- Error locating server/instance specified)

Can you please advise what the missing part of my configulation ?

Thanks

hi,

did you elect to enable User Instances at SQLExpress install time?

you can enable them at later time "configuring" the instance via the apposite
EXEC sp_configure
statement

regards

|||

This is most likely caused by having the wrong Instance name configured in VWD. You wrote that your could see MSSQLSERVER, which the name of the Default Instance for SQL Server. Normally SQL Express installs to a Named Instance rather than the Default Instance. Did you specifically chose to install the Default Instance when you installed SQL Express?

If so, your problem is that VWD is configured to use a Named Instance of SQLEXPRESS by default. You will need to go into the Tools | Options dialog and look at the Data options. (You may need to show all options to see this.) Once there, you will see a text box where you can set the instance of SQL Express to be used, it will likely say "SQLEXPRESS" and you need to change it to the actual name of your instance.

Mike

|||

Mike,

You are correct.

Big Thanks for advise.

Pitak