all groups > sql server connect > june 2007 >
You're in the

sql server connect

group:

Problems with "Local connections only"


Problems with "Local connections only" lalo_losla
6/25/2007 11:21:05 AM
sql server connect:
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
Re: Problems with "Local connections only" William (Bill) Vaughn
6/25/2007 12:38:55 PM
Let'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)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Re: Problems with "Local connections only" lalo_losla
6/26/2007 7:15:55 AM
Conn As ADODB.Connection

Conn.Open ODBCName, Login, Pwd
AddThis Social Bookmark Button