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
Yes, it will work. Use basic authentication on your virtual directory, and
create an NT group that contains the users. Then add this group the pal for
your publication.
When you are connecting to the URL make sure you pass the password and
account.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Hank" <sorry@.noway.com> wrote in message
news:10rrfmgro4pl519@.corp.supernews.com...
>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
>
