Francesco75's Q&A profile

• SQL Server Upsizing Wizard

  A few days ago I installed SQL Server 2005 Express edition and successfully used the upsizing wizard to convert a MS Access database to SQL Server database. Today I found I could get VB.Studio Express. The instructions said to delete SQL Server Express and .NET before installing VB Studio because it would re-install them both. I faithfully did that but since then I have been unable to get the upsizing wizard to work again. I have uninstalled SQL Server and re-installed it but still cant get it working. From SQL Server Configuration manager I can confirm that Shared Memory and TCP/IP protocol are both enabled for both protocols for clent and ...Show All

• .NET Development List of OleDb Providers

  Hi, I'm developing a generic database interface tool. Some vendors have their Dot Net drivers, while in other cases I need to go through an OleDb provider.  I'd like to show the users a list of available OleDb drivers installed on their machine.  I've seen other tools (e.g. DTS) doing this. How would I get a list of available OleDb providers in Dot Net code   I realise this is a low-level feature, and, if it gets too complex, then I'd rather leave it for a better day. Andrew Use OleDbEnumerator.GetEnumerator to enumerate the available data sources on a machine. OleDbDataReader rdr = OleDbEnume ...Show All

• SQL Server Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum)

  I just received this message: Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum) I am completely dead in the water. Cannot connect to SSAS 2005. HELP! hello, it is not quite clear what are you trying to do when the exception happens. Is the system really running low on memory the comment above seems to suggest that you are trying to connect to SSAS, however the exception seems to come from SMO ( ) which is an OM for working with SQL server (relational). if the issue is that you are unable to connect to MSAS, could you please provide more information as to what are the sequence o ...Show All

• Visual Basic Simple question on variables.

  I want one button to only work if another has been pushed first, I can do this with booleans right One turns the boolean on, the other checks if its true and responds accordingly. But it seems variables dont carry over from subs, there has to be a way round this. Could you help me out Thanks in advance. Sion. Hello Sion, The problem is that you need to declare your boolean flags at the Class level and not at the sub level. Notice in the code below that instead of declaring the Flag1 inside a sub it's done outside and in the class. This is called scoping it at the class level which means that any me ...Show All

• Windows Forms Datagrid and Arrow keys, how to make the arrow move around?

  Ok Simple problem. I have a MS datagrid I made my very own multiline columnstyle for my datagrid. Right away I had problems. Yea it was multiline (using a regular textbox that shows up on focus of the custom columnstyle), the problem was the fact that if you hit enter it would go to the next row. Now I would expect tab to be used for&nbs ...Show All

• Visual Studio How to integrate ToolBox into Visual Web Develop Express

  I wrote one C# .NET Program, It can integrate ToolBox into Visual Studio 2003 and Visual Studio 2005,but I want it work on Visual Web Develop Express. I want to gets the type associated with the specified program identifier(ProgID), the code are: Type type = System.Type.GetTypeFromProgID("VisualStudio.DTE.8.0"); DTE dte = (DTE)System.Activator.CreateInstance(type, true); //These are for Visual Studio 2005 I want it work on Visual Web Develop Express, I try to modify the code to (a) Type type = System.Type.GetTypeFromProgID("VWDExpress.DTE.8.0"); DTE dte = (DTE)System.Activator.CreateInstance(type, true); (b ...Show All

• Visual C# Solution files

  How do I create 2 or more than 1 solution files for the same project file in the same folder. I actually need one for 1.1 framework and other for 2.0 framework. Thanks! Well, I should have framed this way. How do I create 2 or more than 1 solution files for the same cs file in the same folder. I actually need one for 1.1 framework and other for 2.0 framework The answer then will be simple...got it!!! ...Show All

• Visual C# Corrupting Visual Studio.NET

  When I place a button on form, compile and run the program it goes fine but after compilation if I change the name of the button and then recompile the programe I get runtime error message "Unhandled Exception System.Drawing", after this if I try to run the previously compiled file I get the same error, the only solution is to reinstall the Visual Studio. Hi    Thanks for suggestion, but yes whenever VS gets corrupts it only stop compiling and running projects, new projects are created in the same way, I tried it on another machine of my friend who is running WinXP SP2 and we tried VS 2000 but it di ...Show All

• Visual Studio Team System How to upgrade my VSTS Team Suite Trial to real?

  I know there's already a thread titled similarly but it doesn't help my situation. My VSTS Team Suite Trial Edition install is to expire in 20 days (you know it reminds you every time it starts). The role change for my MSDN Premium with Team Suite is complete (now when I login to my MSDN I can see Team Suite as a download option). My question is, how do I upgrade the VSTS Team Suite Trial install on my computer without an uninstall/reinstall Everytime I go to Help -> About Microsoft Visual Studio and click the Uprade button, it takes me a this URL http://msdn.microsoft.com/vstudio/products/ I also have ...Show All

• SQL Server Missing data source"....

  I wanted to demonstrate how SSIS can easily read an Excel file into a database. I started up the wizard (dtswizard) looked and looked by couldn't find "Excel" in the list of datasources. Next I started up the SSIS IDE, found an Excel Destination, and created a flow that errored out on the copy to Excel step. >>> SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Error: 0xC0202009 at Package, Connection manager "Excel Connection Manager": An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. S ...Show All

• SQL Server Is this possible?

  Hey guys, I wrote a T-SQL query to retrieve all errors name and count the error for each error name based on some conditions. Assume that errors_name is a column name in Error table and the error_count is a calculated field. Here is my question; when I run the query, obviously, it displays the list of errors name and the corresponding errors count which only meets the where condition . However, what I need is to list all the errors name (even if they don't meet the condition) and assign a zero value to the error count column for those errors name that do not fulfill the where condition. Can anybody assist me Appreciate your ...Show All

• Windows Forms Plz I want every one to share me this problem

  I want to use datetimepicker to display arabic calender instead of english calender so how to do that Do you mean: "Hijri Calendar" If yes, then I'm sorry to tell you that the DateTimePicker doesn't support it. This is a limitation in the OS but should be solved in Windows Vista. Or do you mean: Arabic month names and day names, in the Gregorean calendar If yes, this depends on your system setting and not CultureInfo. Check this http://support.microsoft.com/default.aspx scid=kb;en-us;889834 ...Show All

• Visual C# Accessing an Array using Propery

  Hi, I am using properties for Setting and Getting data values, such as, public string ModuleExists{ get{ return moduleExists; } set{ moduleExists = value; } }//end public string ModuleExists How would one use the above concept if the moduleExists is an array of values Thanks Jeff public string[] ModuleExists { get { return moduleExists; } set { moduleExists = value; } // remember this lets them set a whole new array. If this is not desired then remove it } ModuleExists[5] = "some new value"; Your question wasn't very clear so I just posted some pote ...Show All

• SQL Server Versions of SQL Server 2005

  I hope this is the right forum for this question: Where can I find detail information on the different versions of SQL Server 2005 I need to know what features do each have that others don't. I went for the launch of VS2005 & SQLServer2005 Event and they had interesting information on SQL Server. I need to purchase one that at lease has business intelligence, report services, analysis servises and maybe database mirroring. Any help would be greatly appreciated. I suggest you start by looking at this link, which shows the major features available in the various editions. http://www.microsoft.com ...Show All

• Visual Basic DataAdapter & query

  kind of a 2 part question: I need to query on 3 parameters: i.e. Name AND <X AND >Y at one Table in the DataAdapter. In using the DataAdapter.SelectCommand approach I find that one can pass only 1 parameter. So I simply put 3 separate commands - - and this seems to work (when there is a match) though I haven't rigorously checked it. so part 1 - is this approach ok In this DB there can only result in 1 match or no match. part 2 where I'm stuck is that finding no match is a good thing for the user - but I get a ServerError message of Not non-Zero index....... I was hoping that by having a bound textbox/label to one fi ...Show All