VB Application Slow in VISTA

[SVK12]

Hi,

I am trying to run a VB 6.0 application in Windows Vista. I have tried in both Vista Home and Vista Business and it runs extremely slow on both the OS. I have tried running it in Vista under Windows Classic mode and it is still slow. It runs very fast on Windows XP.

1. I have enclosed all the references and controls that I have used in the application.
2. The application involves lots of reads and writes to SQL Server database and I have a feeling that data access performance has gone down significantly.
3. I have recursive call to populate a tree view control with about 300 nodes that runs very fast on XP but takes forever in Vista.
4. I have already tried running the application using the Vista compatibility manager with no success
5. I am running this on a machine with 3 GB ram and P8400 processor.

References:
#1.0#0#E:\WINDOWS\system32\scrrun.dll#Microsoft Scripting Runtime
#2.8#0#E:\Program Files\Common Files\system\ado\msado15.dll#Microsoft ActiveX Data Objects 2.8 Library
#1.0#0#E:\WINDOWS\system32\MSBIND.DLL#Microsoft Data Binding Collection
#1.0#0#E:\WINDOWS\system32\MSSTDFMT.DLL#Microsoft Data Formatting Object Library
#8.1#0#E:\Program Files\Microsoft Office\Office\MSWORD9.OLB#Microsoft Word 9.0 Object Library
#9.0#0#E:\PROGRA~1\MICROS~2\Office\msoutl9.olb#Microsoft Outlook 9.0 Object Library
#3.0#0#E:\WINDOWS\system32\msxml3.dll#Microsoft XML, v3.0
#2.8#0#E:\Program Files\Common Files\System\ado\msadox.dll#Microsoft ADO Ext. 2.8 for DDL and Security

Objects/Controls:
#1.1#0; TABCTL32.OCX
#1.1#0; MSMASK32.OCX
#1.0#0; Msflxgrd.ocx
#1.3#0; comctl32.ocx
#1.1#0; MSMAPI32.OCX
#7.0#0; mscal.ocx
#1.0#0; MSDATGRD.OCX
#6.0#0; MSADODC.OCX
#1.2#0; RICHTX32.OCX
#1.2#0; COMDLG32.OCX
#2.0#0; MSCOMCTL.OCX
#6.0#0; MSHFLXGD.OCX

Any help would be greatly appreciated!

Thanks,

Sachin
Removed By Mod

[Hack]

Welcome to the forums.

I have edited your post and removed your email address.

You should never post your email address in an open post on an open forum. Mail spam bots can pick that up and before you know it, your mailbox is full of junk mail. If you wish to share your email address with other forum members, please do so via our PM system.

In addition, we prefer all answers to questions be publically posted rather than sent via EMail or PM. That way, everyone with a similar problem can benefit.

Thanks.

[sd.k]

Hi Guys,

I'm also having a simlar problem.

My EXEs work great on XP Systems, but perform sluggishly on Vista/windows 7 systems, espevcially the parts that access SQL server (ADO 2.6/7/8).

However, XP in Virtual Box/Server Mode inside Vista/Win7 perform great !

Looks like some networking issues in Vista/Win7 OS.

Any suggestions from VB6 pros out there ?

Regards,
SDK

[Resilience]

When i use vb apps on vista it pretty much freezes if i have to get a pixel color. Which is due to the vista desktop composition, however after turning that off my apps work perfectly fine on vista.

Have you tried any of the options under the compatibility tab in the properties? It has the option of running the program in compatibility mode for windows XP.

[sd.k]

Hi,

Thanks for your suggestions, but the problem I am facing is not the UI.

EXEs that do not have network routines work great. When I say network acessN I mean ado code that accesses sql servers and retrieves data or fires some. Stored procdures. Now these parts are REALLY slow on Vista and windows 7.

Otheriwse, my developement platform is VB6 SP5 on VISTA SP2, acessing SQL servers 2000/2005 on windows 2000i2003 servers.

I have turned of destop compostion for the vb6 ide on vista and the UI at development time is very fast (as good as XP), so code speed on such operations not an issue.

I have evn implmented turing off diff compression on vista but no improvemnt. I have even tried the netsh operations to disbale some vista gizmos for neytworking as suggested by os experts on the web, but still applications network performncae on vista is slow !

Anyone ?

Regds,
Sdk

[sd.k]

Hi All,

I finally managed to sort the problem.

The issue is the connection string: if I use IP address rather than HOST NAME, then the connectin is pretty fast - as goods as in XP.

Looks like some issue in Vista and Win7 that is causing delay in DNS Lookups or something - still looking for way to sort this out, but at leats my main worry is gone: use IP Address and life is normal !

Thanks all !

Regards.
SDK

[dilettante]

This seems really odd. If it were related to DNS lookups I'd think even most Web browsing would be slow.

I've been using Vista to develop VB6 progams for several years now and I test on Windows 7 extensively. I'm not seeing a problem with connection string name resolution, nor any issue with database access across networks.

I suspect there is still something else going on here, but I'm puzzled that using an IP address makes any significant difference. It sounds more like a problem with the version of the OLEDB Provider you are using... or are you trying to use the old ODBC drivers through the MSDSQL shim layer (OLEDB Provider for ODBC)?

[maqmaq]

Hi sd.k
I am encountering the same problem when we upgraded to Windows Vista
I am reading my Access data base from the share server \\company\data\training.mdb

Do you think this is related to same cause that you have
Appreciate your reply and suggestion
Thanks