Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Showing posts with label app. Show all posts
Showing posts with label app. Show all posts
Monday, March 26, 2012
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
sql
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
sql
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> > use merge replication to MSDE databases, create pull subscriptions
> > managed by Windows Synchronization Manager.
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
--
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>> use merge replication to MSDE databases, create pull subscriptions
>> managed by Windows Synchronization Manager.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> > use merge replication to MSDE databases, create pull subscriptions
> > managed by Windows Synchronization Manager.
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
--
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>> use merge replication to MSDE databases, create pull subscriptions
>> managed by Windows Synchronization Manager.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make thi
s
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>sql
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make thi
s
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>sql
Offline Client
Hi
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032271522&EventCategory=3&culture=en-US&CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
RegardsJohn wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032271522&EventCategory=3&culture=en-US&CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032271522&EventCategory=3&culture=en-US&CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>sql
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032271522&EventCategory=3&culture=en-US&CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
RegardsJohn wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032271522&EventCategory=3&culture=en-US&CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032271522&EventCategory=3&culture=en-US&CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>sql
Offline Client
Hi
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/We...CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
Regards
John wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/We...CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
Regards
John wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>
Offline Client
Hi
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/We...CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
Regards
John wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/We...CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
Regards
John wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/We...CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>
Friday, March 23, 2012
Offline Client
Hi
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/W...&CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
RegardsJohn wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/W...&CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/W...&CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>
I need to develop an app in vb 2005 which can work in both offline and
online modes and will be running on client laptops. I have listened to the
following web cast;
http://msevents.microsoft.com/CUI/W...&CountryCode=US
What I need to know is, do the laptops need to have a local version of sql
server (mobile, express etc.) to accomplish the offline mode?
Thanks
RegardsJohn wrote:
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened
> to the following web cast;
> http://msevents.microsoft.com/CUI/W...&CountryCode=US
> What I need to know is, do the laptops need to have a local version
> of sql server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
You can use Microsoft SQL Server 2005 Express for the clients. That
version of SQL Server is free.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||John,
It depends on what you want to be able to do in offline mode.
1. Are you planning on using SQL-Server merge replication to subscribe for
the data so that its easy to offline and then merge any changes later?
Note: this may involve a large investment in time to get it right.
2. Are you planning on keeping some data in a local database and still
support editing? MSDE or the upcoming SQL-Server Express might be the
solution here. Note: there are some catches to using MSDE
3. Are you planning on keeping some data in local storage, but only require
read-only access. Depending on the amount of data, MSDE or SQL-Server
Express might be overkill. For small amounts of data you might consider
storing the data in Access or even persisting the a DataSet to XML and using
something like the QueryADataSet assembly I've been developing for providing
query capability while offline.
Depsite Microsoft's best intentions, MSDE and/or SQL-Server Express edition
aren't always the best solution to a problem.
Hope this helps
Adrian Moore
http://www.queryadataset.com
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uYezXwqbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to develop an app in vb 2005 which can work in both offline and
> online modes and will be running on client laptops. I have listened to the
> following web cast;
> http://msevents.microsoft.com/CUI/W...&CountryCode=US
> What I need to know is, do the laptops need to have a local version of sql
> server (mobile, express etc.) to accomplish the offline mode?
> Thanks
> Regards
>
Monday, March 19, 2012
Odd ASP buffer/cache problem?
I am working with code I did not write for a web app that used to run
on an Access database. Due to performance problems I'm trying to move
the app to a different server running SQL Server 2000 SP4, running on
Server 2003 with MDAC 2.8 SP2.
On the new server, one of the queries is failing in an odd way.
Roughly, the query is
select * from a, b where a.1 = b.1 and b.2 = x
This is old fashioned ASP code using ADO.Recordsets. One of the columns
I should be getting from the query is called "Number_Sections".
sql = the query
set cRS = dbCon.exectue( sql )
somevar = cRS("Number_Sections")
cRS("Number_Sections") is returning NULL even though the column in the
database is not null. If I run the query using the SQL Analyer on the
server itself, the column is indeed populated as I expect.
cRS.Fields("Number_Sections") and cRS.Fields.Item("Number_Sections")
also return NULL.
However, while trying to debug I threw in this code:
For zz = 0 to cRS.Fields.Count-1
response.write cRS.Fields.Item(zz).Name & " = " &
cRS.Fields.Item(zz).value & "<br>"
Next
After running through this loop, which prints out all 47 column names
and values *correctly*, cRS("Number_Sections") suddenly works. Take out
the loop and it stops working again.
This sounds like some kind of buffering problem to me, but I'm not
familiar enough with Microsoft products to know where I should be
looking for some setting to fix the problem. Is it ASP and IIS? Is it
SQL Server? I haven't been able to find any settings that look like
they address this issue and searching the MS Knowledge base hasn't
turned up anything helpful either.
Has anyone else seen this behavior? Can anyone point me in the right
direction to find a more graceful solution that leaving the for loop in
and setting the string to some dummy variable instead of sending it to
the response object?
Thanks.
-SeanStop using SELECT *. Do you really need 47 columns? If this column exists
in both a and b, then either alias it or only include it once. Another
thing you can try is somevar = cRS(n) where n is the 0-based ordinal
position of that column (which will be fun to figure out if you continue to
insist using SELECT *).
I have never seen this issue but without a better example, DDL/sample
data/code and a repro, it's tough to guess at what is happening.
<usenet@.dezynworks.com> wrote in message
news:1138651333.119837.167610@.f14g2000cwb.googlegroups.com...
>I am working with code I did not write for a web app that used to run
> on an Access database. Due to performance problems I'm trying to move
> the app to a different server running SQL Server 2000 SP4, running on
> Server 2003 with MDAC 2.8 SP2.
> On the new server, one of the queries is failing in an odd way.
> Roughly, the query is
> select * from a, b where a.1 = b.1 and b.2 = x
> This is old fashioned ASP code using ADO.Recordsets. One of the columns
> I should be getting from the query is called "Number_Sections".
> sql = the query
> set cRS = dbCon.exectue( sql )
> somevar = cRS("Number_Sections")
> cRS("Number_Sections") is returning NULL even though the column in the
> database is not null. If I run the query using the SQL Analyer on the
> server itself, the column is indeed populated as I expect.
> cRS.Fields("Number_Sections") and cRS.Fields.Item("Number_Sections")
> also return NULL.
> However, while trying to debug I threw in this code:
> For zz = 0 to cRS.Fields.Count-1
> response.write cRS.Fields.Item(zz).Name & " = " &
> cRS.Fields.Item(zz).value & "<br>"
> Next
> After running through this loop, which prints out all 47 column names
> and values *correctly*, cRS("Number_Sections") suddenly works. Take out
> the loop and it stops working again.
> This sounds like some kind of buffering problem to me, but I'm not
> familiar enough with Microsoft products to know where I should be
> looking for some setting to fix the problem. Is it ASP and IIS? Is it
> SQL Server? I haven't been able to find any settings that look like
> they address this issue and searching the MS Knowledge base hasn't
> turned up anything helpful either.
> Has anyone else seen this behavior? Can anyone point me in the right
> direction to find a more graceful solution that leaving the for loop in
> and setting the string to some dummy variable instead of sending it to
> the response object?
> Thanks.
> -Sean
>|||First, what you are describing sounds like an ASP coding issue, and not a
SQL Server issue. You would have better luck posting on an ASP newsgroup.
However, if you post more of your code, starting with where you define
dbCon(less the actual connection string of course), and ending with closing
your connection, folks will be able to offer more advice.
It sounds to me like you are not properly looping through your dataset, but
I can only guess without seeing the actual code.
<usenet@.dezynworks.com> wrote in message
news:1138651333.119837.167610@.f14g2000cwb.googlegroups.com...
> I am working with code I did not write for a web app that used to run
> on an Access database. Due to performance problems I'm trying to move
> the app to a different server running SQL Server 2000 SP4, running on
> Server 2003 with MDAC 2.8 SP2.
> On the new server, one of the queries is failing in an odd way.
> Roughly, the query is
> select * from a, b where a.1 = b.1 and b.2 = x
> This is old fashioned ASP code using ADO.Recordsets. One of the columns
> I should be getting from the query is called "Number_Sections".
> sql = the query
> set cRS = dbCon.exectue( sql )
> somevar = cRS("Number_Sections")
> cRS("Number_Sections") is returning NULL even though the column in the
> database is not null. If I run the query using the SQL Analyer on the
> server itself, the column is indeed populated as I expect.
> cRS.Fields("Number_Sections") and cRS.Fields.Item("Number_Sections")
> also return NULL.
> However, while trying to debug I threw in this code:
> For zz = 0 to cRS.Fields.Count-1
> response.write cRS.Fields.Item(zz).Name & " = " &
> cRS.Fields.Item(zz).value & "<br>"
> Next
> After running through this loop, which prints out all 47 column names
> and values *correctly*, cRS("Number_Sections") suddenly works. Take out
> the loop and it stops working again.
> This sounds like some kind of buffering problem to me, but I'm not
> familiar enough with Microsoft products to know where I should be
> looking for some setting to fix the problem. Is it ASP and IIS? Is it
> SQL Server? I haven't been able to find any settings that look like
> they address this issue and searching the MS Knowledge base hasn't
> turned up anything helpful either.
> Has anyone else seen this behavior? Can anyone point me in the right
> direction to find a more graceful solution that leaving the for loop in
> and setting the string to some dummy variable instead of sending it to
> the response object?
> Thanks.
> -Sean
>
on an Access database. Due to performance problems I'm trying to move
the app to a different server running SQL Server 2000 SP4, running on
Server 2003 with MDAC 2.8 SP2.
On the new server, one of the queries is failing in an odd way.
Roughly, the query is
select * from a, b where a.1 = b.1 and b.2 = x
This is old fashioned ASP code using ADO.Recordsets. One of the columns
I should be getting from the query is called "Number_Sections".
sql = the query
set cRS = dbCon.exectue( sql )
somevar = cRS("Number_Sections")
cRS("Number_Sections") is returning NULL even though the column in the
database is not null. If I run the query using the SQL Analyer on the
server itself, the column is indeed populated as I expect.
cRS.Fields("Number_Sections") and cRS.Fields.Item("Number_Sections")
also return NULL.
However, while trying to debug I threw in this code:
For zz = 0 to cRS.Fields.Count-1
response.write cRS.Fields.Item(zz).Name & " = " &
cRS.Fields.Item(zz).value & "<br>"
Next
After running through this loop, which prints out all 47 column names
and values *correctly*, cRS("Number_Sections") suddenly works. Take out
the loop and it stops working again.
This sounds like some kind of buffering problem to me, but I'm not
familiar enough with Microsoft products to know where I should be
looking for some setting to fix the problem. Is it ASP and IIS? Is it
SQL Server? I haven't been able to find any settings that look like
they address this issue and searching the MS Knowledge base hasn't
turned up anything helpful either.
Has anyone else seen this behavior? Can anyone point me in the right
direction to find a more graceful solution that leaving the for loop in
and setting the string to some dummy variable instead of sending it to
the response object?
Thanks.
-SeanStop using SELECT *. Do you really need 47 columns? If this column exists
in both a and b, then either alias it or only include it once. Another
thing you can try is somevar = cRS(n) where n is the 0-based ordinal
position of that column (which will be fun to figure out if you continue to
insist using SELECT *).
I have never seen this issue but without a better example, DDL/sample
data/code and a repro, it's tough to guess at what is happening.
<usenet@.dezynworks.com> wrote in message
news:1138651333.119837.167610@.f14g2000cwb.googlegroups.com...
>I am working with code I did not write for a web app that used to run
> on an Access database. Due to performance problems I'm trying to move
> the app to a different server running SQL Server 2000 SP4, running on
> Server 2003 with MDAC 2.8 SP2.
> On the new server, one of the queries is failing in an odd way.
> Roughly, the query is
> select * from a, b where a.1 = b.1 and b.2 = x
> This is old fashioned ASP code using ADO.Recordsets. One of the columns
> I should be getting from the query is called "Number_Sections".
> sql = the query
> set cRS = dbCon.exectue( sql )
> somevar = cRS("Number_Sections")
> cRS("Number_Sections") is returning NULL even though the column in the
> database is not null. If I run the query using the SQL Analyer on the
> server itself, the column is indeed populated as I expect.
> cRS.Fields("Number_Sections") and cRS.Fields.Item("Number_Sections")
> also return NULL.
> However, while trying to debug I threw in this code:
> For zz = 0 to cRS.Fields.Count-1
> response.write cRS.Fields.Item(zz).Name & " = " &
> cRS.Fields.Item(zz).value & "<br>"
> Next
> After running through this loop, which prints out all 47 column names
> and values *correctly*, cRS("Number_Sections") suddenly works. Take out
> the loop and it stops working again.
> This sounds like some kind of buffering problem to me, but I'm not
> familiar enough with Microsoft products to know where I should be
> looking for some setting to fix the problem. Is it ASP and IIS? Is it
> SQL Server? I haven't been able to find any settings that look like
> they address this issue and searching the MS Knowledge base hasn't
> turned up anything helpful either.
> Has anyone else seen this behavior? Can anyone point me in the right
> direction to find a more graceful solution that leaving the for loop in
> and setting the string to some dummy variable instead of sending it to
> the response object?
> Thanks.
> -Sean
>|||First, what you are describing sounds like an ASP coding issue, and not a
SQL Server issue. You would have better luck posting on an ASP newsgroup.
However, if you post more of your code, starting with where you define
dbCon(less the actual connection string of course), and ending with closing
your connection, folks will be able to offer more advice.
It sounds to me like you are not properly looping through your dataset, but
I can only guess without seeing the actual code.
<usenet@.dezynworks.com> wrote in message
news:1138651333.119837.167610@.f14g2000cwb.googlegroups.com...
> I am working with code I did not write for a web app that used to run
> on an Access database. Due to performance problems I'm trying to move
> the app to a different server running SQL Server 2000 SP4, running on
> Server 2003 with MDAC 2.8 SP2.
> On the new server, one of the queries is failing in an odd way.
> Roughly, the query is
> select * from a, b where a.1 = b.1 and b.2 = x
> This is old fashioned ASP code using ADO.Recordsets. One of the columns
> I should be getting from the query is called "Number_Sections".
> sql = the query
> set cRS = dbCon.exectue( sql )
> somevar = cRS("Number_Sections")
> cRS("Number_Sections") is returning NULL even though the column in the
> database is not null. If I run the query using the SQL Analyer on the
> server itself, the column is indeed populated as I expect.
> cRS.Fields("Number_Sections") and cRS.Fields.Item("Number_Sections")
> also return NULL.
> However, while trying to debug I threw in this code:
> For zz = 0 to cRS.Fields.Count-1
> response.write cRS.Fields.Item(zz).Name & " = " &
> cRS.Fields.Item(zz).value & "<br>"
> Next
> After running through this loop, which prints out all 47 column names
> and values *correctly*, cRS("Number_Sections") suddenly works. Take out
> the loop and it stops working again.
> This sounds like some kind of buffering problem to me, but I'm not
> familiar enough with Microsoft products to know where I should be
> looking for some setting to fix the problem. Is it ASP and IIS? Is it
> SQL Server? I haven't been able to find any settings that look like
> they address this issue and searching the MS Knowledge base hasn't
> turned up anything helpful either.
> Has anyone else seen this behavior? Can anyone point me in the right
> direction to find a more graceful solution that leaving the for loop in
> and setting the string to some dummy variable instead of sending it to
> the response object?
> Thanks.
> -Sean
>
Monday, March 12, 2012
ODBC Write Failures
I've got an odd occasonal problem when writing to our server. In two
different applications, one an access app, and the other VB6 we will
experience a condition where we are able to read data, but when we attempt
to save the data we get ODBC timeouts. When this occurs, I can "fix" the
problem by going into one of the tables of the database in question and
modifying any value.
Configuration is a dual Xeon with 2gb of memory running SQL Server 2000.
Both databases are on this system and are accessed via different DSNs. One
is a web app, and is accessed by com dlls, the other is an app that was
created in MS Access and then modified so that it gets its data from linked
tables.
Any insite, or even better a good description of troublshooting techniques
would be appreciated.
Sam RobinsonHi Sam,
According to your description, I am not sure what your problem is. I would
like you to provide the following information so that I can narrow down
this issue.
1. Please provide me with the detailed error message. To do this, you can
take a screenshot. Please send it to me at v-yshao@.microsoft.com. For
additional information regarding how to obtain the screen shot, please
review [Item 1].
2. How did you read and write data with Access to SQL Server, via a linked
table or programming? Can you describe it in detailed?
3. I would like to know when the error occurred. It seems that the error
occurred when you updated the table on SQL Server. Did the error message
occur when you connected to SQL Server?
4. When the error occurs again, please perform the problematic SQL
statements using Query Analyzer. Does the same error message occur again?
It helps us to identify the problem related to the SQL Server including SQL
statements and your VB code.
5. Please provide the SQL Server error log (usually under C:\Program
Files\Microsoft SQL Server\MSSQL\LOG)
On the SQL Server side, there is a query wait option. This query wait
option helps us specify the time in seconds (from 0 through 2147483647)
that a query waits for resources before timing out. We can increase the
value of this option trying to avoid the timeout error message. For
additional information regarding this query wait option, please refer to
the following article on SQL Server Books Online.
Topic: "query wait Option"
Also, such issues occurring randomly tend to be complex and take up
extensive research time. I'd like to set your expectations that it may take
a while for us to help you narrow down the problem and we may eventually
redirect you to PSS to continue working with a dedicated Support
Professional. If this is critical, I'd recommend contacting PSS and opening
a support incident troubleshoot this further. If you need any help in this
regard, please let me know.
[Item 1]
Try to obtain the screen shot of the error message.
When the error occurred please perform the following steps to capture the
screen shot of the error message.
1. Press the "Pr Scrn" button on the keyboard.
2. Run the Paint tools (Start 'All programs 'Accessories ' Paint).
3. Press Ctrl+V to copy the screen shot from the memory.
4. Save as a JPEG file.
Thank you for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||"Michael Shao [MSFT]" <v-yshao@.online.microsoft.com> wrote in message
news:2tLJaornDHA.2148@.cpmsftngxa06.phx.gbl...
> Hi Sam,
> According to your description, I am not sure what your problem is. I would
> like you to provide the following information so that I can narrow down
> this issue.
> 1. Please provide me with the detailed error message. To do this, you can
> take a screenshot. Please send it to me at v-yshao@.microsoft.com. For
> additional information regarding how to obtain the screen shot, please
> review [Item 1].
>
I assume that you're referring to the error message that is being seen in
access. These are not terribly informative, and do not provide error
numbers. The errors being returned to the web app (which seems to have
somewhat better error handling) are timeouts.
> 2. How did you read and write data with Access to SQL Server, via a
linked
> table or programming? Can you describe it in detailed?
>
Access is using linked tables. These were created using the standard table
linking wizard from the file menu.
> 3. I would like to know when the error occurred. It seems that the error
> occurred when you updated the table on SQL Server. Did the error message
> occur when you connected to SQL Server?
>
No, it didn't. The applications are still able to read data when this
happens, which is what has me foxed. The connection seems to be almost
healthy.
> 4. When the error occurs again, please perform the problematic SQL
> statements using Query Analyzer. Does the same error message occur again?
> It helps us to identify the problem related to the SQL Server including
SQL
> statements and your VB code.
>
Unfortunately, the same SQL statements succeed more often than not.
> 5. Please provide the SQL Server error log (usually under C:\Program
> Files\Microsoft SQL Server\MSSQL\LOG)
>
I can certainly do this, but what I'm seeing there is just that the backups
ran correctly.
> On the SQL Server side, there is a query wait option. This query wait
> option helps us specify the time in seconds (from 0 through 2147483647)
> that a query waits for resources before timing out. We can increase the
> value of this option trying to avoid the timeout error message. For
> additional information regarding this query wait option, please refer to
> the following article on SQL Server Books Online.
> Topic: "query wait Option"
> Also, such issues occurring randomly tend to be complex and take up
> extensive research time. I'd like to set your expectations that it may
take
> a while for us to help you narrow down the problem and we may eventually
> redirect you to PSS to continue working with a dedicated Support
> Professional. If this is critical, I'd recommend contacting PSS and
opening
> a support incident troubleshoot this further. If you need any help in this
> regard, please let me know.
>
I did find that the transaction logs had grown to truly monumental sizes (18
and 15 gb respectively) I cleaned that up last night, and am watching the
system. Does this seem like a likely culprit? I know that the log is broken
into virtual segments, but if the segment count gets very high can this
cause long lookup/write times that might impact external timers?
I can certainly appreciate your comments regarding intermittent problems and
how difficult they can be to resolve... or even to know if they're resolved.
I'm mostly looking for an approach to troubleshooting, and your posting has
given me several ideas.
Thanks for the help. As I see the problem (or don't as I'm hoping for!) I'll
post more information.
Sam Robinson|||Hi Sam,
Thanks for your feedback. Based on my experience, when server is busy, such
as performing many jobs on the background, the timeout error will occur.
According to your description with the monumental sizes of transaction
logs, it is possible that there are many jobs working on the background,
such as backup jobs, which impact the performance of the server. Because
the error occurs randomly, it is hard to us to find out the root cause of
this problem. When the error occurs again on your side, please feel free to
post in the newsgroup, I will glad to work with you continously. Of course,
I also hope it do not occur again.
Thanks for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||"Michael Shao [MSFT]" <v-yshao@.online.microsoft.com> wrote in message
news:%239I3130nDHA.2464@.cpmsftngxa06.phx.gbl...
> Hi Sam,
> Thanks for your feedback. Based on my experience, when server is busy,
such
> as performing many jobs on the background, the timeout error will occur.
> According to your description with the monumental sizes of transaction
> logs, it is possible that there are many jobs working on the background,
> such as backup jobs, which impact the performance of the server. Because
> the error occurs randomly, it is hard to us to find out the root cause of
> this problem. When the error occurs again on your side, please feel free
to
> post in the newsgroup, I will glad to work with you continously. Of
course,
> I also hope it do not occur again.
> Thanks for using MSDN newsgroup.
>
Michael, et al
Well, it's been a week now and I think it's safe to say that truncating and
setting up a backup maintenance plan has resolved the problem. My
speculation is that the problem came from the necessity to log the
transaction in the increadably huge transaction log. This would seem to
follow as we didn't get a timeout when reading, only when trying to commit a
record.
Wow. Given the size the logs had gotten, I'm amazed that the thing was
working as well as it was.
Thanks for your help!
Sam Robinson
different applications, one an access app, and the other VB6 we will
experience a condition where we are able to read data, but when we attempt
to save the data we get ODBC timeouts. When this occurs, I can "fix" the
problem by going into one of the tables of the database in question and
modifying any value.
Configuration is a dual Xeon with 2gb of memory running SQL Server 2000.
Both databases are on this system and are accessed via different DSNs. One
is a web app, and is accessed by com dlls, the other is an app that was
created in MS Access and then modified so that it gets its data from linked
tables.
Any insite, or even better a good description of troublshooting techniques
would be appreciated.
Sam RobinsonHi Sam,
According to your description, I am not sure what your problem is. I would
like you to provide the following information so that I can narrow down
this issue.
1. Please provide me with the detailed error message. To do this, you can
take a screenshot. Please send it to me at v-yshao@.microsoft.com. For
additional information regarding how to obtain the screen shot, please
review [Item 1].
2. How did you read and write data with Access to SQL Server, via a linked
table or programming? Can you describe it in detailed?
3. I would like to know when the error occurred. It seems that the error
occurred when you updated the table on SQL Server. Did the error message
occur when you connected to SQL Server?
4. When the error occurs again, please perform the problematic SQL
statements using Query Analyzer. Does the same error message occur again?
It helps us to identify the problem related to the SQL Server including SQL
statements and your VB code.
5. Please provide the SQL Server error log (usually under C:\Program
Files\Microsoft SQL Server\MSSQL\LOG)
On the SQL Server side, there is a query wait option. This query wait
option helps us specify the time in seconds (from 0 through 2147483647)
that a query waits for resources before timing out. We can increase the
value of this option trying to avoid the timeout error message. For
additional information regarding this query wait option, please refer to
the following article on SQL Server Books Online.
Topic: "query wait Option"
Also, such issues occurring randomly tend to be complex and take up
extensive research time. I'd like to set your expectations that it may take
a while for us to help you narrow down the problem and we may eventually
redirect you to PSS to continue working with a dedicated Support
Professional. If this is critical, I'd recommend contacting PSS and opening
a support incident troubleshoot this further. If you need any help in this
regard, please let me know.
[Item 1]
Try to obtain the screen shot of the error message.
When the error occurred please perform the following steps to capture the
screen shot of the error message.
1. Press the "Pr Scrn" button on the keyboard.
2. Run the Paint tools (Start 'All programs 'Accessories ' Paint).
3. Press Ctrl+V to copy the screen shot from the memory.
4. Save as a JPEG file.
Thank you for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||"Michael Shao [MSFT]" <v-yshao@.online.microsoft.com> wrote in message
news:2tLJaornDHA.2148@.cpmsftngxa06.phx.gbl...
> Hi Sam,
> According to your description, I am not sure what your problem is. I would
> like you to provide the following information so that I can narrow down
> this issue.
> 1. Please provide me with the detailed error message. To do this, you can
> take a screenshot. Please send it to me at v-yshao@.microsoft.com. For
> additional information regarding how to obtain the screen shot, please
> review [Item 1].
>
I assume that you're referring to the error message that is being seen in
access. These are not terribly informative, and do not provide error
numbers. The errors being returned to the web app (which seems to have
somewhat better error handling) are timeouts.
> 2. How did you read and write data with Access to SQL Server, via a
linked
> table or programming? Can you describe it in detailed?
>
Access is using linked tables. These were created using the standard table
linking wizard from the file menu.
> 3. I would like to know when the error occurred. It seems that the error
> occurred when you updated the table on SQL Server. Did the error message
> occur when you connected to SQL Server?
>
No, it didn't. The applications are still able to read data when this
happens, which is what has me foxed. The connection seems to be almost
healthy.
> 4. When the error occurs again, please perform the problematic SQL
> statements using Query Analyzer. Does the same error message occur again?
> It helps us to identify the problem related to the SQL Server including
SQL
> statements and your VB code.
>
Unfortunately, the same SQL statements succeed more often than not.
> 5. Please provide the SQL Server error log (usually under C:\Program
> Files\Microsoft SQL Server\MSSQL\LOG)
>
I can certainly do this, but what I'm seeing there is just that the backups
ran correctly.
> On the SQL Server side, there is a query wait option. This query wait
> option helps us specify the time in seconds (from 0 through 2147483647)
> that a query waits for resources before timing out. We can increase the
> value of this option trying to avoid the timeout error message. For
> additional information regarding this query wait option, please refer to
> the following article on SQL Server Books Online.
> Topic: "query wait Option"
> Also, such issues occurring randomly tend to be complex and take up
> extensive research time. I'd like to set your expectations that it may
take
> a while for us to help you narrow down the problem and we may eventually
> redirect you to PSS to continue working with a dedicated Support
> Professional. If this is critical, I'd recommend contacting PSS and
opening
> a support incident troubleshoot this further. If you need any help in this
> regard, please let me know.
>
I did find that the transaction logs had grown to truly monumental sizes (18
and 15 gb respectively) I cleaned that up last night, and am watching the
system. Does this seem like a likely culprit? I know that the log is broken
into virtual segments, but if the segment count gets very high can this
cause long lookup/write times that might impact external timers?
I can certainly appreciate your comments regarding intermittent problems and
how difficult they can be to resolve... or even to know if they're resolved.
I'm mostly looking for an approach to troubleshooting, and your posting has
given me several ideas.
Thanks for the help. As I see the problem (or don't as I'm hoping for!) I'll
post more information.
Sam Robinson|||Hi Sam,
Thanks for your feedback. Based on my experience, when server is busy, such
as performing many jobs on the background, the timeout error will occur.
According to your description with the monumental sizes of transaction
logs, it is possible that there are many jobs working on the background,
such as backup jobs, which impact the performance of the server. Because
the error occurs randomly, it is hard to us to find out the root cause of
this problem. When the error occurs again on your side, please feel free to
post in the newsgroup, I will glad to work with you continously. Of course,
I also hope it do not occur again.
Thanks for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||"Michael Shao [MSFT]" <v-yshao@.online.microsoft.com> wrote in message
news:%239I3130nDHA.2464@.cpmsftngxa06.phx.gbl...
> Hi Sam,
> Thanks for your feedback. Based on my experience, when server is busy,
such
> as performing many jobs on the background, the timeout error will occur.
> According to your description with the monumental sizes of transaction
> logs, it is possible that there are many jobs working on the background,
> such as backup jobs, which impact the performance of the server. Because
> the error occurs randomly, it is hard to us to find out the root cause of
> this problem. When the error occurs again on your side, please feel free
to
> post in the newsgroup, I will glad to work with you continously. Of
course,
> I also hope it do not occur again.
> Thanks for using MSDN newsgroup.
>
Michael, et al
Well, it's been a week now and I think it's safe to say that truncating and
setting up a backup maintenance plan has resolved the problem. My
speculation is that the problem came from the necessity to log the
transaction in the increadably huge transaction log. This would seem to
follow as we didn't get a timeout when reading, only when trying to commit a
record.
Wow. Given the size the logs had gotten, I'm amazed that the thing was
working as well as it was.
Thanks for your help!
Sam Robinson
Wednesday, March 7, 2012
ODBC support
Can CE be called from an app. that makes ODBC calls?
Thanks.
Ah, there is no ODBC driver for the SQLCe engine that I know of. It uses an OLE DB interface...
hth
|||Here is a code example under OLEDBhttp://blogs.msdn.com/sqlservereverywhere/archive/2006/08/08/691894.aspx|||Yes, but he was asking about ODBC access. No, I'm not sure why he needs to use ODBC...|||
I would guess that the reason he wanted an ODBC adapter was because he wanted the database to be accessible from some tool that supports ODBC, but not OLEDB.
I'm actually surprised that there isn't some sort of generic ODBC-from-OLEDB adapter, so that if you have a DataSource accessible via OLEDB, you can turn it into an ODBC DataSource.
|||IIRC there was a OLEDB to ODBC bridge at some point that worked with ADO classic... ?|||Two:
1) The existing (calling) application uses ODBC calls;
2) ODBC is the only industry standard for database access. It is an indication of MS's market power that they can introduce a new database product and ignore it.
- A
|||I you can remember the neame, that would be very helpful.
- A
|||Ah, be that as it may, OLE DB and the .NET Framework providers are also industry standards. Yes, ODBC is certainly the oldest, and least flexible but granted, it's still in wide use. ODBC is supported in both OLE DB data access interafaces and .NET providers. The tiny SQLCe database is small because its support is focused on current technology. If it was more flexible in its interfaces I expect it to be larger and less useful for its intended purpose.ODBC SQL Server Driver[Shared Memory]ConnectionW
Hi all, question for you please :
We have client app. running on the same server as SQL and using LPC as
a network library.
Very often we have the error message bellow and application just
crash.
What can be a problem in this case.Your help is greatly appreciated.
Thanks.
2005/06/07 12:56:58 <appname> :
State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionWrite (WrapperWrite()).
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network
error. Check your network documentation.
2005/06/07 12:56:58 <appname> : Connection is dead.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/ODBC-SQL-Ser...ict238482.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=829217
This error very much looks like a problem with your network connectivity. You need to be looking at
your networking hardware or discussing connectivity issues with your network administrator.
"trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_829217_6382c1073d7900c13cc1a04dd5302317@.dbf orumz.com...
> Hi all, question for you please :
> We have client app. running on the same server as SQL and using LPC as
> a network library.
> Very often we have the error message bellow and application just
> crash.
> What can be a problem in this case.Your help is greatly appreciated.
> Thanks.
> 2005/06/07 12:56:58 <appname> :
> State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shared
> Memory]ConnectionWrite (WrapperWrite()).
> [Microsoft][ODBC SQL Server Driver][Shared Memory]General network
> error. Check your network documentation.
> 2005/06/07 12:56:58 <appname> : Connection is dead.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/ODBC-SQL-Ser...ict238482.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=829217
|||"" wrote:[vbcol=seagreen]
> This error very much looks like a problem with your network
> connectivity. You need to be looking at
> your networking hardware or discussing connectivity issues
> with your network administrator.
> "trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:4_829217_6382c1073d7900c13cc1a04dd5302317@.dbf orumz.com...
> using LPC as
> just
> appreciated.
> Driver][Shared
> network
> standards
> abuse:
Thanks for reply.
It is using LPC as network protocol.The client software installed on
the same server where sql server installed.I am wondering if it is
still using any network hardware?
We have client app. running on the same server as SQL and using LPC as
a network library.
Very often we have the error message bellow and application just
crash.
What can be a problem in this case.Your help is greatly appreciated.
Thanks.
2005/06/07 12:56:58 <appname> :
State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionWrite (WrapperWrite()).
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network
error. Check your network documentation.
2005/06/07 12:56:58 <appname> : Connection is dead.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/ODBC-SQL-Ser...ict238482.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=829217
This error very much looks like a problem with your network connectivity. You need to be looking at
your networking hardware or discussing connectivity issues with your network administrator.
"trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_829217_6382c1073d7900c13cc1a04dd5302317@.dbf orumz.com...
> Hi all, question for you please :
> We have client app. running on the same server as SQL and using LPC as
> a network library.
> Very often we have the error message bellow and application just
> crash.
> What can be a problem in this case.Your help is greatly appreciated.
> Thanks.
> 2005/06/07 12:56:58 <appname> :
> State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shared
> Memory]ConnectionWrite (WrapperWrite()).
> [Microsoft][ODBC SQL Server Driver][Shared Memory]General network
> error. Check your network documentation.
> 2005/06/07 12:56:58 <appname> : Connection is dead.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/ODBC-SQL-Ser...ict238482.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=829217
|||"" wrote:[vbcol=seagreen]
> This error very much looks like a problem with your network
> connectivity. You need to be looking at
> your networking hardware or discussing connectivity issues
> with your network administrator.
> "trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:4_829217_6382c1073d7900c13cc1a04dd5302317@.dbf orumz.com...
> using LPC as
> just
> appreciated.
> Driver][Shared
> network
> standards
> abuse:
Thanks for reply.
It is using LPC as network protocol.The client software installed on
the same server where sql server installed.I am wondering if it is
still using any network hardware?
ODBC SQL Server Driver[Shared Memory]ConnectionW
Hi all, question for you please :
We have client app. running on the same server as SQL and using LPC as
a network library.
Very often we have the error message bellow and application just
crash.
What can be a problem in this case.Your help is greatly appreciated.
Thanks.
2005/06/07 12:56:58 <appname> :
State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionWrite (WrapperWrite()).
[Microsoft][ODBC SQL Server Driver][Shared Memory]General networ
k
error. Check your network documentation.
2005/06/07 12:56:58 <appname> : Connection is dead.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/ODBC-SQL-Se...pict238482.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz
.com/eform.php?p=829217This error very much looks like a problem with your network connectivity. Y
ou need to be looking at
your networking hardware or discussing connectivity issues with your network
administrator.
"trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_829217_6382c1073d7900c13cc1a04dd5
302317@.dbforumz.com...
> Hi all, question for you please :
> We have client app. running on the same server as SQL and using LPC as
> a network library.
> Very often we have the error message bellow and application just
> crash.
> What can be a problem in this case.Your help is greatly appreciated.
> Thanks.
> 2005/06/07 12:56:58 <appname> :
> State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shar
ed
> Memory]ConnectionWrite (WrapperWrite()).
> [Microsoft][ODBC SQL Server Driver][Shared Memory]General netw
ork
> error. Check your network documentation.
> 2005/06/07 12:56:58 <appname> : Connection is dead.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/ODBC-SQL-Se.../>
238482.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=829217|||"" wrote:[vbcol=seagreen]
> This error very much looks like a problem with your network
> connectivity. You need to be looking at
> your networking hardware or discussing connectivity issues
> with your network administrator.
> "trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:4_829217_6382c1073d7900c13cc1a04dd5
302317@.dbforumz.com...
> using LPC as
> just
> appreciated.
> Driver][Shared
> network
> standards
> abuse:
Thanks for reply.
It is using LPC as network protocol.The client software installed on
the same server where sql server installed.I am wondering if it is
still using any network hardware?
We have client app. running on the same server as SQL and using LPC as
a network library.
Very often we have the error message bellow and application just
crash.
What can be a problem in this case.Your help is greatly appreciated.
Thanks.
2005/06/07 12:56:58 <appname> :
State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionWrite (WrapperWrite()).
[Microsoft][ODBC SQL Server Driver][Shared Memory]General networ
k
error. Check your network documentation.
2005/06/07 12:56:58 <appname> : Connection is dead.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/ODBC-SQL-Se...pict238482.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz
.com/eform.php?p=829217This error very much looks like a problem with your network connectivity. Y
ou need to be looking at
your networking hardware or discussing connectivity issues with your network
administrator.
"trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_829217_6382c1073d7900c13cc1a04dd5
302317@.dbforumz.com...
> Hi all, question for you please :
> We have client app. running on the same server as SQL and using LPC as
> a network library.
> Very often we have the error message bellow and application just
> crash.
> What can be a problem in this case.Your help is greatly appreciated.
> Thanks.
> 2005/06/07 12:56:58 <appname> :
> State 01000, DBErr 4: [Microsoft][ODBC SQL Server Driver][Shar
ed
> Memory]ConnectionWrite (WrapperWrite()).
> [Microsoft][ODBC SQL Server Driver][Shared Memory]General netw
ork
> error. Check your network documentation.
> 2005/06/07 12:56:58 <appname> : Connection is dead.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/ODBC-SQL-Se.../>
238482.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=829217|||"" wrote:[vbcol=seagreen]
> This error very much looks like a problem with your network
> connectivity. You need to be looking at
> your networking hardware or discussing connectivity issues
> with your network administrator.
> "trans53" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:4_829217_6382c1073d7900c13cc1a04dd5
302317@.dbforumz.com...
> using LPC as
> just
> appreciated.
> Driver][Shared
> network
> standards
> abuse:
Thanks for reply.
It is using LPC as network protocol.The client software installed on
the same server where sql server installed.I am wondering if it is
still using any network hardware?
Monday, February 20, 2012
odbc index problem
Hi all,
Here is a brief description of a problem I encountered, and how I
found a work around after 3 long days.
Here is a brief description of a problem I encountered, and how I
found a work around after 3 long days.
I have a VB6 app that uses ADO and ODBC to get communicate with SQL
server 2000 (sp3, running in win2003).
Everything was running great for a few weeks, but one day an update
statement that used to work just stopped working. It was a simple
update of 1 field in a table (about 30 columns, about 20k records).
SQL server acutally hung while it waited for a response that never
came, and everyone else on the network was also locked out of sql
server. Everyone had to do a ctrl alt del to crash the programme.
Steps I took...
Rebuilt the database. Same.
Restored backup. Same.
Moved database to another server. Same.
Checked for viruses, that no updates had happened, memory checks and
so on.
Still no joy.
Someone then recommended tinkering with the indexes of the table in
question. Which I did.
I added indexes, removed them, and eventuall found a combination that
worked. And this is it.
I removed the primary key, and replaced it with a clustered index.
That's it. And now it all appears to be running OK.
WHY WHY WHY?
I just don't get it.
Have I found a bug in sql server or odbc or ado? Is it a known issue?
What is the impact of what I have done?
Thanks in advance for your comments, and I hope this solution saves
someone else 3 days of hell!
TimTim (thew@.ltons.freeserve.co.uk) writes:
> I have a VB6 app that uses ADO and ODBC to get communicate with SQL
> server 2000 (sp3, running in win2003).
You should be using the SQLOLEDB provider. The default provider, OLE DB
over ODBC may be good for data sources for which there is no targeted
OLE DB provider, but this is not the case for SQL Server. Not that this
has anything to do with the problem you are describing, but nevertheless
I like to point this out.
> Everything was running great for a few weeks, but one day an update
> statement that used to work just stopped working. It was a simple
> update of 1 field in a table (about 30 columns, about 20k records).
> SQL server acutally hung while it waited for a response that never
> came, and everyone else on the network was also locked out of sql
> server. Everyone had to do a ctrl alt del to crash the programme.
> Steps I took...
> Rebuilt the database. Same.
> Restored backup. Same.
> Moved database to another server. Same.
> Checked for viruses, that no updates had happened, memory checks and
> so on.
> Still no joy.
> Someone then recommended tinkering with the indexes of the table in
> question. Which I did.
> I added indexes, removed them, and eventuall found a combination that
> worked. And this is it.
> I removed the primary key, and replaced it with a clustered index.
> That's it. And now it all appears to be running OK.
> WHY WHY WHY?
> I just don't get it.
> Have I found a bug in sql server or odbc or ado? Is it a known issue?
> What is the impact of what I have done?
There is next to nothing of useful information to comment the actual
case, so I can only answer in general terms.
In general, one needs to understand there are few tools that are so
powerful to make things run really slow like a relational database engine.
All modern DBMS has a cost-based optimizer that seeks find the best
way to execute a query, and to make its decisions it uses some information
about the data. SQL Server maintains statistics about the data and how it
is distributed. Most queries can be executed in a number of ways, and
the optimizer tries to estimate the most effecient plan. Note that was
the best plan yesterday, may not be the best plan today, because data
has changed, for instance increased in size. While optimizers often do a
good job, they are estimates, and sometimes things can go seriously wrong.
So this could explain why your query worked fine one day and then was
out to lunch the next day.
Now, there is a whole lot of things you can do help the optimizer, and
the most important is to ensure that your tables properly indexed for
the queries you use. After all, if you are to access one single row in
a million-row tables without any index at all, there is no more effecient
plan than to scan all million rows.
So there is nothing magic going on here, and least of all of any bug.
And ODBC is completely innocent. If you submit your own UPDATE statement,
ADO is too. If you use the .Update method in ADO, which I recommend
against, ADO is the one that builds the UPDATE statement. But the major
area for concern is the database design. If one has no knowledge about
database design and no understanding about indexing, you are very likely
to run into performance problems sooner or later, as soon as you get any
volume in your database.
If you feel that you would like to learn something in this area,
attending a class on SQL Server performance may be a good idea.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Subscribe to:
Posts (Atom)