Saturday, February 25, 2012

Problems with "Local connections only"

Hello,
Our application is running very slow, we have an application installed
on (XP professional or Windows 2003) running SQL Server 2005 or
SQLExpress on the same pc.
We have realized that if we change "Local connections only" for "Local
and remote connections", our application (VB6) runs much faster
(Normally I'd say).
We need to run our application in the same computer where the server
is running with "Local connections only".
Can anyone help to us?
Thanks,
LasloLet's see your ConnectString.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"lalo_losla" <lalo_losla@.hotmail.com> wrote in message
news:1182795665.411020.31170@.c77g2000hse.googlegroups.com...
> Hello,
> Our application is running very slow, we have an application installed
> on (XP professional or Windows 2003) running SQL Server 2005 or
> SQLExpress on the same pc.
> We have realized that if we change "Local connections only" for "Local
> and remote connections", our application (VB6) runs much faster
> (Normally I'd say).
> We need to run our application in the same computer where the server
> is running with "Local connections only".
> Can anyone help to us?
> Thanks,
> Laslo
>|||Conn As ADODB.Connection
Conn.Open ODBCName, Login, Pwd

No comments:

Post a Comment