Link to home
Start Free TrialLog in
Avatar of Bob Schneider
Bob SchneiderFlag for United States of America

asked on

Connecting w/ VB6 vs Browser

I have a timing service that uses a vb6 application to time races on site.  I can run it off the the db on the local machine (in the event that I do not have any connectivity at the race) or off of the db on the server.  My question is that, even when I have connectivity, the vb app runs very slowly in comparison.  Probably too slowly to ever use as a reasonable option.  Here is my connection string:

 
    Set m_oConn = New ADODB.Connection
    
    If sWhichSrvr = "Remote" Then
        m_oConn.Open "Provider=SQLNCLI10;Server=216.185.199.1,1433\SQLExpress;Database=CCMeet;Uid=uid;Pwd=pwd;"
    Else
        m_oConn.Open "Provider=SQLNCLI10;Server=VIRA-5\SQLExpress;Database=CCMeet;Trusted_Connection=yes;"
    End If

Open in new window

SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bob Schneider

ASKER

Thank you.  The timing is all done locally but it ultimately goes on the web server for access to the online results by the world at large.  I can work offline and then upload the results when all is complete and I am back to "the office" or I can work directly off of the server db.  My question was that the local software lags dramatically if it is accessing the data via the server as compared to accessing the data on the local machine.  Just wondering if this is an inherent issue with a vb6 app/connection and if there is a better (quicker way) to connect my vb6 software to the data on the server.

My web interface (using basically vbscript) retrieves, processes and submits data much more quickly than my vb6 app does.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I will do that but, again, the data is the same...it is just being accessed by two different means: the web via a browser and web site, and via a software app written in vb6.
It is just sooooo sloooowwww when using vb6 as opposed to asp/web browser.  The queries are the exact same and the databases are "identical" in the sense that I copy the one on the server to my local machine.  Then I can run my vb6 software or the web app, but the web app is only capable of a fraction of the tasks.  I am trying to avoid re-writing everything to the asp site.  From a data standpoint, the connection strings are also very similar.  It actually connects pretty well but when it comes time to actually process the data, the vb6 app takes three or four times as long (or more).  It makes it so I can't run the app off of the server which sucks because then I can't provide real-time results for participants.

Any final thoughts would be much appreciated.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Man I really appreciate the help!!
Thank you! I am interested to know what you found.  Post back here what you ended up doing!
Will do...it is time for me to branch out a little in terms of my scope of capability.  This will be a good chance to do that.
I think this is one of those things that sounds very easy on the outside until you get into it.