Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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?
Avatar of kristof1104
kristof1104
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
Avatar of Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Hi. I am using SQL Server 2008. woul this still apply?

Thanks
Avatar of kristof1104
kristof1104
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?
Avatar of Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

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"
ASKER CERTIFIED SOLUTION
Avatar of kristof1104
kristof1104
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 Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks very much. I am using a corporate firewall and the same computer
Avatar of kristof1104
kristof1104
Glad i could help!