Re: ODBC Over WAN



This is absolutely not true. While accessing data via ODBC over a WAN is
slow and cumbersome (made worse by slow connections), if data packets are
lost its not a factor of ODBC. Of course, using efficient queries via ODBC
improves the transfer time.

We use ODBC connections across our WAN every day, all day.

Ross

"David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ABF6A633-2692-4367-BD89-8AE0B8E35227@xxxxxxxxxxxxxxxx
I have been told by our consultant that we cannot access our SQL Server
over
the WAN without corrupting our data, is this true?

Thanks for any help,
David


.



Relevant Pages

  • Re: ODBC TIme Out MSACCESS<-SQL2K
    ... Gruss ... > ich habe ein Time Out Problem bei einer ODBC Verbindung. ... die WAN Leitung ist einwandfrei und hat gute Antwortzeiten. ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • ODBC TIme Out MSACCESS<-SQL2K
    ... Ich habe bereits bei der ODBC Connection die TimeOut Schwelle auf 180 sek ... die WAN Leitung ist einwandfrei und hat gute Antwortzeiten. ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • Using Excel OS 9 to connect to a WAN data source
    ... Microsoft's Merant ODBC 3.5.1 software patch as the ODBC connectivity ... Excel/Query connects in seconds after I enter ... However if I go into my ODBC DSN and change the Server Name and Server ... Address to the WAN ip of my Win2000/SQL 2000 server, ...
    (microsoft.public.mac.office.excel)
  • Using Excel OS 9 to connect to a WAN data source
    ... Microsoft's Merant ODBC 3.5.1 software patch as the ODBC connectivity ... Excel/Query connects in seconds after I enter ... However if I go into my ODBC DSN and change the Server Name and Server ... Address to the WAN ip of my Win2000/SQL 2000 server, ...
    (microsoft.public.excel.misc)
  • Using Excel OS 9 to connect to a WAN data source
    ... Microsoft's Merant ODBC 3.5.1 software patch as the ODBC connectivity ... Excel/Query connects in seconds after I enter ... However if I go into my ODBC DSN and change the Server Name and Server ... Address to the WAN ip of my Win2000/SQL 2000 server, ...
    (microsoft.public.sqlserver.clients)

Loading