Does this authentication scheme work?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hank (sorry_at_noway.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 10:11:16 -0600

I am building a Pocket PC app against an Oracle back end using .NET Compact
Framework and Oracle's sync technology (this includes Oracle Lite on the
Pocket PC). The presentation layer needs to also work for SQL Server CE. So
I'm trying to make the GUI code generic. To do this I need to confirm how
the logins work for SQL CE to SQL Server synchronization. I've tried setting
up a test scenario but failed to be able to authenticate. I don't have the
time to continue trying to figure out what I'm doing wrong, at this point I
just need to know whether the below authentication scheme works. The BOL's
seem to suggest it will work, but they seem a bit unclear. Since I wasn't
able to get it to work, I'm in a state of uncertainty.

My question (about SQL CE to SQL Server sync):

I want each user to be forced to authenticate with a user name and password
before any synchronization takes place. Can this be accomplished by setting
up a Windows account for each user and configuring the virtual directory in
IIS to use those accounts to authenticate?

I'm hoping this will work, because it mirrors what I'm doing with my Oracle
app.

Thanks very much in advance,
Hank

Relevant Pages

  • Re: Does this authentication scheme work?
    ... >I am building a Pocket PC app against an Oracle back end using .NET Compact ... The presentation layer needs to also work for SQL Server CE. ... > up a test scenario but failed to be able to authenticate. ... > up a Windows account for each user and configuring the virtual directory ...
    (microsoft.public.sqlserver.replication)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)