|
|
|
date: Mon, 25 Apr 2005 08:31:37 -0700,
group: microsoft.public.sqlserver.ce
back
SQL CE Synching Problems
I tried what you suggested with going to the url from the pocket pc and I
got a Error Code 10060: Connection Timeout. I didn't mention before that I
am trying to run this from the Emulator not from an actual pocket PC. I
pointed a different computer to this same url and it started to download the
dll file to my local machine.
I just tried it again from the emulator IE but using the IP address instead
of the computer name and now I get a Enter User Name and Password screen for
the network resource. After I try my network password several times, it
give me an unauthorized page. Thanks for any help you can give.
Previous Message from other group:
Bruce,
Two things:
1. start by verifying that you can get to the virtual directory. On your
device,
go to Pocket IE and enter url:
http://{your_machine_name_or_ip_address}/{virt_dir_name}/sscesa20.dll
if you don't get a response from that, you have some network
connectivity -or- virtual directory
config issue
2. there is a newsgroup for sql ce which I take care of.
microsoft.public.sqlserver.ce - see you there.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Bruce Groen" wrote in message
news:OdRmjD0RFHA.2136@TK2MSFTNGP14.phx.gbl...
>I am new to pocket pc programming but I am trying to write a database app
> using SQLCE and synching with a SQL 2000 database. I have downloaded a
> couple of sample applications but I can't get any of them to work.
>
> I have downloaded SQLCE 2.0 and installed it and created a virtual
> directory
> for it. When I try to synch with this sample app I get:
> Error:80004005
> The gateway has timed out. [,,,,,]
> Native Error: 28026
> Microsoft SQL Server 2000
> Windows CE Edition
>
> This happens on the initial synch so I have never successfully been able
> to
> synch with the database. I have also tried to enable logging based on a
> knowledge base article I read but that doesn't seem to work either. Any
> help would be appreciated.
>
>
date: Mon, 25 Apr 2005 08:31:37 -0700
author: Bruce Groen
Re: SQL CE Synching Problems
you have an issue with permissions on the IIS virtual directory.
for now, enable anonymous access the the virtual directory and
check the box for scripts and executables in the IIS permissions
dialog.
btw - you did setup the virtual dir and permissions using the wizard
right? if not, run that wizard from the server tools directory.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Bruce Groen" wrote in message
news:%23U1kfvaSFHA.3296@TK2MSFTNGP15.phx.gbl...
>I tried what you suggested with going to the url from the pocket pc and I
> got a Error Code 10060: Connection Timeout. I didn't mention before that
> I
> am trying to run this from the Emulator not from an actual pocket PC. I
> pointed a different computer to this same url and it started to download
> the
> dll file to my local machine.
> I just tried it again from the emulator IE but using the IP address
> instead
> of the computer name and now I get a Enter User Name and Password screen
> for
> the network resource. After I try my network password several times, it
> give me an unauthorized page. Thanks for any help you can give.
>
>
> Previous Message from other group:
> Bruce,
>
> Two things:
>
> 1. start by verifying that you can get to the virtual directory. On your
> device,
> go to Pocket IE and enter url:
> http://{your_machine_name_or_ip_address}/{virt_dir_name}/sscesa20.dll
>
> if you don't get a response from that, you have some network
> connectivity -or- virtual directory
> config issue
>
> 2. there is a newsgroup for sql ce which I take care of.
> microsoft.public.sqlserver.ce - see you there.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Bruce Groen" wrote in message
> news:OdRmjD0RFHA.2136@TK2MSFTNGP14.phx.gbl...
>>I am new to pocket pc programming but I am trying to write a database app
>> using SQLCE and synching with a SQL 2000 database. I have downloaded a
>> couple of sample applications but I can't get any of them to work.
>>
>> I have downloaded SQLCE 2.0 and installed it and created a virtual
>> directory
>> for it. When I try to synch with this sample app I get:
>> Error:80004005
>> The gateway has timed out. [,,,,,]
>> Native Error: 28026
>> Microsoft SQL Server 2000
>> Windows CE Edition
>>
>> This happens on the initial synch so I have never successfully been able
>> to
>> synch with the database. I have also tried to enable logging based on a
>> knowledge base article I read but that doesn't seem to work either. Any
>> help would be appreciated.
>>
>>
>
>
>
date: Mon, 25 Apr 2005 15:21:11 -0600
author: Darren Shaffer
Re: SQL CE Synching Problems
I ran the wizard again to check all the permissions and this is what it
showed:
[HTTP Content Folder Tab]
Folder = C:\Inetpub\wwwroot\SQLCEData\
Permissions:
Read Yes
Run Scripts Yes
Execute Yes (Greyed out)
Write Yes
Directory Browse No
[HTTP Authentication Tab]
Anonymous Access Yes
Account Used for access:
ServerName\IUSR_ServerName
Basic Authentication No
Integrated Windows No
[NTFS Permissions Tab]
Permissions for user ServerName\IUSR_ServerName
Permissions for sscesa20.dll
Full Control No
Modify No
Read & Execute Yes
Write No
Temporary file location
Full Control No
Modify No
Read & Execute Yes
Read Yes
Write Yes
Permissions on \\servername\repldata (Snapshot folder for SQL)
For ServerName\IUSR_ServerName
Full Control No
Modify No
Read & Execute Yes
Read Yes
Write No
I ran the program again from the emulator this time using the IP address
instead of the computer name and I got this error message:
---------------------------------------------------------
Error:80072ee2
A request to send data to the computer running IIS has failed. For more
information, see HRESULT. [,,,,,]
Native Error:28037
Microsoft SQL Server 2000 Windows CE Edition
---------------------------------------------------------
I ran it again after walking through the wizard to confirm all the settings
and this time I got this error message:
---------------------------------------------------------
Error:80004005
Authentication failed on the computer running IIS.[,,,,,]
Native Error:28011
Microsoft SQL Server CE Edition
---------------------------------------------------------
I have a second computer that has IIS on it but does not have SQL on it so I
tried installing SQL CE 2.0 on it and point it to the other SQL server for
the data. I have set it up for anonymous authentication but this is the
error I get when I point to that one via the IP address:
-----------------------------------------------------------------
Error:80004005
A call to SQL Server Reconciler failed. [,,,,,]
Native Error:29006
Microsoft SQL Server 2000 Windows CE Edition
Error:80045017
The process could not deliver the snapshot to the subscriber.
Native Error:0
Merge Replication Provider
-----------------------------------------------------------------
One thing I am confused about this one is that I read that if I am using
anonymous authentication I have to give the IUSR_ComputerName account read
permission to the SQL replication snapshot folder which isn't a problem when
IIS and SQL are on the same server but how do I give a local user on one
computer permission to a resource on a different server?
I would ideally like to get this working on the first server but I installed
it on the second one to see if it would help me figure it out.
BTW, I am running this on the Pocket PC 2002 Emulator instead of the 2003
one.
"Darren Shaffer" wrote in message
news:OgSX6ydSFHA.508@TK2MSFTNGP12.phx.gbl...
> you have an issue with permissions on the IIS virtual directory.
> for now, enable anonymous access the the virtual directory and
> check the box for scripts and executables in the IIS permissions
> dialog.
>
> btw - you did setup the virtual dir and permissions using the wizard
> right? if not, run that wizard from the server tools directory.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
> "Bruce Groen" wrote in message
> news:%23U1kfvaSFHA.3296@TK2MSFTNGP15.phx.gbl...
> >I tried what you suggested with going to the url from the pocket pc and
I
> > got a Error Code 10060: Connection Timeout. I didn't mention before
that
> > I
> > am trying to run this from the Emulator not from an actual pocket PC. I
> > pointed a different computer to this same url and it started to download
> > the
> > dll file to my local machine.
> > I just tried it again from the emulator IE but using the IP address
> > instead
> > of the computer name and now I get a Enter User Name and Password screen
> > for
> > the network resource. After I try my network password several times, it
> > give me an unauthorized page. Thanks for any help you can give.
> >
> >
> > Previous Message from other group:
> > Bruce,
> >
> > Two things:
> >
> > 1. start by verifying that you can get to the virtual directory. On
your
> > device,
> > go to Pocket IE and enter url:
> > http://{your_machine_name_or_ip_address}/{virt_dir_name}/sscesa20.dll
> >
> > if you don't get a response from that, you have some network
> > connectivity -or- virtual directory
> > config issue
> >
> > 2. there is a newsgroup for sql ce which I take care of.
> > microsoft.public.sqlserver.ce - see you there.
> > --
> > Darren Shaffer
> > .NET Compact Framework MVP
> > Principal Architect
> > Connected Innovation
> > www.connectedinnovation.com
> >
> > "Bruce Groen" wrote in message
> > news:OdRmjD0RFHA.2136@TK2MSFTNGP14.phx.gbl...
> >>I am new to pocket pc programming but I am trying to write a database
app
> >> using SQLCE and synching with a SQL 2000 database. I have downloaded a
> >> couple of sample applications but I can't get any of them to work.
> >>
> >> I have downloaded SQLCE 2.0 and installed it and created a virtual
> >> directory
> >> for it. When I try to synch with this sample app I get:
> >> Error:80004005
> >> The gateway has timed out. [,,,,,]
> >> Native Error: 28026
> >> Microsoft SQL Server 2000
> >> Windows CE Edition
> >>
> >> This happens on the initial synch so I have never successfully been
able
> >> to
> >> synch with the database. I have also tried to enable logging based on
a
> >> knowledge base article I read but that doesn't seem to work either.
Any
> >> help would be appreciated.
> >>
> >>
> >
> >
> >
>
>
date: Mon, 25 Apr 2005 17:21:47 -0700
author: Bruce Groen
Re: SQL CE Synching Problems
222 16944
Bruce,
Have you granted IUSER_ServerName access to your publication within SQL
Server?
It looks like the permissions problem is getting access to the publication.
It appears you
are indeed getting from the emulator to IIS successfully if you can go to
Pocket IE on
the emulator and get a response back from
http://server_IP_address/SQLCEData/sscesa20.dll,
so the issue has to be between the server tools and the publisher.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Bruce Groen" wrote in message
news:e8gzGYfSFHA.3184@TK2MSFTNGP09.phx.gbl...
>I ran the wizard again to check all the permissions and this is what it
> showed:
> [HTTP Content Folder Tab]
> Folder = C:\Inetpub\wwwroot\SQLCEData\
> Permissions:
> Read Yes
> Run Scripts Yes
> Execute Yes (Greyed out)
> Write Yes
> Directory Browse No
>
> [HTTP Authentication Tab]
> Anonymous Access Yes
> Account Used for access:
> ServerName\IUSR_ServerName
> Basic Authentication No
> Integrated Windows No
>
> [NTFS Permissions Tab]
> Permissions for user ServerName\IUSR_ServerName
>
> Permissions for sscesa20.dll
> Full Control No
> Modify No
> Read & Execute Yes
> Write No
>
> Temporary file location
> Full Control No
> Modify No
> Read & Execute Yes
> Read Yes
> Write Yes
>
> Permissions on \\servername\repldata (Snapshot folder for SQL)
> For ServerName\IUSR_ServerName
> Full Control No
> Modify No
> Read & Execute Yes
> Read Yes
> Write No
>
> I ran the program again from the emulator this time using the IP address
> instead of the computer name and I got this error message:
> ---------------------------------------------------------
> Error:80072ee2
> A request to send data to the computer running IIS has failed. For more
> information, see HRESULT. [,,,,,]
> Native Error:28037
> Microsoft SQL Server 2000 Windows CE Edition
> ---------------------------------------------------------
>
> I ran it again after walking through the wizard to confirm all the
> settings
> and this time I got this error message:
> ---------------------------------------------------------
> Error:80004005
> Authentication failed on the computer running IIS.[,,,,,]
> Native Error:28011
> Microsoft SQL Server CE Edition
> ---------------------------------------------------------
>
> I have a second computer that has IIS on it but does not have SQL on it so
> I
> tried installing SQL CE 2.0 on it and point it to the other SQL server for
> the data. I have set it up for anonymous authentication but this is the
> error I get when I point to that one via the IP addre
date: Mon, 25 Apr 2005 22:08:29 -0600
author: Darren Shaffer
Re: SQL CE Synching Problems
Thanks for your help. I finally got it working. I didn't keep real good
notes on what I did to get it working so I am not positive what fixed it but
I did create a new virtual directory, this time pointint to the original
install location of SQL CE instead of under Inetpub like I had done before.
I also deleted and recreated the publication because I was still getting
some errors after that. I still don't understand why when I go to
properties of the publication in SQL and go to the status tab and click the
button that says show snapshot files I get an error message that it can't
find the files but it works so I will leave it alone. Thanks again for your
help.
"Darren Shaffer" wrote in message
news:eYwYhWhSFHA.356@TK2MSFTNGP14.phx.gbl...
> Bruce,
>
> Have you granted IUSER_ServerName access to your publication within SQL
> Server?
> It looks like the permissions problem is getting access to the
publication.
> It appears you
> are indeed getting from the emulator to IIS successfully if you can go to
> Pocket IE on
> the emulator and get a response back from
> http://server_IP_address/SQLCEData/sscesa20.dll,
> so the issue has to be between the server tools and the publisher.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
> "Bruce Groen" wrote in message
> news:e8gzGYfSFHA.3184@TK2MSFTNGP09.phx.gbl...
> >I ran the wizard again to check all the permissions and this is what it
> > showed:
> > [HTTP Content Folder Tab]
> > Folder = C:\Inetpub\wwwroot\SQLCEData\
> > Permissions:
> > Read Yes
> > Run Scripts Yes
> > Execute Yes (Greyed out)
> > Write Yes
> > Directory Browse No
> >
> > [HTTP Authentication Tab]
> > Anonymous Access Yes
> > Account Used for access:
> > ServerName\IUSR_ServerName
> > Basic Authentication No
> > Integrated Windows No
> >
> > [NTFS Permissions Tab]
> > Permissions for user ServerName\IUSR_ServerName
> >
> > Permissions for sscesa20.dll
> > Full Control No
> > Modify No
> > Read & Execute Yes
> > Write No
> >
> > Temporary file location
> > Full Control No
> > Modify No
> > Read & Execute Yes
> > Read Yes
> > Write Yes
> >
> > Permissions on \\servername\repldata (Snapshot folder for SQL)
> > For ServerName\IUSR_ServerName
> > Full Control No
> > Modify No
> > Read & Execute Yes
> > Read Yes
> > Write No
> >
> > I ran the program again from the emulator this time using the IP address
> > instead of the computer name and I got this error message:
> > ---------------------------------------------------------
> > Error:80072ee2
> > A request to send data to the computer running IIS has failed. For more
> > information, see HRESULT. [,,,,,]
> > Native Error:28037
> > Microsoft SQL Server 2000 Windows CE Edition
> > ---------------------------------------------------------
> >
> > I ran it again after walking through the wizard to confirm all the
> > settings
> > and this time I got this error message:
> > ---------------------------------------------------------
> > Error:80004005
> > Authentication failed on the computer running IIS.[,,,,,]
> > Native Error:28011
> > Microsoft SQL Server CE Edition
> > ---------------------------------------------------------
> >
> > I have a second computer that has IIS on it but does not have SQL on it
so
> > I
> > tried installing SQL CE 2.0 on it and point it to the other SQL server
for
> > the data. I have set it up for anonymous authentication but this is the
> > error I get when I point to that one via the IP address:
> > -----------------------------------------------------------------
> > Error:80004005
> > A call to SQL Server Reconciler failed. [,,,,,]
> > Native Error:29006
> > Microsoft SQL Server 2000 Windows CE Edition
> > Error:80045017
> > The process could not deliver the snapshot to the subscriber.
> > Native Error:0
> > Merge Replication Provider
> > -----------------------------------------------------------------
> > One thing I am confused about this one is that I read that if I am using
> > anonymous authentication I have to give the IUSR_ComputerName account
read
> > permission to the SQL replication snapshot folder which isn't a problem
> > when
> > IIS and SQL are on the same server but how do I give a local user on one
> > computer permission to a resource on a different server?
> >
> > I would ideally like to get this working on the first server but I
> > installed
> > it on the second one to see if it would help me figure it out.
> >
> > BTW, I am running this on the Pocket PC 2002 Emulator instead of the
2003
> > one.
> > "Darren Shaffer" wrote in
> > message
> > news:OgSX6ydSFHA.508@TK2MSFTNGP12.phx.gbl...
> >> you have an issue with permissions on the IIS virtual directory.
> >> for now, enable anonymous access the the virtual directory and
> >> check the box for scripts and executables in the IIS permissions
> >> dialog.
> >>
> >> btw - you did setup the virtual dir and permissions using the wizard
> >> right? if not, run that wizard from the server tools directory.
> >> --
> >> Darren Shaffer
> >> .NET Compact Framework MVP
> >> Principal Architect
> >> Connected Innovation
> >> www.connectedinnovation.com
> >>
> >>
> >> "Bruce Groen" wrote in message
> >> news:%23U1kfvaSFHA.3296@TK2MSFTNGP15.phx.gbl...
> >> >I tried what you suggested with going to the url from the pocket pc
and
> > I
> >> > got a Error Code 10060: Connection Timeout. I didn't mention before
> > that
> >> > I
> >> > am trying to run this from the Emulator not from an actual pocket PC.
> >> > I
> >> > pointed a different computer to this same url and it started to
> >> > download
> >> > the
> >> > dll file to my local machine.
> >> > I just tried it again from the emulator IE but using the IP address
> >> > instead
> >> > of the computer name and now I get a Enter User Name and Password
> >> > screen
> >> > for
> >> > the network resource. After I try my network password several times,
> >> > it
> >> > give me an unauthorized page. Thanks for any help you can give.
> >> >
> >> >
> >> > Previous Message from other group:
> >> > Bruce,
> >> >
> >> > Two things:
> >> >
> >> > 1. start by verifying that you can get to the virtual directory. On
> > your
> >> > device,
> >> > go to Pocket IE and enter url:
> >> > http://{your_machine_name_or_ip_address}/{virt_dir_name}/sscesa20.dll
> >> >
> >> > if you don't get a response from that, you have some network
> >> > connectivity -or- virtual directory
> >> > config issue
> >> >
> >> > 2. there is a newsgroup for sql ce which I take care of.
> >> > microsoft.public.sqlserver.ce - see you there.
> >> > --
> >> > Darren Shaffer
> >> > .NET Compact Framework MVP
> >> > Principal Architect
> >> > Connected Innovation
> >> > www.connectedinnovation.com
> >> >
> >> > "Bruce Groen" wrote in message
> >> > news:OdRmjD0RFHA.2136@TK2MSFTNGP14.phx.gbl...
> >> >>I am new to pocket pc programming but I am trying to write a database
> > app
> >> >> using SQLCE and synching with a SQL 2000 database. I have
downloaded
> >> >> a
> >> >> couple of sample applications but I can't get any of them to work.
> >> >>
> >> >> I have downloaded SQLCE 2.0 and installed it and created a virtual
> >> >> directory
> >> >> for it. When I try to synch with this sample app I get:
> >> >> Error:80004005
> >> >> The gateway has timed out. [,,,,,]
> >> >> Native Error: 28026
> >> >> Microsoft SQL Server 2000
> >> >> Windows CE Edition
> >> >>
> >> >> This happens on the initial synch so I have never successfully been
> > able
> >> >> to
> >> >> synch with the database. I have also tried to enable logging based
on
> > a
> >> >> knowledge base article I read but that doesn't seem to work either.
> > Any
> >> >> help would be appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>
date: Thu, 28 Apr 2005 11:22:12 -0700
author: Bruce Groen
|
|
