SEO

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

Not really. Can be true if you are accessing an Access database (MDB or
ACCDB database file) as the backend without using a remote desktop solution
such as Terminal Server or Thinsoft. In the case of SQL-Server, it's false
in all cases; excerpt maybe for the case of logical corruption if you don't
use transaction. However, if you don't use transaction, the possibility of
getting logical corruption would exist even in the cases where you wouldn't
be on the WAN.

A logical corruption is a situation where each of the individual records in
the database are physically OK but the relation between them is not; for
example when some of the details of an order are missing. Transactions are
used to keep the database in a logically coherent state; even in the case of
a communication failure. (BTW, this doesn't mean that all transactions will
necessarily succeed and that you cannot lose some information.)

Of course, even with the use of transactions, there is still the possibility
of getting corruption in the dabase file(s) because of an I/O problem or
other physical problem but this situation exists wheither you are on the WAN
or not.

Maybe your consultant was thinking about the possibility of losing some
information in case of a communication failure (for example, you start
entering an order but the communication if lost before you have time to
finish it) but even to this problem, there are solutions.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"David" <David@discussions.microsoft.com> wrote in message
news:ABF6A633-2692-4367-BD89-8AE0B8E35227@microsoft.com...
>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

Sylvain,
Thank you for you response...

David

"Sylvain Lafontaine" wrote:

> Not really. Can be true if you are accessing an Access database (MDB or
> ACCDB database file) as the backend without using a remote desktop solution
> such as Terminal Server or Thinsoft. In the case of SQL-Server, it's false
> in all cases; excerpt maybe for the case of logical corruption if you don't
> use transaction. However, if you don't use transaction, the possibility of
> getting logical corruption would exist even in the cases where you wouldn't
> be on the WAN.
>
> A logical corruption is a situation where each of the individual records in
> the database are physically OK but the relation between them is not; for
> example when some of the details of an order are missing. Transactions are
> used to keep the database in a logically coherent state; even in the case of
> a communication failure. (BTW, this doesn't mean that all transactions will
> necessarily succeed and that you cannot lose some information.)
>
> Of course, even with the use of transactions, there is still the possibility
> of getting corruption in the dabase file(s) because of an I/O problem or
> other physical problem but this situation exists wheither you are on the WAN
> or not.
>
> Maybe your consultant was thinking about the possibility of losing some
> information in case of a communication failure (for example, you start
> entering an order but the communication if lost before you have time to
> finish it) but even to this problem, there are solutions.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "David" <David@discussions.microsoft.com> wrote in message
> news:ABF6A633-2692-4367-BD89-8AE0B8E35227@microsoft.com...
> >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
>
>
>

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@discussions.microsoft.com> wrote in message
news:ABF6A633-2692-4367-BD89-8AE0B8E35227@microsoft.com...
>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