Re: Slow access on XP using ADO with ODBC to SQL Server 2000 - any ideas?

Just a thought but you might try changing the SQL server name in the
connection string to the server's IP address as a test. Also make sure that
tracing is turned off in Data Sources ODBC administrator.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Daniel Crichton" wrote:
| I've got one PC here running XP Pro SP2 that is acting "weird". I have an
| application that uses ADO via an ODBC DSN to do SELECTs and UPDATEs on
some
| records in a table. Until 2 days ago this application ran perfectly well
on
| this PC, but now runs very slowly (tests indicate over 100 times slower)
| than before. Switching to Named Pipes cures the problem, but I'd rather
try
| and keep all the machines here configured the same way using TCP/IP. All
| other XP Pro and 2000 Pro machines I've run this app on using TCP/IP works
| fine.
|
| Another application using the same database code, just dealing with a
| different set of records (actually has a larger ForwardOnly recordset in
| memory that it loops through to feed the recordset that does the SELECTs
and
| UPDATEs, around 12000 items compared to 4500 in the one that's running
| superslow), runs as quickly as expected using the same DSN when set to
| TCP/IP. This is really confusing me - I've checked everything I can think
of
| on the machine itself (firewall is off, updates applied, MDAC checks out,
| etc).
|
| I guess I'm looking for a way to check, and replace with originals, any
DLLs
| or other files that are used by the SQL Server ODBC driver over TCP/IP
that
| are not used when connecting via Named Pipes. Any ideas?
|
| Dan
|
|


.

Relevant Pages

  • Re: Error: SQL server does not exist or access is denied
    ... This is my connection string: ... >> several machines with no problems, the app runs perfectly. ... SQl Server does not exist or access denied' from source ...
    (microsoft.public.dotnet.framework.adonet)
  • Mobile 5 Emulator not Connecting to SQL Server
    ... We use TCP/IP to connect to SQL Server ... Mobile 5 SDK and can deploy it fine, but we get the dreaded "SQL Server ... not Found or Access Denied" on the Emulator. ... Since the connection string ...
    (microsoft.public.dotnet.framework.compactframework)
  • DSN registration programatically
    ... I have created code to create a DSN to a SQL Server DB. ... However on some machines it tries to link using Named ... Pipes instead of TCP/IP. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Problem connecting to SQL Server 2000 (only at runtime!)
    ... I am using TCP/IP. ... What bothers me is that I'm using that same connection string inside VS. ... >> connect to a remote SQL Server 2000. ...
    (microsoft.public.vsnet.general)
  • Re: Error: SQL server does not exist or access is denied
    ... >> What is your connection string? ... >>> the framework and installs it if necessary. ... >>> several machines with no problems, ... SQl Server does not exist or access denied' from ...
    (microsoft.public.dotnet.framework.adonet)