Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts

Thursday, March 22, 2012

Cannot delete merge publication

Hello...
I had a merge publication that I thought was removed...at least it does not
appear in Ent. Mgr under the list of Publications. However, in the
Replication Monitor the publication still exists. When I click on the
publication to delete or check its properties I get the mesage:
SQL Server could not retrieve information about publication 'My_Publication'
Error 21776: [SQL-DMO] The name 'My_Publication' was not found in the
MergePublications collection. If the name is a qualified name...'
I searched for that error code...but could not find anything that would help
me solve this problem.
if anyone has any ideas, it would be appreciated.
thanks
- dw
check sysmergepublications in the publications database. Do you find the
publication there?
If so you will need to delete it and the matching sysmergearticles columns.
Also delete the rows for this publication from
distribution.dbo.MSpublications
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"dw" <dw@.discussions.microsoft.com> wrote in message
news:85F329D5-E863-41A5-8AB3-8BB008C98EC7@.microsoft.com...
> Hello...
> I had a merge publication that I thought was removed...at least it does
not
> appear in Ent. Mgr under the list of Publications. However, in the
> Replication Monitor the publication still exists. When I click on the
> publication to delete or check its properties I get the mesage:
> SQL Server could not retrieve information about publication
'My_Publication'
> Error 21776: [SQL-DMO] The name 'My_Publication' was not found in the
> MergePublications collection. If the name is a qualified name...'
> I searched for that error code...but could not find anything that would
help
> me solve this problem.
> if anyone has any ideas, it would be appreciated.
> thanks
> - dw

Thursday, February 16, 2012

Cannot connect to sql database using Config app tool.

hi AllI'm new comer , the first time to work with Ent lib , I try to use modify sql connection string using configuration application tool integrated in Visual Studio against sql server 200 , I got this error .

_http://imagesshared.com/images/jdv1192388741v.JPG

I don't know how to solve my problem , someone please help me to overcome this problem .Thanks in advance .sorry for my poor English , I'm a Vietnamese student .

The problem is that you're trying to connect to a Sql server express user instance, but you're in fact using Sql Server 2000. You can modify your connection string to work with sql server 2000, or you can download and install sql server express - this is a free download from here:http://msdn2.microsoft.com/en-us/sql/Aa336346.aspx .

|||

DO the following modification in the Connection String of the App.Config / Web.config ...

Remove the AttributeUser Instance =true from the connection string that should solve the issue

|||

Thanks Svante , skurocks for replying

Then I solved my problem , thanks skurocks|||

Hi All

I got this error when I try to display whole record of customers table into GridView .

_http://imagesshared.com/images/opt1192519086n.JPG

This is the first time I work with Ent Lib 3.1 .

Here is my source code , please help me and explain to me why this error occur .

_http://www.4shared.com/file/26591127/38feb983/WebSite1.html?dirPwdVerified=814e49b

Thanks in advance for your time .

.........

Regards