spyders's Q&A profile

• Visual Basic migration from TrueBasic

  I All I have the following conversion problem.  In TrueBasic (an old structured Basic) nested routine were allowed. Look, for instance, the the following Module main       Sub XXX() Dim a Sub ZZZ() Dim b End Sub End Sub Sub YYY()       End Sub End Module     In the above fragment the variable "a"  and also "b" are seen from both XXX and ZZZ( this last is the nested procedure) but not from YYY. I do not succeed in reproducing this behavior in VB.net but I know that with all that power ( class, structure , module,etc) it is surely possible. Please, can somebody help me   thank in advance   Federico ...Show All

• Visual C++ MultiByteToWideChar of VC8 went wrong, but VC7 worked. (Actually not MultiByteToWideChar's fault but a file decoding issue)

  Dear all, For example: MultiByteToWideChar(CP_UTF8, 0, str, (int)strlen(str)+1, wstr, 1024); Assume "str" is a "bo-po-mo-fo" Chinese phonetic alphabet such as "ㄉ", in VC8, this function always failed; however, it worked fine in VC7. Does any one know how to fix it Thank you very much! Sincerely, Mike The provided code page was CP_UTF8. According to MSDN document (http://msdn.microsoft.com/library/default.asp url=/library/en-us/intl/unicode_17si.asp): Note: For UTF-8, dwFlags must be set to either 0 or MB_ERR_INVALID_CHARS. Otherwise, the function fails with ERROR_INVALID_FLAGS. When I send UTF-8 encoded Chinese character into this function in VC7, it w ...Show All

• Smart Device Development .NET CF 2.0 application occupies lot of memory

  Hello, I have created a .NET Cf 2.0 application which working perfectly fine however as the application is continuosly used over a few hours the program memory goes on reducing till finally at some point it gives a system error and crashes. Also after the crash the memory is not release and the application is also not running after teh crash. Only after a soft reset th memory comes back to normal size. What could I be doing wrong Devices tested on HX4700 (WM 5), HP 2210 (WM 2003), Dell Axim X50 (WM 2003 SE). Hozefa You have a memory leak which you'd need to find and fix. Most common reason is not disposing of IDisposable objects allocating native resources, e.g. Bitmaps. ...Show All

• Visual Basic Old code issues...

  I use VB6 at school, and was quite used to doing the following: number = txtbox1.txt mumber = number+42 lbl1.caption = number Why does it not work with the new version, and hw can I fix it What I'm looking for is a way to get text (in this case numbers) from a textbox, manipulate it, and output it to a label. How can I do this Also., for later purposes, how do I directly output a textbox to label that still wont work as you need to CONVERT the value to an integer, even then it may not work as the value may not be a numeric value. This is what you would do: Dim theNumber as Integer theNumber = Convert.ToInt32(Me.theTextBox.Text) theNumber = theNumber + 42 Me.theLabel.Text = theNumber.ToString() th ...Show All

• Visual Studio Sandcastle Help file - First page is blank except for a warning icon.

  Hi Foks, First let me say, GREAT product. I can't wait to see it develop further. Second, I'm having a problem. Every help file I create with Sandcastle results in a CHM file that has a blank opening page. The Namespaces node is selected, but the Namespaces help page isn't displayed unless the user clicks on the root node again. Any ideas Thanks! George Ok I couldnt wait to find out, so I remoted in to check... the version of sandcastle.msi appears to be the August CTP version.  The file size matches exactly at 6858kb. Is it possibly something with my HTML Help compiler verion   I'm using the one that was pre-installed on my PC at the office, so I have no clue if it is dated. ...Show All

• Windows Search Technologies Uninstalling Windows Desktop Search

  I'd like to uninstall my windows desktop search but can't find it in the add/remove programs. How can I uninstall it I would also like to uninstall Windows Desktop Search and am unable to locate in "Add / Remove Programs". The version installed on my computer is 6.0.5361.0 ...Show All

• SQL Server SQL 2000 RS Licensing Question

  We have a SQL Server 2000 Enterprise Edition box that contains roughly 100 Databases which does NOT have RS installed. Can we legally install RS on another (non-SQL) server without buying a SQL license, if it connects only to this SQL Server box If not, can we use a Standard Edition license for the RS box, and use it to connect to the EE box Installing RS on a separate server requires a separate license. (See How to License Reporting Services ). It is possible to install RS Standard Edition on a separate server and connect to you EE box. See SQL Server 2000 Reporting Services Deployment Guide for the differences between RS SE and EE. -Albert ...Show All

• SQL Server OK button doesn't Work In Report Manager RS2000

  Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1 with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2. My problem is that any page of the report manager with a "OK" button, that button doen't do nothing, it is enabled bu doesn't do any action. Can't figure this one out Need Help Thank's PS: Is did work early on this machine but stop working without notice, or any change at all. Hi, We have installed SQL Server 2005 with Reporting Service in a Windows 2003 Box. While working with the Reporting Manager through the browser we are gettting a strange problem. Whenever we are making any changes through Reporting Manager and trying to save the OK or Apply button is doing absolu ...Show All

• SQL Server The attribute key cannot be found

  I am using SQL Server 2005. My Data Source View and its Query is below: ============================ FactVehicle: SELECT KeyDateTime, UnitId, FuelCode FROM TestsVehicle DimFuelCode: SELECT FuelCode, FuelName FROM DimFuelCode DataSource View Data: =============== FactVehicle: (SELECT distinct FuelCode FROM TestsVehicle – This query result is below) FuelCode G NN E NG PP F C M D P PG B N ============================================ Note: I don’t want to do Analysis on G, NN, E, NG, PP, F, C Fuel Code ============================================ DimFuelCode (SELECT FuelCode, FuelName FROM DimFuelCode - This query result is below) FuelCode Fuel Name X XYZ PG PG P P N N M M D ...Show All

• Visual Studio Express Editions Toggle readonly property with button

  I used the following code to change the textboxes in my form from read to read only etc with a button. (Thanks Spotty) Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click For Each c As Control In Me.Controls If TypeOf (c) Is TextBox Then Dim currentcontrol As TextBox currentcontrol = c currentcontrol.ReadOnly = Not currentcontrol.ReadOnly '//Toggle readonly '//Change Formatting If currentcontrol.ReadOnly Then currentcontrol.BorderStyle = BorderStyle.None Else currentcontrol.BorderStyle = BorderStyle.FixedSingle End If End If Next End Sub I would now like to do something simi ...Show All

• SQL Server Data Flow Task in SSIS, and Oracle Schema More options

  Hi Guys, I have a question regarding SSIS and Oracle Our company has two major versions of products, and currently, I am working on this project to migrate data from version A of the product to version B of the product. The database schemas for two versions have huge differences, therefore we chose to use SSIS to migrate the data. We have a number of clients that are on Version 1, and we want to write one code base to migrate all clients' data from Version 1 to Version 2. And they are all on Oracle . In the SSIS , for each package I have two connections, ConnectionOne connects to the Oracle database for Version1, and ConnectionTwo connects to Version2. In a Dataflow task, I use an OLE DB Source to get data from Connecti ...Show All

• Visual Studio Crystal Reports and SQL Server Express

  Hi everyone i'm new in this forum and i have a few problems well to be hones a lot of problems creating Crystal Report using a DataSource from SQL Express i simply cant get connected to the database, i hope you can help and if you could give me step by step how to do it to see if i'am doing somthing wrong. i'm using Visual Studio Pro 2005 and SQL Server Express Description of my problem First i try to add a crystal report in the solution explorer... Named the crystal report ....follow the steps of the Report Wizard (so far so good) but the problem is when i get to the step that says "choose the data you want to report on" because i select Create New Connection then OLE DB (ADO), I select the provider "Microsoft OLE DB Provider for SQL" an ...Show All

• SQL Server windows auth or sql..

  When creating connections for source and destination in a package what is the recommended approach, window authenticatation or sql I will be deploying to filesystem, what would be best. this is my first ssis package, so pardon my ignorance. many thanks. kushpaw kushpaw wrote: When creating connections for source and destination in a package what is the recommended approach, window authenticatation or sql I will be deploying to filesystem, what would be best. this is my first ssis package, so pardon my ignorance. many thanks. kushpaw This is a question about SQL Server rather than SSIS but Windows Auth is generally considered to be best (or better) practice ...Show All

• Visual Studio Team System Account to use for setting up TFS for Workgroups

  From the Install CHM file: >>> TFSSETUP * Used to run Team Foundation Server Setup. ...... If you are installing the Team Foundation Server Workgroup Edition, adds this account to the Team Foundation Licensed Users group. For this reason, you should run Setup with your user account. >>> Are they saying that if I'm installing the TFS for Workgroup editon (which I am), I should NOT use the "TFSSETUP" account for the install but, instead, use my own domain account for the install TIA, barkingdog Yes, it is better to install with your own account, as workgroup edition has only 5 licensed users avaliable, and if you use TFSSetup account, it will be added ...Show All

• SQL Server Remove DC from Cluster Node

  We have: A Microsoft cluster, (SQL Failover cluster) with one node as the domain controller. The cluster was built off site and the domain name used is the same as our existing domain where we eventually need to install this cluster. We need: (At least I think we need:) To remove node 2 from the "cluster domain", DCPROMO node 1 and eliminate the "cluster domain". We then need to join the cluster (nodes) to the existing domain. We also need to recreate the accounts and groups used during installation. Questions: 1) What will happen to the "domain accounts" used when installing SQL2005 (Other than they will go away. I mean what adverse impact will that have on the installation ) 2) Will I have ...Show All