We are trying to move from using SQL DMO to SMO in our COM+ based application, as we are dropping support for SQL Server 2000 and adding support for SQL Server 2008 in addition to SQL Server 2005. I have been reading around on this, and found this particular quip on this microsoft forum: "SMO is only supported in VB/C#.Net 2005. It r...
Are there any compatibility issues with running Visual Studio 6.0 (including Visual SourceSafe 6.0 Client), Visual Studio 2003 & Visual Studio 2008 on Windows Vista 64-bit? Can I interactively debug the applications with the Vista Web Server? Can I still make/compile projects? Is it correct to assume that Visual Studio 6.0 & 2003 will ...
As the title states, is there a way to prevent extra elements from showing up in VBA dynamic arrays when they are non-zero based? For example, when using code similar to the following: While Cells(ndx, 1).Value <> vbNullString ReDim Preserve data(1 To (UBound(data) + 1)) ndx = ndx + 1 Wend You have an extra empty array eleme...
I have a VB.net control that has an event: Public Event PassNames(ByVal names() as String) When the event triggered in VB6, I get the following error: "Function or interface marked as restriced, or the function uses an Automation type not supported in Visual Basic" Here is the event in VB6: Private Sub IteropControl1_PassNames(ByV...
I have a VB6.0 project with MDI parent and child form. Now I need to check spelling and grammar in few text boxes on that child form. Please help with code example. ...
Our clients use a vb6 version of our software. We are upgrading them to a .NET application written in C#... Is there less bulk using .net 2.0 than .net 3.5? My definition of less bulk would be: Smaller size, smaller installation time, etc. Most of them probably already have 2.0 anyway. I only ask because I would like to take advanta...
I'm comparing the results produced when i use the 'Make .exe' compared to when i run the exact same process using the exact same variables though the IDE vb 6 debugger. I've tried an array of different compiler options but to no avail. So my question is why would i get a difference between the debugger and the 'Make .exe'? have you eve...
I've been spoiled by Visual studio 2008 and Eclipse and have to do a little maintainence work on a VB6 app. Does anyone know of an alternative/ updated IDE for VB6? A rewrite is not an option I'm just fixing a couple of bugs and it's a big codebase. ...
I've run across the following line in a VB6 application. mobjParentWrkBk.ExcelWorkBook.Application.Selection.Insert Shift:=xlToRight Unfortunately Google and other search engines have not been very useful as they seem to omit the := part. What would be a C# equivalent? ...
I am a self taught vb6 programmer who uses DAO. Below is an example of a typical piece of code that I could churn out: Sub cmdMultiplier_Click() 'Button on form, user interface ' dim Rec1 as recordset dim strSQL as string strSQL = "select * from tblCustomers where ID = " & CurrentCustomerID 'inline SQL ' set rec1 = GlobalDat...
I am trying to extract a table of values from an excel (2003) spreadsheet using vb6, the result of which needs to be stored in a (adodb) recordset. The table looks like this: Name Option.1 Option.2 Option.3 Option.4 Option.5 Option.6 ----------------------------------------------------------------- Name1 2 ...
We have inherited VB6 dll which we need to make changes to. We have the code but don't have VB6 compiler. How can we rebuild the dll? Where can we download the VB6 environment/compiler from? Thanks in advance. ...
I am working with some input that is in the possible forms $1,200 20 cents/ inch $10 Is there a way to parse these to numbers in VB? Also printing these numbers? EDIT: Regular expressions would be great. EDIT: VB 6 in particular ...
I am working on a VB.NET WinForms app that was "upgraded" by Visual Studio (originally 1.0 or 1.1) from VB6 code (which was itself upgraded from VB5). Except for the few new forms I've created since taking over maintenance of this app, all of the forms in the application have a method called DefInstance which allows you to grab an in-mem...
This isn't a question but I thought I'd start a thread where links to exceptionally useful (and widely applicable) vb6 code could be placed. My choice is by someone called John Korejwa and is located on planet sourcecode at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=50065&lngWId=1 Basically what it does i...
I have created a .NET DLL which makes some methods COM visible. One method is problematic. It looks like this: bool Foo(byte[] a, ref byte[] b, string c, ref string d) VB6 gives a compile error when I attempt to call the method: Function or interface marked as restricted, or the function uses an Automation type not supported ...
In VB6, I have a DTPicker control on a form. (The DTPicker is the calendar date/time selector, included in Microsoft Windows Common Controls-2 6.0, available from the Components dialog.) While there are many properties to affect the colors of the calendar when it's dropped down, there is no property that allows changing the color of the...
Two questions: Can someone point me to unbiased data that compares .NET performance to VB 6 performance? I have searched but it is surprisingly difficult to find. What is the best way to compare .NET performance to VB 6 performance as an app behaves at a customer's site? We have a WindowsForms, client-server app (written for 2.0, upg...
Making a small app, and I want a function to execute 50% of the time. So if I were to dbl click the exe half the time the function would execute, and the other half it wouldn't. I can't seem to find anyway to easily do this, the one solution I tried seemed to determine the chance on compile rather than on run. Thanks in advance! ...
I have a client server application that sends XML over TCP/IP from client to server and then broadcast out to other clients. How do i know at what the minimun size of the XML that would warrant a performance improvement by compression the XML rather than sending over the regular stream. Are there any good metrics on this or examples? ...