Developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework

Aug 13, 2007

We are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using:
public bool Replicate()
{ bool ret = true;
SqlCeReplication repl = null;
try {
// Instantiate and configure
SqlCeReplication object repl = new SqlCeReplication();
string dbFile = ........
repl.InternetUrl = this.InternetUrl;
repl.InternetLogin = this.InternetLogin;
repl.InternetPassword = this.InternetPassword;
repl.Publisher = this.Publisher;
repl.PublisherDatabase = this.PublisherDatabase;
repl.PublisherLogin = this.PublisherLogin;
repl.PublisherPassword = this.PublisherPassword;
repl.Publication = this.Publication;
repl.Subscriber = this.Subscriber;
repl.SubscriberConnectionString ="Data Source=" +dbFile;
if (!System.IO.File.Exists(dbFile))
{ repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
IIS is configured, but in log on the server we've got this error:
2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgent

View 3 Replies


ADVERTISEMENT

How To Connect ADODB With Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider For Microsoft SQL Server Compact 3.5)

Sep 12, 2007

Hi
We are checking VB 9 (Orcas).

we connected to database created under with sql server 7. with this code

Public cn As New ADODB.Connection

Public Sub OpenDB()


cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")

End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).

Rgds
Pramod

View 7 Replies View Related

SQL Server Compact Edition Merge Replication Error

Feb 27, 2007

Hi
I am trying to complete sql server compact edition book online walkthrough "Creating a Mobile Application with SQL Server Compact Edition". I am successful to complete it as guided using all default settings (e.g. anonymous access, windows authenticaion etc.) and the sample run on both emulator and my pocket pc svc5000. I have following configuration..

Windows 2000 professional sp4
Sql server 2005 standard edition sp1
VS 2005 profesional edition (sp1 not installed)
Sql server compact edition
Sql server compact edition server tools

But the problem is that in production environment i will not be able to connect to the sql server using named instance (e.g machine_nameinstance_name). i have to use ip address in that situation. so i tried to modify the sample to use ip address in place of named instance and then the problem starts.. I have configued my sql server to allow remote connections using tcp/ip and named pipes using sql surface area config tool.

When using named instance i used following code to Synchronize with sqlserver 2005 with and it worked perfectly :

Dim filename As New String("Program FilesTestTest.sdf")
Dim repl As New SqlCeReplication()
repl.InternetUrl = http://machine_name/Test/sqlcesa30.dll
repl.Publisher = "machine_nameinstance_name"
repl.PublisherDatabase = "Test"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "Test"
repl.Subscriber = "Test"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';"
Try
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()
Catch err As SqlCeException
MessageBox.Show(err.ToString)
End Try

When i tried to do replication using ip address it shows following error:

System.Data.SqlServerCe.SqlCeException was unhandled
  HResult=-2147467259
  Message="Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect."
  NativeError=29061
  Source="Microsoft SQL Server Compact Edition"
  StackTrace:
       at System.Data.SqlServerCe.SqlCeReplication.Synchronize()
       at TEST.MainModule.Sync()
       at Test.MainModule.Main()

I am using following code to connect using ip address:

Dim repl As New SqlCeReplication()
repl.InternetUrl = http://XXX.XXX.XXX.XXX/test/sqlcesa30.dll
repl.PublisherNetwork = NetworkType.TcpIpSockets
repl.PublisherAddress = "XXX.XXX.XXX.XXX,XXXX"
repl.Publisher = "SQL2005"      'instance name of sql in sql2005
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.PublisherDatabase = "Test"
repl.Publication = "Test"
repl.Subscriber = "Test"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';"
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()


I have give rights to iuser_manchine_name in the public access list of publication and on database also.

I don't have any idea on where i am wrong... Please help soon..
Many thanks in advance..

View 1 Replies View Related

Microsoft SQL Server 2005 RTM Merge Replication Issues

Jan 9, 2007

We are trying to implement merge replication between 2 servers. Database size is around 11GB.

When I tried to create publication, snaphot agent is failing with following errror.

Error: 14151, Severity: 18, State: 1.
Replication-Replication Snapshot Subsystem: agent NBTENTSQL1X-PayDirectWeb-PayDirectPub-2 failed. The
replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
Exception Message: String or binary data would be truncated.
Cannot find the object 'MSmerge_sel_4D388


The table where the snapshot is breaking contains around 169 columns. Can someone please help me get through this error ?





View 6 Replies View Related

SQL Server Mobile Merge Replication Walkthrough, Cant Find The .NET Framework Data Provider For SQL Server Mobile Edition.

Sep 9, 2005

Hi,

View 3 Replies View Related

Cannot Connect To A Named Instance Of SQL Server From Compact Framework 2.0

Mar 14, 2008

I have two instances of SQL Server on the same PC:

Default instance: SQL Server 2000
Named instance with name €śMS2005€?: SQL Server 2005.
Also I have another SQL Server 2005 on another PC.

I created a .NET 2.0 Compact Framework application that connects to the database and executes simple query. This application can connect to any instance of the SQL Server when it is executed on the PC (not on the server). But the problem is that when I try to execute the application from the windows CE 5.0 device, the application can only connect to the default instance (SQL 2000 and 2005) and can not connect to the named instance (Name: MS2005).
Is it some kind of limitation of the SqlClient library for the compact framework?

Below are the code and connection strings:

string connectionString = €śServer=1.1.1.1;Database=DB1;Uid=sa;Pwd=€?
string connectionString = €śServer=1.1.1.1\MS2005;Database=DB1;Uid=sa;Pwd=€?

using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open(); //This is the point where exception is generated

using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = "select count(*) from users";
object result = command.ExecuteScalar();

Console.WriteLine("Result: [{0}]", result);
}

connection.Close();
}


Thank you for your time and advice.

View 7 Replies View Related

Is 2005 Merge Replication Reliable For Compact Edition Subscribers On WinXP Tablets Over VPN?

Oct 24, 2007


I posted a more detailed technical question a couple of weeks ago
with Subject = "Compact Edition 2005 Subscribers - Merge Agent failed after detecting that retention-based cleanup has deleted metadata"
But I got no replies.

Now my question is simpler: Is SQL Server 2005 Merge Replication reliable with Compact Edition subscribers on WindowsXP tablets?

We deleted all users' local databases a couple of weeks ago, and republished two publications with retention = 60 days.
Now we have at least one user who can't sync with the server, and replication monitor shows the error below.
But if she e-mails her sdf file to a support person, they can successfully sync her database.
We're sure that it's not a permissions issue, which is a normal suspicion when one user can perform a task that another can not.
It doesn't seem like a retention problem, because she's well inside the retention period.
She can successfully sync with the publication with upload/download tablers, but not with the publication with download only tables. Both publications were created on the same day, by the same DBA, with nearly identical properties.

This problem user has operated in the past with no problem, and she's configured identically to all of the others. It just seems like random flakyness with merge replication for Compact Edition subscribers.

I feel stupid saying that, because it sounds like I believe in a magical ghost in the machine. So my question is - IS MERGE REPLICATION A LITTLE BIT FLAKY FOR COMPACT EDITION SUBSCRIBERS ON XP MACHINES?


We've applied SP2 to the server, but no subsequent HotFixes.

We're trying to sell users and management on developing a larger occasionally connected system with the same replication scheme, so we need to know if it deserves our confidence.


Error messages:

The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)
Get help: http://help/MSSQL_REPL-2147199402

View 2 Replies View Related

Failed To Find Or Load The Registered .Net Framework Data Provider When Using SQL Server Compact Edition

Jul 3, 2007

Hello



I have recently downloaded Orcas beta VS product and had no previous version of VS before. The install went clean and I have been able to generate Window apps and web apps with very little issues; however, I have one issue with running a web app using the "view in browser" option for checking an aspx page for validity. If I use the default Northwind database provided and generate an aspx form using the "DataSet" toolbox widget, the tool prompts for the datasource etc. required to generate the required code. I can select the Northwind database and select the desired columns from one of the tables. Once completed, I build the project (clean build) and then select the "view in browser" option to verify the results. The result is an error page indicating a server error ->
Failed to find or load the registered .Net Framework Data Provider.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.



I created on odbc connection to an iSeries(as400) box and was successfull in displaying the table on the webpage! I looked into the web.config file and it appears that all the required XML data is present. Any help would be appreciated as I am fairly green when it comes the .NET world.



Thanks

View 5 Replies View Related

SqlServerCEResultSet To XML?? In Compact Framework 3.5?

Mar 26, 2008

you can, with a dataset  do something like myDataSet.WriteXml(m_XmlFile, XmlWriteMode.IgnoreSchema) and get XML for a record....
 is it possible to do something like that with SQLserverCeresultset?
i know i could probably loop thru the columns and create the xml manually...  but using somethinglike writexml will give better performance?
 right now im not using anything from the XML class... from my previous exp with using XML classes on the Compact framework gives slow performance...

View 1 Replies View Related

Microsoft SQL Server Compact 3.5 Samples

Dec 20, 2007

Hi,

I'm looking for the sample application : IBuySpy Delivery Sample Application (SQL Server Compact). But I could not find this sample file anywhere.
The only sample which is available in my local directory below is Northwind.sdf file
C:Program FilesMicrosoft SQL Server Compact Editionv3.5Samples

The link in the Book Online is pointing to this URL below :
http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff0529a-eb1f-4044-b4b7-40b00710f7b7&displaylang=en

Can anyone help me on this?
Thanks,

View 6 Replies View Related

Can't P/Invoke Sqlceme35.dll With Headless Compact Framework

May 19, 2008

I am aware of the many posts that have addressed this issue in the past - I resolved this issue many months ago when it first happened to me. However, I have recently created a headless version of my Windows CE 6.0 based project that uses the Headless versions of the Compact Framework and this problem has suddenly re-surfaced. As in my UI equipped versions, the SQL CE cab files are copied to the device and have been installed. I have also tried copying the sqlceme35.dll to the application folder. The only real difference I can see is that the device is using the headless version so I suspect that there may be some incompatibility.

Has anyone successfully deployed a SCQL CE aplication to a headless device and if so were there any special steps that had to be taken to make it work?

Thanks

View 3 Replies View Related

I-Mate JasJar And Compact Framework Installation Problem ?

Dec 24, 2006

Hi everyone here

 

i have a little problem :

i tried to install the compact framework onto my pocket pc with windows mobile 5.0

but the installation fiailed and gave me an error .

the error message said that :

 the version of installation is not specified for this version of

 operating   system  ..

so what can i do to install compact framework on the device ?

 

please help !

View 8 Replies View Related

How Can I Get My Desktop App To Talk To My Windows CE Device In Vb.net Compact Framework?

May 9, 2008

HI all,

Que 1.

M doing PDA Project in Vb.net Compact framework [ CF ]. In tht I need to do synchronization My PDA's database with Desktop Computer's database manually.
So Plz Suggest me some options .....
One of them I know & Its RAPI..
--> "RAPI allows desktop based applications to talk with CE devices while they're connected to the desktop via ActiveSync".

but M confused regarding ActiveSync Bcoz i want to do it Manually.

Thnx & Regards

Amit B. Master

View 3 Replies View Related

System.Data.SqlServerCe Desktop Vs Compact Framework

Aug 7, 2007

How can I tell if the System.Data.SqlServerCe assembly I am referencing is meant for Desktop use as opposed to Compact development? We are using NUnit as our testing framework and I get the following error when I attempt to execute nunit-console on my test fixture referencing SqlServerCe:

System.IO.FileLoadException : Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---->

System.IO.FileLoadException : Could not load file or assembly 'System.Data.SqlServerCe, Version=3.0.3600.0, Culture=neutral, PublicKeyToken=3be235df1c8d2ad3, Retargetable=Yes' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)


The unit tests run fine from inside of Visual Studio using the Resharper Unit Test Runner...

Matt

View 1 Replies View Related

JDBC Driver For Microsoft SQL Server CE / Compact Edition

Jul 10, 2007

Hi,

I have a J2EE based web application. There is a requirement where user triggers a process to query a database, and the application needs to save the results to an SDF file (Microsoft SQL Server CE 2.0 / Microsoft SQL Server Compact Edition) database. I need JDBC driver for it, but could not find it anywhere. Please help. Also, if there is any alternate way to do this, please let me know.

Thanks,
Vaibhav

View 3 Replies View Related

HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)

Apr 4, 2007



Hi all,



I am trying to access my SQL Server database through SqlCeConnection:



cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");

cecon.Open();



I am getting the following error:



System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()





When I tried to get the path from which the database file is being accepted, I got a different path:



string path;

path = System.IO.Path.GetDirectoryName(

System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

MessageBox.Show(path);



This code gives me this path:



Program Filesddbpda





Then I changed the path in my connection string to this:



cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");

cecon.Open();



When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).





What should I do now to correct this?



Thanks in advance.

Saswata.



View 3 Replies View Related

HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)

Apr 4, 2007



Hi all,



I am trying to access my SQL Server database through SqlCeConnection:



cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");
cecon.Open();




I am getting the following error:



System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()






When I tried to get the path from which the database file is being accepted, I got a different path:



string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);






This code gives me this path:



Program Filesddbpda






Then I changed the path in my connection string to this:



cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");
cecon.Open();






When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).





What should I do now to correct this?



Thanks in advance.



Saswata.

View 5 Replies View Related

RDA Pull Error Using Microsoft SQL Server Compact Edition 2005

May 20, 2007

Hello dear all.



I am using a Compact Framework 2.0 on a mobile 5.0 with a local Microsoft SQL Compact Edition 2005 database. The backend database is a Microsoft SQL Server 2005 and I am trying to pull a 45000 rows table (the table has 2 varchars(8) forming a primary key and an INTEGER column).



The statement I issue is the following:

rda.Pull(table.TableName, table.TableQuery, Program.RdaOleDbConnectionString, RdaTrackOption.TrackingOnWithIndexes, table.TableName + "Errors");



The application works perfectly when I am pulling smaller tables (up to 15000 rows) but when I try to pull this one I get the following error details:



sqlCeEx
{""}
base {System.SystemException}: {""}
Errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
HResult: -2147024882
Message: ""
NativeError: 0
Source: "Microsoft SQL Server Compact Edition"


Please have in mind that the handheld on which I deploy does not have an extra storage card.



I have done a thorough internet search and I have found no solution to this problem. I truly rely on you to find the solution.



Thanks in advance,



Steliosvcy.

View 5 Replies View Related

Microsoft SQL Server Management Studio Express Version To Use For SQL Compact

Jan 18, 2007

Hello,

i don't know if it was mentioned before, but i solved the issue that Microsoft SQL Server Management Studio Express won't show the option to create/modify a sql compact database by installing not this Version:

Microsoft SQL Server Management Studio Express
Date: 19.04.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en

but this one:

SQL Server Management Studio Express Service Pack 2 €“ CTP-Version
Date: 19.12.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=ccbda432-8ecf-4c82-bdef-b575eaf07f55&DisplayLang=en

hope this helps.

Nihat

P.S. i'm curious if anybody else had the same issue, caused of using the wrong Version of  SSMSe?

View 1 Replies View Related

How To Get A Microsoft SQL Server Compact 3.5 Database Multiuser Work On A Network Share

May 21, 2008

Hello All,

I need some advise/help how to deploy a small sql server compact 3.5 database on networkshare where about 8 people have access to it(install de client ) and can modify the database with aprox 3000 records.
I'm using visual basic 2008 and created a compact database and filled it with one table of an export of an access database done with data port console.
And created a new windows forms application and saved the project.
Publish is not the problem but how too set it up......
There is not much info to find on how to get a sql server 3.5 database running on a network share.
Who can help ???


Thanks


View 2 Replies View Related

Limit On Blob/image Data Type In SQL Compact 3.5 SP 1 BETA For ADO Entity Framework?

Apr 5, 2008

Hi! I tried to save some image data, but it get truncated at 8000 (the table column is defined as Image). I then wrote a converter to try ntext-datatype instead, but it gets truncated at 4000.


Error message:
System.Data.SqlServerCe: @3 : String truncation: max=4000, len=4168


The code uses only ADO entity framework for database access. Is there a way to store binary data larger than 8000 bytes? I am running SQL Compact 3.5 sp 1 BETA.


Henning



View 7 Replies View Related

Microsoft.NET Framework 2.0 On EM64T

Dec 6, 2005

Hi All,

View 3 Replies View Related

CompactDatabase In ASP With SQL Server Microsoft SQL Server Compact

Jul 2, 2007

I've been playing around with Microsoft SQL Server Compact Edition
v3.1 as a posible replacement for the SQL Server CE 2.0 (can't
remember exactly what the called it). Its working pretty well. I
was able to connect to the database using the same recordset object,
ADODB.RecordSet and connection object, ADOCE.Connection.3.1. However
where I've run into trouble is when I try to compact the database.
This code works on 2.0.

srcConn = "Provider=Microsoft." & "SQLServer" & ".OLEDB.CE.2.0;Data
Source=myDB.sdf"
destConn = "Provider=Microsoft." & "SQLServer" & ".OLEDB.CE.2.0;Data
Source=myDB.sdf"

Set DBEngine = CreateObject("SSCE.Engine.2.0")

DBEngine.CompactDatabase srcConn, destConn

But now when I try to run it vor v3.1

srcConn = "provider=microsoft.sqlserver.mobile.oledb.3.0;data
source=myDB.sdf"
destConn = "provider=microsoft.sqlserver.mobile.oledb.3.0;data
source=mDB1.sdf"

Set DBEngine = CreateObject("SSCE.Engine.3.0")

DBEngine.CompactDatabase srcConn, destConn

I get this error message:

Info: Object required: 'DBEngine'

As I understand it SSCE.Engine.3.0 is still an ActiveX
object. Is it no longer posible to run this directly from
asp?

View 1 Replies View Related

Failed To Generate ResultSet Code. Typed ResultSets Are Only Valid For Microsoft SQL Server Compact 3.5 Databases

Feb 27, 2008



I get the error above when I do the following.

Using VS 2008 I got a Windows Smart Device project targeting WM6 Standard and using .NET CF 3.5.
I add a new database file = creating an empty Compact 3.5 database (creates an sdf-file in my project).
Then create an empty dataset in the wizard (creates an xsd-file in my project).
Then I add a couple of tables in the database.
After that I want to use my earlier created dataset.
I mark the xsd-file and looks in Poperties.
I get the error when I try to change Custom Tool value from 'MSDataSetGenerator' to 'MSResultSetGenerator'.
Why????

View 1 Replies View Related

Help - SQL Server 2005-&>Compact Edition Replication

Jan 30, 2007

Hi All ...I
have been following the MS on-line tutorials to get replication setup
between SQL Server 2005 and SQL Server Compact Edition. I get to the
point where I run the Configure Web Synchronization and it is running
through the process where it is doing the automated configuration of
the shared directory - assigning users etc.I have attempted
this step with a user account that I expressly created for snapshots
and with the Administrator account and get the following error message:* The operation completed successfully. (Exception from HRESULT: 0x80070000)At
first, I thought this was a rights issue due to the fact that I was
using an account that I manually created. However, by using the
Administrator account (test only until I can figure this out) that
should have removed any rights issues associated with accessing the
shared directory where the snapshot will reside.Any help in getting this figured out will be greatly appreciated.David L. Collison Any day above ground is a good day!

View 9 Replies View Related

Compact Server Database-file Not Enabled For Replication

Apr 23, 2008

When I try to create a subscription to my SQL Server Compact 3.5-database file, it gives an SqlCeException-message that says that the file is not enabled for replication. How do enable it?

My SQL Server Management Studio won´t connect to my compact server file right now, so that method is not an option for me right now.

View 1 Replies View Related

Compact Framework SqlClient Classes Don't Actually Inherit From System.Data.Common.Db* Classes?

May 23, 2007

As you all know, in Framework 2.0 on the desktop platform you have the convenient "abstract" Db* classes that can be used to write more generic code. For instance System.Data.SqlClient.SqlConnection inherits from System.Data.Common.DbConnection, and so forth. Now the docs clearly say that this applies to the corresponding classes in the Compact Framework. And i have seen this implied by other web searchs I've done. However this does not seem to be the case -- or, I'm missing something somewhere.

The following simple code on the desktop platform compiles OK:

using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
DbConnection conn = new SqlConnection();

However it doesn't compile in a compact framework project: "Cannot implicitly convert type 'System.Data.SqlClient.SqlConnection' to 'System.Data.Common.DbConnection'".

Reflector also indicates that the Compact Framework class doesn't inherit from DbConnection.

OK, so am I missing something here, or what was the reason that Microsoft did it differently??

View 1 Replies View Related

Creating A New Connection With Microsoft SQL Server 2005 Compact Edition From Visual Studio 2005 IDE

Jul 25, 2007



Hello, How are you?
I have a problem when I try to create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE. When I€™m going to choose the data source, the SQL Server 2005 Compact Edition provider doesn€™t appear in the list. I installed the SQL Server 2005 Compact Edition from this page http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en. In the additional information says by installing SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). So, I don€™t understand why couldn€™t I create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE?



I appreciate your help€¦

View 6 Replies View Related

Framework 3.0 In OS, Need Framework 2.0 For SQL Server 2005

Sep 22, 2007

Hi,

Can anybody help me with the following problem:

I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0
Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0
Can't install 2.0, get the message that 3.0 is already installed.
Please help me!!

René

View 5 Replies View Related

Does 64-bit Version Of SQLServer Compact In Microsoft's Develop Schedule?

Nov 11, 2007



I am looking forward to a native 64-bit file-based database solution on Microsoft Windows platform. And I don't know why Microsoft didn't release the native 64-bit solution for JET engine (MDB file).

So, before I using this light-weight and file-based version of SQL Server, I will like to ask the question that the 64-bit version has been put into develop schedule?

Thanks.
Alva

View 1 Replies View Related

SQL Server Two Merge Replication

Mar 3, 2004

Dear DBforum members

I have a problem Setting up pull subscription from a publishser to a subscriber , but I could set up Push subscription with out any problem between these two server .. can any one help me out.

I run SQL Server 2000 Enterprise edition.

I get the following error

"Publication 'ProdDB' does not exist. The step failed."

where ProdDB is the publication database from which my Push subscription is running.

thanx
Logs

View 1 Replies View Related

MS SQL Server Merge Replication

Jul 20, 2005

Hi, I have two databases on MS. SQL Server 200 the first one is themain DB and the second one is a replica of it, both of them indifferent territories .I connect them using merge replication justwhen I need to merge the data.The problem is when I make import data or export data from anylocation (MS access ,MS SQL server ) to the second one (subscriber DB)or the main DB(publisher and distributor ) ,the imported data doesnot replicated to the other DB ???Normal transaction replicated smoothly.I hope you can help me.Thanks in advance.Mahmoud Khebaisa.

View 1 Replies View Related

Federation/replication - DB2 && Microsoft SQL Server 2000

Dec 17, 2005

Hi all,

I'm new to this forum, though not new to sql server am new to DB2.

We are running Microsoft SQL Server 2000 but we have recently acquired similar business in another country which runs IBM DB2 database system. We are interested in incorporating the data from DB2 in our system. The tables are slightly different in DB2.
Q. what is the best way to integrate the two systems? Should we take the route of a federated system or replication of data?
We are interested in knowing what is happening in the other business (DB2) but we what the two systems to operate in parallel for about a year, before we come up with the best solution.

The company is after a short term and long term solution.

Can any one please help or point me to the right place?

Regards,
Chloe.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved