Cannot Debug SP.

Hi, everybody?!
I cannot use debugging function on some clients. For example, on my PC I
cannot use debugging facility.
Whenever I try to use debugging facility, it just returns results and ends.
I cannot use step-by-step function.
But on my laptop, I can use the function very well.
I wonder why I can't use the function on some clients, and can on other
ones.
Thanks.This is usually fixed by stepping through the section in BooksOnLine under
"troubleshooting SQL Server, Transact-SQL debugger" and ensuring you have
all the steps done correctly.
--
Andrew J. Kelly
SQL Server MVP
"Kim, KeukTae" <zyuuzika@.korea.com> wrote in message
news:OweEoodSDHA.3700@.tk2msftngp13.phx.gbl...
> Hi, everybody?!
> I cannot use debugging function on some clients. For example, on my PC I
> cannot use debugging facility.
> Whenever I try to use debugging facility, it just returns results and
ends.
> I cannot use step-by-step function.
> But on my laptop, I can use the function very well.
> I wonder why I can't use the function on some clients, and can on other
> ones.
> Thanks.
>
>

Cannot create merge replication from SQLSERVER 2000 to ORACLE

Hello everybody,
I am trying to build a merge replication between 2 servers
i managed to create it between to SQLSERVER 2000 with no problem
but now i am trying to do it between SQLSERVER 2000 and ORACLE server
when i try to do a transactional replication it work fine between the two
servers
but when i try to do the merge replication the following error occur:
The step did not generate any output. The step failed
i searched the topics and did not find any help but i managed to try writing
the output error on a file and it gave me the following message:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
Category:NULL
Source: Merge Process
Number: -2147200933
Message: The process could not load the Merge Replication Provider for
'Oracle'. Check to see if the component is registered correctly.
if anyone can help me with, please do
best Regards
Nicolas
This is not supported, you can only replicate to SQL Server, MSAcess and SQL
CE. You will have to cobble a solution together for this.
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
"Nicolas Akl" <c_khano@.hotmail.com> wrote in message
news:D66DB88D-29E0-449B-B578-D775BFDD2572@.microsoft.com...
> Hello everybody,
> I am trying to build a merge replication between 2 servers
> i managed to create it between to SQLSERVER 2000 with no problem
> but now i am trying to do it between SQLSERVER 2000 and ORACLE server
> when i try to do a transactional replication it work fine between the two
> servers
> but when i try to do the merge replication the following error occur:
> The step did not generate any output. The step failed
> i searched the topics and did not find any help but i managed to try
writing
> the output error on a file and it gave me the following message:
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
> Category:NULL
> Source: Merge Process
> Number: -2147200933
> Message: The process could not load the Merge Replication Provider for
> 'Oracle'. Check to see if the component is registered correctly.
> if anyone can help me with, please do
> best Regards
> Nicolas
|||Dear Hilary,
As i understand from you, that there is no way to make a merge
replication from sqlserver 2000 to Oracle,
if so why does it support transactional replication and not the merge
replication
Best Regards
Carlo khanati.

Cannot connect to MSDE from C# code

Hello everybody and happy holidays to all.
I'm new to C#, and I appologize for this basic question.
I am trying to connect to an SQL database from a very short C# program, which I found on the Microsoft site, demonstrating this subject.
Here is my setup:
Windows 2000 Professional
dotNET Framework 1.1 with sp1 installed
MSDE 2000
Note: I do not own nor do I have Visual Studio.NET of any kind installed.

Now, here is what works:
osql -E -S localhost\vsdotnet
1>
And I can create and populate a database, which I called mydb.

Now, in my simple C# demo program I have this line

SqlConnection mycon = new SqlConnection("server=localhost;database=mydb;trusted_connection=true");

And the program compiles OK using "csc" command. But when I run it, I get this message:
Couldn't Open Connection to server=localhost;database=mydb;trusted_connection=true

Could anybody comment on what am I missing?
Thanks.The complete answer can't be given without knowing if you chose to use intgrated NT security or not during the MSDE installation. Either which way your connection string is incomplete.

If you installed MSDE using NT integrated security your connection string should also contain: Persist Security Info=False;Integrated Security=SSPI;

If not you will have to provide a username password pair such as:
uid=sa;pwd=secret;

Hope this helps

Cheers

Gary