SQL Server connectivity

From: Alan (Alan_at_discussions.microsoft.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 14:05:02 -0700

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

Relevant Pages

  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()) er
    ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ... SQL Server instance and see if there is a connection reset when this issue ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... remote connection. ... should I just check named pipes only or both TCP/IP and ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ...
    (microsoft.public.sqlserver.connect)
  • Re: Using SQL Server Express on Shared PC
    ... you don't need to install SSMS or VS on the client system. ... using ODBC you're making the job of getting connected more difficult. ... ODBC requires either a REGISTERED DSN, a file-based DSN or a "DSN-less" connection. ... You also need to configure the Network-shared SQL Server service to permit access by whatever credentials you have chosen. ...
    (microsoft.public.sqlserver.connect)
Quantcast