[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

VB.net Excel add-in app with SQL backend slow on office network

Hi

I have built an Excel Add-in application that manipulates an online SQL database. It works well on my home internet and USB 3g connection, but the minute I connect to the internet in a smal office network the speed slows down dramatically. Is this something to do with the company firewall. Ho wdo I get around this?
0
Murray Brown
Asked:
Murray Brown
  • 4
  • 3
1 Solution
 
kristof1104Commented:
Are you using mySQL?

Then it could be a DNS problem. You can disable DNS host name lookups by starting mysqld with the --skip-name-resolve option in the configuration file.

Read here for more details: http://dev.mysql.com/doc/refman/5.0/en/dns.html

If you aren't using mySQL:

You can always ask the network admin to add an exception to the firewall
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. I am using SQL Server 2008. woul this still apply?

Thanks
0
 
kristof1104Commented:
No I don't think so, if the initial connection slow? or just the whole proccess?

Are you connecting to the DB through IP address or domainname?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi. Both I think. We use the following two servers that are equally slow

"Server=winsqlr01.cpt.wa.co.za;Database=Mmllx;Uid=xxxx;Password=xxxxx;"
 "Server=41.....128.100;Database=MagicBox_Doppio;Uid=xxxxx; Pwd=xxxxx"
0
 
kristof1104Commented:
Are you using the same computer to test your addin, if not try temporarily disabling all firewalls on the machine. if your addin works fast , add a new firewall rule to allow traffic on your port.

If you are using the same computer it probably is the corperate firewall, in which you need to ask the network admin to add the exception for you!
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much. I am using a corporate firewall and the same computer
0
 
kristof1104Commented:
Glad i could help!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now