Barguast's Q&A profile

• SQL Server Dumb question about compatibility level

  Hi everyone, This is my first psot so I am hoping for success.. I had been asked to web enable a sql 2000 database. We upgraded to sql 2005 and I imported the data. All went well until a tried to run a CTE ( common table ) routine and it kept on coming back with an error. On searching the web it turns out that the compatibility level must be set to 2005. When I tried to set the compatibility level the only two options are sql 7 and sql 2000. I thought it might be due to the fact I had restored from a 2000 database so I tried to create a new database in SSMS but again only sql 7 and 2000 options were available from the drop down box.. What am I doing wrong Am I not running in sql 2005 at all Any help would be appreciated Peter ...Show All

• SQL Server Error 1429: A server cursor cannot be opened...

  Using SQL native client from VFP 9.0 to SQL Server 2005 64 bit SP1 (happened before SP1 too).. We have a stored procedure that returns 6 result sets. This SP uses 2 cursors. It is rather lengthy - I'll post the code if needed. This SP works fine when called from VFP 99 percent of the time. Normally takes 2 to 3 secunds to execute. Once in a while we will get a return from SQL .. "OLE IDispatch exception code 0 from Microsoft SQL Native Client: A server cursor cannot be opened on the given statement or statements. U se a default result set or client cursor..." The OLE error code is 1429. An OLE Exception code 3604 is also returned. When this happens the SP will return the same error when executed for the ...Show All

• Windows Forms Retaining and setting Multiple Sets of User Settings

  Hi All, I am developing a windows library project. Here my application is having the different identities which are created by the application. like name1,name2. I am creating the name1.idt and name2.idt to store information about the user identity. This name.idt is an xml file. For maintianing the settings for application i am using the app.config by giving the scope as Application. But for to store the user settings I donot know how to set and get manually the user settings at runtime (For each user ) . I need to store these user settings in my name.idt file. I searched in web , i found an article but it doesn't have full information. the url is http://www.code-magazine.com/Article.aspx quickid=0607031 Can any one kn ...Show All

• .NET Development Error using tcpclient/tcplistener

  I'm trying to run a sample tcpclient/ tcpListener program written in VB.NET on VS 2003 (.net framework 1.1). When I run this console program, I get 2 errors - 1) The requested address is not valid in its context - at System.Net.Sockets.Socket.Bind(EndPoint localEP) 2) System.InvalidOperationException : Not listening. Please call the Start() method - at System.Net.Sockets.TcpListener.AcceptTcpClient() The code as follows: TCPListener - Imports System.Net.Sockets Imports System.Text Class TCPSrv Shared Sub Main() Console.ReadLine() Const portNumber As Integer = 1526 Dim addrIP As System.Net.IPAddress = System.Net.IPAddress.Parse("170.186.144.132") Dim tcpListener As TcpL ...Show All

• Microsoft ISV Community Center Forums on Microsoft Certification Program for ISV

  We are planning to pass a veritest certifications for Microsoft Platform Test for ISV Solutions. Question is: How our managed application will be tested (AFAIK Application verifier is only for unmanaged code) Are Fundamental Requirements being checked formally or using some methodology or software. Thank You More than 1 year later... (1 year and 1 day...) Maybe it helps somebody... you could use Microsoft FxCop Bye ...Show All

• Software Development for Windows Vista Transactions being left open when using the TransactionScopeActivity

  Hi I'm having some issues with transaction being left open using the TransactionScopeActivity.  I'm using Sql 2005.  I'm expecting i'm not getting something here as I would be sure this sort of bug would not be let through to the RTM version of WF. I have further issues then this but I have gone back to Lab 8 (the transaction lab) and have the followig problem.  If I run the completed exercise one in lab 8 after disabling the ThrowActivity so the workflow succeeds I have 1 open transaction when looking at the Sql 2005 Activity Monitor.  This is before closing the console so the process still exists.  Also the database operations have been comitted as I can see the change in the database. Also, looking ...Show All

• Software Development for Windows Vista ICredentialProvider

  Did anybody make a successful user logon using the new ICredentialProvider interface My credentials are displayed, but I can't make them to logon. And what worse - after 20 or 30 seconds, the winlogon crashes completely with no recovery possible excepting hardware reset. I thought I basically did something wrong and decided to wait for more detailed documentation or some sample code. But MS doesn't seem to put too much effort on improving their SDK documentation and I also found that at least one other programmer has the same problem: http://msdn.microsoft.com/newsgroups/default.aspx query=vista&dg=microsoft.public.platformsdk.security&cat=en-us-msdn-windev-winsdk&lang=en&cr=US&pt=&catli ...Show All

• Visual Studio 2008 (Pre-release) how to set maxReceivedMessageSize for a vb6 client app that use a WCF service ...

  Hi I have a VB6 client app that calls in to WCF service hosted using netTcpBinding. The calls seems to work fine for other functions that returns small amount of data. But i have a function that returns a string (xml serialized dataset) and it exceeds the maxReceivedMessageSize(65536) and i get "RunTime error -2146233087 (80131501) - The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.". My vb client app is named vb6client.exe. So i added vb6clientapp.exe.config and added maxReceivedMessageSize="6553600" in the netTcpBinding section. But i still get this error. If i do the same on a WCF client ...Show All

• .NET Development xquery and bind comboBox with XML file problem.

  Hi Folks, I am trying to generate an XML file with element as "name" in it. file is sucessfully generated from database table as shown in code below, but i dont understand how to add name element same as node name. my purpose of doin this is: I have 2 columns in table and when i bind it to combo box it shows both the columns in dropdown. then i tried by adding name="element" in the node it worked. is there any way i can add thins on the fly while generation of xml files. (or is there any way of querying i can fetch test_name by using where condition. i am really confused with this query thing and scope of it. can any one help.) Dim tstNmSql As String = "SELECT PRODUCT_NAME, TEST_NAME FROM REL_TEST_NAMES" Dim tstNmAdapter As Sq ...Show All

• Visual Basic Autos Windows

  Is the Autos windows available from withing VB 2005 Express When in Debug mode and selecting Debug/Windows, Auto is not in the list as an available item (as suggested in several books and VB Help). Am i missing something How do I display the Autos window withing VB 2005 Express ...Show All

• SQL Server Standby, this is a test post, thanks for your patience

  I just have to try this. ...Show All

• Windows Forms Context Menu Strip

  Hey, by the way my richtextbox is set up I can not set the contextmenustrip I want to use diectly on the control. I have to use the Form1_MouseClick event. So how would I make it so that it only does somthing if the mouse left button is pressed I tryed: private void Form1_MouseClick( object sender, MouseEventArgs e) { if ( MouseButtons .Left) { } } but that does not work... Thanks :) well there is not a rich textbox I added myself, it is added with code and it has tab control so there is more then one and so the way my code works it uses a code to amke get get the current textbox being used...so I would have to use the form...the event would not work if I did it directly to the rich textbo ...Show All

• Visual Basic Re Opening : Add New MS Access Connection using Wizard

  Hello, In another thread I followed the discussion about the fact that when adding a new connection, using the wizard in VS 2005, the following error appears: "Format of the initialization string does not conform to specification starting at index 0." The thread is this one: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=133896&SiteID=1 I have the Reg-keys as mentioned, and I have an empty class in my project... Anyone Rob Rob Joosen, 1. Please download the Results for - "jet 4.0 sp8" in the following link in order to make sure you have no problems with the database engine: http://www.microsoft.com/downloads/results.aspx productID=&freetex ...Show All

• Visual Studio Express Editions DataGridView Column's expression

  hi all, i need to know more about DataGridView Column's expression. I have column-C want to do expression, choose Data from Column-A if the column have value, otherwise choose Column-B. It is got any idea ...Show All

• Visual Studio Team System Are there known issues with SQL Server 2005 SP2 and TFS?

  Now that the 2nd Service Pack for SQL Server 2005 has been released are there any known issues or any other considerations that need to be adressesed when patching the data tier of a Team Foundation Server Well I just finished installing the SP2 on a server running a AMD Opteron 252 CPU @ 2.6Ghz with 1GB RAM and it took about 20 to 25 minutes to install without any issues and TFS is still up and running. ...Show All