Re: Still got the same problem
From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 09/01/04
- Next message: Kevin Collins \(MS - SQL Mobile\): "Re: Merge replication with Oracle"
- Previous message: Kevin Collins \(MS - SQL Mobile\): "Re: SQL Server CE Administration (NTFS Permissions)"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 1 Sep 2004 13:06:30 -0700
Best thing is to reference either the Northwind or IBuySpy sample code that
ships with VS 2003 and SQL Server CE.
"Jeff" <it_consultant1@hotmail.com.NOSPAM> wrote in message
news:%23C%23C4rAkEHA.3536@TK2MSFTNGP12.phx.gbl...
> After some research, I still got the same problem....
>
> I replaced this line:
> rep.SubscriberConnectionString = @" Data Source=\My Documents\test.sdf";
>
> with this line
> rep.SubscriberConnectionString =
> @"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My
> Documents\test.sdf";
>
>
> And still the same problem....
>
> Any clues to why I get this message will be appreciated!
>
> Jeff
>
> "Jeff" <it_consultant1@hotmail.com.NOSPAM> wrote in message
> news:e4UqRL2jEHA.4068@TK2MSFTNGP10.phx.gbl...
>> Hi!
>>
>> IDE: VS 2003 .net + sqlserver2k + sp3
>> Microsoft SQL Server CE 2.0
>> OS: XP pro
>>
>>
>> Here is some of my code in my test app for pocketpc:
>> SqlCeReplication rep = new SqlCeReplication(
>> @http://localhost/Nwind/sscesa20.dll,
>> "","",
>> "PC3",
>> "Northwind",
>> "Northwind",
>> "Testing",
>> @" Data Source=\My Documents\test.sdf");
>>
>> if (!System.IO.File.Exists(@"\My Documents\test.sdf"))
>> {
>> rep.AddSubscription(AddOption.CreateDatabase);
>> }
>> rep.Synchronize();
>>
>> The last line throws this exception:
>> "A requet to send data to he computer running IIS has failed.
>> For more information, see HRESULT. [,,,,,]"
>>
>>
>> Some facts about how my sqlserver configuration and config og my
> replication
>> * Sq server is configured with authentication mode "Windows only"
>>
>> Here is the result of the "Create Publicaton wizard" (the text below are
>> copied from the wizard window)
>>
>> "Create a merge publication from database 'Northwind'.
>>
>> The following types of Subscribers may subscribe to this publication:
>> Servers running SQL Server 2000
>> Heterogeneous data sources
>>
>> Publish the following tables as articles:
>> 'Categories' as 'Categories'
>> 'CustomerCustomerDemo' as 'CustomerCustomerDemo'
>> 'CustomerDemographics' as 'CustomerDemographics'
>> 'Customers' as 'Customers'
>> 'Employees' as 'Employees'
>> 'EmployeeTerritories' as 'EmployeeTerritories'
>> 'Order Details' as 'Order Details'
>> 'Orders' as 'Orders'
>> 'Products' as 'Products'
>> 'Region' as 'Region'
>> 'Shippers' as 'Shippers'
>> 'Suppliers' as 'Suppliers'
>> 'Territories' as 'Territories'
>>
>> The name of this publication is 'Northwind'. The description is 'Merge
>> publication of Northwind database from Publisher PC3.'.
>>
>> Do not filter data in this publication.
>>
>> Allow anonymous subscriptions to this publication.
>>
>> Run the Snapshot Agent at the following scheduled times:
>> Occurs every 1 week(s) on Saturday, at 23:47:00.
>> Run the Snapshot Agent immediately after the publication is created.
>>
>>
>> ***************************
>>
>> Any clue to why I get this exception will be appreciated!
>>
>> Jeff
>>
>>
>>
>
>
- Next message: Kevin Collins \(MS - SQL Mobile\): "Re: Merge replication with Oracle"
- Previous message: Kevin Collins \(MS - SQL Mobile\): "Re: SQL Server CE Administration (NTFS Permissions)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
