RayCan's Q&A profile

• SQL Server SQL 2005 Enterprise to 2005 Standard

  We have a situation where we installed the Enterprise version of SQL Server 2005 on a server that is now in production and we had intended to install the standard edition (what we are licensed for). We have enterprise licenses for other servers so we have both types of media and it was a mistake that was made. I was wondering if there is a way to downgrade the version without uninstalling and reinstalling and having to backup and restore all the databases, jobs, SSIS packages, etc. Any suggestions or help would be much appreciated. Thanks, John Microsoft has historically been pretty generous when letting users use older versions of their software, even when it’s no longer available... this means t ...Show All

• Visual Studio Moving VSS6 from one server to another - howto, plus bonus questions

  Hello, We are currently running VSS 6.0a on an old piece of hardware running WinNT. That server is going away. We have a newer server running Win2003 Std. that will host VSS moving forward. I need to migrate our existing VSS over to it. I am by no means a VSS expert - mostly just a user, but now with Admin rights (this got dumped on me). Also, our office is closing next year, so I really don't see the need to upgrade to the newest version of VSS and deal with users not understanding this or that on the interface, or getting upset about the GUI changes. We'd really just rather move the data off of NT and onto Win2003, and let the company decide later if they want to upgrade VSS versions or move to different source control software. ...Show All

• Visual Studio 2008 (Pre-release) WCF and using Kerberos Message Layer Security in offline

  Is it possible to use Kerberos to secure WCF services between 2 machines on a LAN after it goes offline     The below diagram illustrates this:     http://farm1.static.flickr.com/156/375830162_f2d9b9256c_o.gif       So the scenarios is: 1.          It is assumed that the 2 machines have been connected the WAN and hence logged in to the Domain and Authenticated against Active Directory.   2.        The WAN goes down. So the machines are still connected to each other on the LAN but not the WAN. 3.        Send WCF messages between the 2 machines using Kerbero ...Show All

• .NET Development connection string to connect to a dataset?

  hi, how do i set up a connection string to get a dataadapter to read data from a data set into another datatable SqlConnection conn = new SqlConnection (); // ** connection string ** string selectQuery = "Select distinct ' " + tagValues[2] + " ' * from " + dSet[iDset] + "'" ; SqlDataAdapter f = new SqlDataAdapter (selectQuery,conn); dt[p] = new DataTable (); f.Fill(dt[p]); Thanks. hi, i have the data from the database in my dataset. i need the new dataadapter to read from this dataset not the database ...Show All

• .NET Development Oracle Real Application Cluster Support

  Hi Does anyone know what (if any) support the Microsoft .Net Framework data provider for Oracle has for the Oracle Real Application Cluster (RAC) The documentation for the Oracle data provider for Oracle list its level of support, but I can't find any positive or negative information about whether the Microsoft data provider for Oracle will even connect. Hope this makes sense and many thanks for any help in advance. Neil System.Data.OracleClient does not do anything explicitly to support RAC. OracleClient uses Oracle's OCI layer under the covers, so if there is something you can configure at the OCI level, or if there's an Oracle-specific connecting string attribute you can use to enable some ...Show All

• Visual C++ getting all existing windows login names in my computer by VC++ programming.

  Hi all. I want to get all existing windows login names in my computer by VC++ programming. :) Purusothaman A Thanks Einaros. I have seen that link and tested with the given code. The output is, ///////////////////////////////////////////////// User account on (null): -- Administrator -- Guest -- HelpAssistant -- postgres -- Public -- Purusothaman -- Sujith -- SUPPORT_388945a0 Total of 8 entries enumerated Press any key to continue . . . //////////////////////////////////////// But I want only user accounts, not service accounts. In the above list, Administrator, Guest, Public, Purusothaman, Sujith are normal login accounts. I don't want other than normal user login accounts. ...Show All

• SQL Server problem with calculated member

  i have the following tables: a membership fact table: id (PK), date (datetime), clubFK, level (integer), fee(money) a time dimension table populated by the server: date(PK), month, year etc, a club dimension table: id(PK), etc. there are three dimensions based on these tables. the default measure group is called 'Basic' and contains [Price] which corresponds to the fee column. i created a calculated member [Median Price] to calculate the median fee for a particular club at particular level: median ( exists ([Membership].[Id].[All]. children , [Time].[Time]. currentmember . children*[Membership].[Level].currentmember*[Club].[Id].currentmember , 'Basic' ), [Measures].[Price]) the MDX query i use is som ...Show All

• SQL Server SQL stored procs

  can anyone help me out.... i need to compare a date that was retrieved from the database and the system date then it must be coded in the stored procs of the database.. help!!!! help!!! now im able to filter the records that has the similar date.... the table in my database is named kDeadlines the field names are emailadd and date....how can i acquire all the emailadd records now coding it to vb.net 2005 please help... ...Show All

• SQL Server User Tables

  Hi, i'm a new in this, so when i create a Login form on VS 2005, i have a little trouble, i already create the db with a table called users and another called things, so the thing i wanna do is authenticate the users, for this on the table i have a 2 rows, "Users" and "password", an when in the login form i put the user an passwor i’t'll be the same on the table, but when i debbug, it shows me Cannot open database "clientes" requested by the login. The login failed. Login failed for user 'MOBILEWORK\mikke. thanks!!!!!!!! You are switching to a database context which either doesn not exists or the user mikke does not have permissions on. (You are either switching directly to the database or indirect ...Show All

• Windows Forms WebBrowser Control in EditMode - annoying popup on editing

  Hi there, So, I'm incorporating a WebBrowser control into my app to allow a user to create simple HTML pages. The WebBrowser is in Edit Mode, which I accomlish using webBrowser1.ExecCommand("EditMode", false, null). I've got a textbox on another tab that the user can switch to to view the HTML source code and make direct edits if they want to. My problem comes when the user switches back from the textbox to the WebBrowser, and I set the WebBrowser.DocumentText = the text in the textbox. Each time I do that, I get an annoying popup that tells me that my document has changed and do I want to save changes. Is there any way to get rid of this popup box Ah ha, got that too. Simple piece of code. You don't need the current cursor ...Show All

• Windows Forms warning about ToShortDateString

  This is a warning concerning the string ToShortDateString method. I tried using this in a textbox data binding Format event handler. I want the textbox to display the date without the time portion of the Date datatype. When I use this method the time it takes for the dataadapter to execute the Fill method is, well to call it slow is being nice. Instead I am using Private sub OnFormat(sender as object, e ...) If Not e.DesiredType Is GetType(String) then exit sub end if ' look for the space between the date and the time ' I am making an assumption about the date format but it works for english which is all I am concerned about at present Dim i as integer = e.Value.ToString.IndexOf(" ") if ...Show All

• Visual C++ msvcr80.dll Problem

  Hi there, can someone possibly tell me why Noton WinDoctor is telling me that 10 executables in the .NET Framework 2.0 cannot access the necessary dll file msvcr80.dll I see that the dll exists in the WinSxS directory and I'm running XP pro. I didn't have this problem until I downloaded the 2.0 framework at windows update. Any advice appreciated. Thanks. Naolin Thanks much everyone for the feedback. Sounds to me like its an inconsequential error that Norton will need to address in a future update to look for it in the correct dir. I read on an msn blog somewhere (sorry I cant find it again) that one should not put the dll in the system32 dir but from other posts it seems that it's possibly needed ...Show All

• Visual Studio 2008 (Pre-release) Problems with metadataResolver after upgrading to RC1

  Hi,   I have a service that is pretty simple. I generated a proxy class using the svcutil and supplied the the type of contract generated by the tool to a call to MetadataResolver (E.G. MetadataResolver.Resolve(typeof(IMyService), http://localhost/tMyService/Mex ) to look up the avaliable endpoints. This calls fails with the message ""The given key was not present in the dictionary." Stack trace:    at System.ServiceModel.Description.WsdlImporter.ImportWsdlBinding(Binding wsdlBinding, ErrorBehavior errorBehavior)    at System.ServiceModel.Description.WsdlImporter.ImportEndpoints(Binding wsdlBinding)    at System.ServiceModel.Description.WsdlImporter.ImportEndpoints(ContractDe ...Show All

• Visual C++ How to get handle of a formview?

  I developed a MFC singledocument application in VS2005. Then I added two formview, named IDD_FORMVIEW1, CVideo1, and IDD_FORMVIEW2, CVideo2. How can I get the HWND, or m_hWnd of every formview When I define a object in view.h as: CVideo1 aVideo1, it said webcamex6aview.cpp(30) : error C2248: 'CVideo1::CVideo1' : cannot access protected member declared in class 'CVideo1' 1>        c:\documents and settings\fangming\my documents\visual studio 2005\projects\exercise\webcamex6a\webcamex6a\video1.h(13) : see declaration of 'CVideo1::CVideo1' 1>        c:\documents and settings\fangming\my documents\visual studio 2005\projects\exercise\webcamex6a\webcamex6a\video1.h(8) ...Show All

• SQL Server Create new database as a user instance

  Hello... Is there any way to create a new database directly as a user instance. I guess this means creating a new mdf/ldf pair which is detached from the server after its created. Thank you... papadi wrote: Hello... Is there any way to create a new database directly as a user instance. I guess this means creating a new mdf/ldf pair which is detached from the server after its created. Thank you... why u need this....r u sure u want to create database per user ..... or u want tables per user.... Madhu ...Show All