Re: SQL Server connectivity
From: Doug Stoltz (NoSpam_at_MyEmail.com)
Date: 08/03/04
- Next message: Frank S: "SQL 7 Ent Man on Win 2003 errors"
- Previous message: Alan: "SQL Server connectivity"
- In reply to: Alan: "SQL Server connectivity"
- Next in thread: Alan: "Re: SQL Server connectivity"
- Reply: Alan: "Re: SQL Server connectivity"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 3 Aug 2004 17:59:42 -0400
Alan, I'd like to track the progress of your error. I've had similar issues
resolved unsuccessfully. However, I think I may have clue for you.
I feel like it must be something with the location of the cursors. Since
obviously network bandwidth is not the problem.
I suspect that you are using SERVER side cursors and your application has to
make round trips over the VPN tunnel to fetch each row. The ODBC/Attached
table connection is probably using CLIENT side cursors. (I think this is
required by ODBC framework). Look at the cursor location setting and set
for client side cursors and see if this helps. (At least it's something you
can try.)
Also, try running SQL profiler and see if this shows anything.
Keep me updated - Doug
"Alan" <Alan@discussions.microsoft.com> wrote in message
news:C61B0D08-D236-481E-B1D7-CB511DD6B9F9@microsoft.com...
> Hi,
> I am using ADO connection to a SQL Server ODBC to run a custom
application.
> The problem is that the SQL server was moved to another office and a VPN
tunnel was established to maintain connectibility.
> Now, when the application is run, it performs 15-20 times slower.
> I've tried many things and the only approach that solves this issue is
creating an access database and linking the tables through the same ODBC.
> I changed the connection to point to the odbc of the access database and
the application is flying. Even faster then when it was ran locally.
> Please help me identify what is the issue with the initial set up. I
wouldn't like to use the rigged setup I stumblled upon/
> Thanks
- Next message: Frank S: "SQL 7 Ent Man on Win 2003 errors"
- Previous message: Alan: "SQL Server connectivity"
- In reply to: Alan: "SQL Server connectivity"
- Next in thread: Alan: "Re: SQL Server connectivity"
- Reply: Alan: "Re: SQL Server connectivity"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
