Olympic Games Support in Torino 2006

We are utilizing a .net front end Client side application to access a remote
SQL database. We will be using this method for transactions locally to issue
apparel to Athletes as well as other information about our team. The
question I have is our proposed setup is to have a 2MB line using a VPN
connection back to our home site and conduct live application entry, we will
then have a local client facing server in Italy for disaster recovery
performing stored procedures to trigger replication for a backup copy. We
proposed this topology as other members need real time access to the data at
multiple locations. Are main concerns are survivability of the database and
potential latency issues over a leased line. Anyone have any thoughts?
I wouldn't use stored procedures for that but setup replication.
In case the link fails you have disconnected systems that can operate
independent from eachother and when the connection comes back up replication
will occur.
There are several replication topologies and methods possible.
This will depend on the amount of data you want to replicate as well.
Thinking of snapshot replication or transactional replication
Probably transactional with immediate updating subscribers might be the
option.
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Paul Walker" <Paul Walker@.discussions.microsoft.com> wrote in message
news:5488F052-E627-415C-AD93-545D726BA28F@.microsoft.com...
> We are utilizing a .net front end Client side application to access a
> remote
> SQL database. We will be using this method for transactions locally to
> issue
> apparel to Athletes as well as other information about our team. The
> question I have is our proposed setup is to have a 2MB line using a VPN
> connection back to our home site and conduct live application entry, we
> will
> then have a local client facing server in Italy for disaster recovery
> performing stored procedures to trigger replication for a backup copy. We
> proposed this topology as other members need real time access to the data
> at
> multiple locations. Are main concerns are survivability of the database
> and
> potential latency issues over a leased line. Anyone have any thoughts?

OLE DB: How to set the property DBPROP_SSCE_TRANSACTION_COMMIT_MODE correctly?

Hello,

because of the fact that the database sdf-file is stored on a cf-card, i want that all commit transactions will be flushed to the file immediately.
So i want to open the database with the above property. But i don't know the type and value i have to place into the variant. The following code fragment gave me the error "DB_S_ERRORSOCCURRED when i try to set the property with IDBInitialize::SetProperties() :

//Initialize property DBPROP_SSCE_TRANSACTION_COMMIT_MODE
dbprop_ssce_session[0].dwPropertyID = DBPROP_SSCE_TRANSACTION_COMMIT_MODE;
dbprop_ssce_session[0].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop_ssce_session[0].vValue.vt = VT_I4;
dbprop_ssce_session[0].vValue.lVal = DBPROPVAL_SSCE_TCM_FLUSH;

//Initialize property set DBPROPSET_SSCE_SESSION
dbpropset[1].guidPropertySet = DBPROPSET_SSCE_SESSION;
dbpropset[1].rgProperties = dbprop_ssce_session;
dbpropset[1].cProperties = 1;
//(there is another property for the path not shown here)

I would appreciate it when someone out there knows the answer and could tell me.

Kind regards,
Andre

Your code looks ok. I use the ATL OLE DB Consumer Templates for this and they also set the colid member to DB_NULLID. This is the only thing I see missing from your code.

Other than this, I would also look at the OLE DB error parameters to get more details.

|||

Every thing is okay except that you are setting the property on IDBInitialize. This is a session related property and so should be set using ISessionProperties.

If the question is answered, please mark it as answered.

Thanks

Raja

|||Thanks Raja,

that was exactly the crux of the matter!

Kind regards,
Andre

OLE DB: How to set the property DBPROP_SSCE_TRANSACTION_COMMIT_MODE correctly?

Hello,

because of the fact that the database sdf-file is stored on a cf-card, i want that all commit transactions will be flushed to the file immediately.
So i want to open the database with the above property. But i don't know the type and value i have to place into the variant. The following code fragment gave me the error "DB_S_ERRORSOCCURRED when i try to set the property with IDBInitialize::SetProperties() :

//Initialize property DBPROP_SSCE_TRANSACTION_COMMIT_MODE
dbprop_ssce_session[0].dwPropertyID = DBPROP_SSCE_TRANSACTION_COMMIT_MODE;
dbprop_ssce_session[0].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop_ssce_session[0].vValue.vt = VT_I4;
dbprop_ssce_session[0].vValue.lVal = DBPROPVAL_SSCE_TCM_FLUSH;

//Initialize property set DBPROPSET_SSCE_SESSION
dbpropset[1].guidPropertySet = DBPROPSET_SSCE_SESSION;
dbpropset[1].rgProperties = dbprop_ssce_session;
dbpropset[1].cProperties = 1;
//(there is another property for the path not shown here)

I would appreciate it when someone out there knows the answer and could tell me.

Kind regards,
Andre

Your code looks ok. I use the ATL OLE DB Consumer Templates for this and they also set the colid member to DB_NULLID. This is the only thing I see missing from your code.

Other than this, I would also look at the OLE DB error parameters to get more details.

|||

Every thing is okay except that you are setting the property on IDBInitialize. This is a session related property and so should be set using ISessionProperties.

If the question is answered, please mark it as answered.

Thanks

Raja

|||Thanks Raja,

that was exactly the crux of the matter!

Kind regards,
Andre