JB-Bellevue's Q&A profile

• SQL Server Log Reader Error: The process could not execute 'sp_repldone/sp_replcounters'

  I have transactional replication going between servers A and B. SQL Server 2005 64 bit A is Publisher B is Distributor and Subscriber Now I am getting the following Log reader Agent Error Msg The process could not execute 'sp_repldone/sp_replcounters' on 'A'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure. (Source: MSSQLServer, E ...Show All

• SQL Server Inserting image data type from SQL Server CE to SQL Server 2000.

  Hi All, I am manually replicating parts of a SQL Server CE database (running windows mobile 5.0) to a centralized SQL Server 2000 database. My program is throwing an exception whenever I try to insert an image data type into the 2000 server from the PDA. I am using parameterized queries. Error is as follows: [error] System.Data.SqlClient.SqlConnection.OnError() at System.Data.SqlClient.SqlInternalConnection.OnError() at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run() at System.Data.SqlClient.ExecuteReader() at System.Data.SqlClient.ExecuteNonQuery() at PDASync.Database.ExecuteIDRemote() [/error] The code for my ExecuteIDRemote method works fine for other queries. It also works if ...Show All

• Windows Forms DataBinding - OnValidation - Failure to fire - Not Firing - Bug ...?

  Hi all, Thanks for reading... I've got a databound textbox which is bound to a property on a "business object". I've set the databinding mode to OnValidation (In the properties window (whilst my textbox is selected>>Expand '(Databindings)' node>>Select the sub-node '(Advanced)'>> click on the '...' button>>set Data Source Update Mode to 'OnValidation' - sorry if that looks like I'm teaching you how to suck eggs. :-) )). Ok. Now, I load the application, the form appears with the databound textbox empty (which is how it should be). I then enter "hello world" into the textbox, this then results in firing the events 'Validating' and 'Validated' (like I expect) - the databinding autom ...Show All

• Visual Studio 2008 (Pre-release) namespace declared at Envelope Level are not taken into account...

  The problem occurs with .NET3 RC1 when trying to deserialize a DataContract which has a DataMember of type System.Object (xs:anytype) If the namespaces "xsi" and "xs" are defined at the Envelope level, they are NOT taken into account while deserializing the FaultContract. For example : in the following XML message, the namespaces "xsi" and "xs" are defined at Envelope level and are used in the "paramValue" dataMember of the CreateAddressFailedException FaultContract. When trying to deserialize using a DataContractSerializer, we get the following exception : Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channe ...Show All

• Visual Studio Express Editions visual web developer book

  i registered visual web developer to get free book. when i will receive that book Welcome to Visual Web Developer 2005 Express Edition! Thank you for registering MicrosoftR Visual Web Developer 2005 Express Edition! Below you will find registration benefits, resources, and community links to help you get better acquainted with Visual Web Developer 2005 Express Edition. Registration Benefits We are pleased to provide the following registration benefits for registered customers: Hosting — Build your first ASP.NET 2.0 site today, and deploy it live with a free 30-day test hosting account Stock photography — Download 250 royalty-free images from Corbis for inclusion in your Web sites E-book — Downl ...Show All

• Windows Forms Custom installation actions

  I'm developing a client server solution using a strongly typed dataset. That said the connection string is bound into an application setting. What I would like to do is have the MSI allow for the user to specify this on a page in the installer, check the details through the Sql SMO or just sql connection name space and then create the new exe.config xml file which explicitly sets the application setting before the program is run. The problem that I have is that I am currently at the retarded monkey level in my understanding of setup projects for windows. Could anyone give me some guidance or advice on where to get good information on this. (or indeed whether this installation pattern will be valid). Also if there i ...Show All

• Visual Basic !!!ComboBox selection Populates Grid View!!!

  DataBase: SQL Server 2005 Express SQL Tables Involved: Satellite, Transponder & Signal Language: VB.NET 2005 Framework: 2.0 1 ComboBox 1 DataGridView I populated a ComboBox from a Satellite Table - ComboBox is populated with the satellite SCC #s Ex. 22596 DataGridView is populated from the Signal table - Signal table also conatains Satellite SCC #s' I have attempted many combinations of queries and DataSet manipulations to know success Please Help if can, Thank You, in advance      Imports System      Imports System.Data      Imports System.Data.SqlClient      Imports System.Windows.Forms Public ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. slowing FPS display with timers... how?

  I'm new to timers, never used them/needed them so how would i go about implementing this What I need is a timer to display the FPS counter i have every second or so... float elapsedSeconds = 0; int frames = 0; protected override void Draw( GameTime gameTime) { frames++; elapsedSeconds += ( float )gameTime.ElapsedRealTime.TotalSeconds; if (elapsedSeconds >= 1) { elapsedSeconds -= 1; Console .WriteLine( this .Window.Title = "FPS: " + frames); frames = 0; } } ...Show All

• Visual C++ trouble getting started

  I have no programming experience and I have just installed microsoft visual studio 2005. I have a book on C++, it a few years old but i thought it would give me a start on learning c++. I want to compile one of the examples out of the book. How do I do that The book is teach yourself C++ by Al Stevens. Can anyone please help me out   nick865 wrote: heres what i typed (copy and paste)   cout<< "Hello World\n" ;    getch()    return 0;  }  You have a missing semicolon  here. :-)  Cheers    Sahir ...Show All

• SQL Server Metadata Model in SSIS 2005

  Hi *, Can anyone tell me what Metadata Model Microsoft supports with SSIS 2005 DTS in 2000 was supporting OIM but I was not able to get some information about this topic on SSIS 2005. The reason I need to know is that I wanna import some metadata from Business Objects Data Integrator into SSIS 2005 and Business Objects is supporting CWM.... I would appreciate your help! Thank you, Steve Hi Jamie, thanks for your help. I'm really frustrated that Microsoft's information policy on this subjects is so poor... DTS supported OIM because Microsoft had a different approache in storing meta data. Correct me if I'm wrong but SQL 2000 had a central repository, right Well I'm disappointed that MS that there is no chance to import metadata into ...Show All

• SQL Server Return empty rows for not existing data - possible?

  Can you help me solve this problem, please. The main table t0 seems not to be relevant here but contains all the unique information to an article. Each article can have many ingedients and several other 1:n related things. The one I have difficulties right now is t1 (analyse). Each article can have entries for 0 to 15 types of analyses that are stored in t2. Now I need a web entry form that lists all types of analyses with either the existing values or empty fields. It's no problem for me (althouh not very nice) to store empty values on save but I need to show the form even for new articles or existing artices that have no entries yet for analyse. I tried something like this: SELECT t1.id, t1.analyseid, t1.analysetyp, ...Show All

• .NET Development Windows 2000 Unhandled Exception

  I am running an app that connects to an SQL Express DB. I have a public connection variable Public mySqlConnection As System.Data.SqlClient.SqlConnection I then initialise it and connect to the DB like this: Dim DBName As String, DBPwd As String, sConnect As String DBName = "TimeBooking" DBPwd = "xxxx" sConnect = "Data Source=10.130.16.94\SQLExpress;Initial Catalog=TimeBooking;User Id=tb;Password=" & DBPwd & ";" mySqlConnection = New System.Data.SqlClient.SqlConnection(sConnect) This works fine on three machines all win XP Pro but reports an unhandled exception when run on Windows 2000. Two strange things are: 1. The exception SHOULD actually be handled as I have a Try ...Show All

• Visual Basic For Newline in VB

  What is the syntax for newline in VB as '\n' in C. Hi VB doesn't support that escape sequence natively ... afraid you have to use Environment.NewLine to achieve the same thing eg string.format("This is line 1{0}This is line 2", Environment.NewLine) Richard ...Show All

• Windows Forms Synchronization

  hello everyone, Hopefully my question is simple for everyone to answers, when I logoff I keep getting the synchronization, does anyone know how to stop that.... David Hi David, This is the wrong forum, Please see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=152532&SiteID=1 Good luck though, James ...Show All

• .NET Development To return a DataSet from the CSV

  I want to get a new DataSet from a CSV file.  How to make the copied list to a DataSet, returning the DataTable the list value please see the following:         public void CopiesCSV(string fileName)         {             string[] list;             string line;             StreamReader reader = new StreamReade(fileName, System.Text.Encoding.Default);             while ((line = reader.ReadLine()) != null)    ...Show All