Showing posts with label connects. Show all posts
Showing posts with label connects. Show all posts

Friday, March 23, 2012

How to use SQL Express to Cache the data.

Hi,

We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data from SQL Express has to be automatically synch with centralised database.

How to catch the data into SQL Express in stead of using the default Caching data into DataSets for working in offline mode. Please kindly help me in order to solve this issue.

Thanks in advance,

Hello:

I've moved your question to the SQL Server Replication forum, as your issue seems to be more in their domain.

Thanks!

Mike Hernandez
Community PM
VSTO Team

|||

You could make the SQL Express as a merge subscriber to the Central Server. When connected, the middle tier can make the user talk to the Central Server directly and when offline, the middle tier needs to connect the user to the SQL Express instance.

When connected to the Central Server, Merge replication can keep changes in sync and when offline, changes can happen at the Central Server and SQL Express independenlty and when connection is restore, the changes will be synched across.

You will need to take into account if you are going to have conflicts and if so, an appropriate resolver.

Please see Books Online for more information.

Wednesday, March 21, 2012

How to use SQL Express to Cache the data.

Hi,

We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data from SQL Express has to be automatically synch with centralised database.

How to catch the data into SQL Express in stead of using the default Caching data into DataSets for working in offline mode. Please kindly help me in order to solve this issue.

Thanks in advance,

Hello:

I've moved your question to the SQL Server Replication forum, as your issue seems to be more in their domain.

Thanks!

Mike Hernandez
Community PM
VSTO Team

|||

You could make the SQL Express as a merge subscriber to the Central Server. When connected, the middle tier can make the user talk to the Central Server directly and when offline, the middle tier needs to connect the user to the SQL Express instance.

When connected to the Central Server, Merge replication can keep changes in sync and when offline, changes can happen at the Central Server and SQL Express independenlty and when connection is restore, the changes will be synched across.

You will need to take into account if you are going to have conflicts and if so, an appropriate resolver.

Please see Books Online for more information.

How to use SQL Express to Cache the data.

Hi,

We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data from SQL Express has to be automatically synch with centralised database.

How to catch the data into SQL Express in stead of using the default Caching data into DataSets for working in offline mode. Please kindly help me in order to solve this issue.

Thanks in advance,

Hello:

I've moved your question to the SQL Server Replication forum, as your issue seems to be more in their domain.

Thanks!

Mike Hernandez
Community PM
VSTO Team

|||

You could make the SQL Express as a merge subscriber to the Central Server. When connected, the middle tier can make the user talk to the Central Server directly and when offline, the middle tier needs to connect the user to the SQL Express instance.

When connected to the Central Server, Merge replication can keep changes in sync and when offline, changes can happen at the Central Server and SQL Express independenlty and when connection is restore, the changes will be synched across.

You will need to take into account if you are going to have conflicts and if so, an appropriate resolver.

Please see Books Online for more information.

Sunday, February 19, 2012

How to use 32-bit ODBC driver (sybase) at an ETL application running (deployed into SQL Server)

I am developing an ETL system on a 32-bit machine let's say, called 'dwdev'. The application connects to a Sybase database as a source system using ODBC connection. I am able to run this application directly from Visual studio 2005 and i am able to deploy it into SQL Server 2005 and run it from Server as a job. Both work. At this server i am connecting to a SQL Server instance called 'dwdev'.

When i transfer my application onto a 64-bit machine, let's say called 'dwtest', i am able to run my application from Visual Studio 2005 properly and it works, but when i deploy it into SQL Server (instance is called 'dwtest') and try to run it as a job just like the development machine, it gives an error and stops executing.

I was facing 'data source' type of error when i was first trying it from Visual Studio, but i solved this problem by setting Run64bitRunTime settings to FALSE on the Project's properties Debugging Page, at 64-bit machine. now it uses 32-bit runtime then 32-bit Sybase ODBC driver. But i cannot force the application to use 32 bit runtime when i am executing it from SQL Server as a job.

How can i do that? is there an alternative method?

Thanks for your help...

The solution in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=603814&SiteID=1

worked for me(Thanks to Michael Entin) when i execute my application on SQL Server as a Job (SQL Server Agent) calling command line dtexec utility. I defined my job step as TYPE: Operation System (CmdExec) , RUN AS: SQL Agent Service Account

I used the follwing string as my command:

C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe /sq EXECUTE_ALL_S0_JOBS_FROM_SQL_SERVER_MASTER /ser dwtest

but i still wonder whether there is a solution for defining job step as a SQL Server Integration Services Package and executing the package EXECUTE_ALL_S0_JOBS_FROM_SQL_SERVER_MASTER in a 32-bit mode under SQL Server Agent?

Thanks