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
>

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
>

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
>

ODBC to connect crystal report 8.5 and lotus notes 6.5

Hi:

I wanted to connect crystal report 8.5 with Domino lotus notes 6.5 through ODBC , so does any one know which ODBC i can use and how to download it ??

I found some where on internet that I have to use "NotesSQL" driver for this but I don't know what is that and from where to download

Thanks
-Jayesh MendparaHi all:

I found answer for my query and I am posting here because it might be useful to somebody else ,,

to conenct crystal report and domino's lotus notes your need NotesSQL ODBC driver and you can download it from ibm.com

Thanks

-Jayesh Mendpara

ODBC SQL Driver Timeout Expired from MS Access

Hi

I'm running a machine with windows xp pro sp2. I have a MS Access 2000 database on that machine. The database contains 1 odbc linked table
and 1 Access query.

The odbc linked table is connected to a MS SQL Server 2000 database with a ODBC SQL Server System DSN.

The table on SQL Server to which the table in Access is linked has about
3 million + rows.

When I open the ODBC linked table in Access, it opens without a problem.

However, if I use even so much as one criterion such as "where company = ABC" for example, then it "thinks" for a while and returns the dreaded:
[Microsoft][ODBC SQL Driver] Timeout Expired (#0).

I have to use MS Access 2000 as the front end for this SQL Database table.

How do I get around the timeout issue. Is there a setting in SQL?

Please keep in mind that
I can't write the queries as Store procs because the requirement of the client is that there be one Linked Access table that the users can use
to write various access queries. No user are not techies.

please helpread this post:
http://www.mcse.ms/message1582144.html

I don't test.
Tell me.
Bye.