Issues with application on Windows 8 machines

I have written a winforms application that uploads and downloads information while online.  Meaning, the user logs in and then downloads information.  They work in it offline and the uploads it back to the server once online again.  This works great in Windows 7.  Meaning the transmission time is about 1 second or so.   However, for those on Windows 8, it is taking up to 20 minutes!!!  

Can anyone give me an idea on what may be happening or where I need to look to solve this issue?

Thanks
bobnieldsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Windows 8 / 8.1 uses essentially the same network methodology as Windows 7 and works just as fast or faster.

Can you create data with your application, save it, and upload it separately?  Does that change anything or shed any light?

I have written a winforms application <-- Is this legacy in terms of Windows 8?  Perhaps the application needs re-writing / modernizing.
0
bobnieldsAuthor Commented:
I do create data and save it on a remote database.  The user then uploads when they are back online.  

It was originally developed in VS 2008.  We updated/rebuilt in vs 2012.  

All I am doing is reading the remote database and inserting into the server database (sql server) using embedded SQL.  Once again, when in Windows 7 it takes about 1 - 10 seconds based on the amount of data.  When in Windows 8....it is taking about 20 minutes.
0
JohnBusiness Consultant (Owner)Commented:
So a file (just a file, and not part of SQL) takes 20 minutes to upload on Windows 8.  

I know it takes longer in SQL as you have twice noted. Is there a way to separate the file from SQL so that you can possibly see what is the issue?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

bobnieldsAuthor Commented:
Not sure what you mean by file.

The winform app does this:

1)  The user downloads a service order which he is going to work.  To download, he logins to the server database and downloads his service order.  My code reads the server database and inserts that information (with SQL) in an remote database (Access).  

2)  When they are finished with their work at the end of the day.  The technician (user) gets back online and uploads the service order back to the server database.   Again...all I do is read the remote database and either insert or update the records on the server database.  

This works great in Windows 7.  Each service order takes about 5 seconds to download and upload based on amount of data.   Windows 8....no luck.

It seems like there is something blocking it.  I tried to get on the machines they are using and actually turned off the firewall to see if that is the issue......didn't help.
0
JohnBusiness Consultant (Owner)Commented:
There must be some incompatibility between the database and Windows 8. I cannot really see what and you gave us a much better description here.  Also your last post means the data is not a file, so forget that suggestion.

It might be worth your while to get a packet sniffer to look at one computer and see what is being transmitted.

I think SQL has logging. Can you turn it on and see what the logs say?

Also look in Windows 8 Event View right after one transfer and look for errors.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David Johnson, CD, MVPOwnerCommented:
The user downloads a service order which he is going to work.  To download, he logins to the server database and downloads his service order.  My code reads the server database and inserts that information (with SQL) in an remote database (Access).  

Don't you mean save it in a LOCAL database you then want to sync the local database with the network database (domain) ?  If they are using a 'remote' database then why aren't they using the domain database ?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.