SQL Server 2005 Mobile Edition ANd SQL Server CE - SHould I Have Uninstalled Mobile First ?
Hi:
When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.
All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?
Any help would be appreciated I"m just starting to use SQL CE.
thanks
mark
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Mobile 2005 And SQL CE - Should I Have Uninstalled Mobile 2005 First ?
Hi: When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not. All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ? Any help would be appreciated I"m just starting to use SQL CE. thanks mark
View Replies !
SQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0
Dear ppl, I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using -MS .NET Compact Framework 2.0 SP-1 -SQL Mobile 2005. -VS 2005 .NET The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object. "SQL Server Mobile encountered problems when opening the database." repl.AddSubscription(AddOption.CreateDatabase); repl.Synchronize(); I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order. -sqlce30.wce5.armv4i.cab -sqlce30.repl.wce5.armv4i.cab -sqlce30.dev.ENU.wce5.armv4i.cab However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it. The target platform for the project is Windows Mobile 5.0 Pocket PC SDK. Does any one have any clue what could be the problem ? Regards Nabeel
View Replies !
Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application
Hello, I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database. The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration. The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK. So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h". Did I miss something to install ? Do you know how I can resolve the problem ? By advance, thank you for any answer. -- Gregoire
View Replies !
SQL Server 2005 Mobile Edition Vs. RMS
Hello, I am developing a mobile application in which i have to create a database.. My database contains relationships between its tables.. I would like to know what is the best solution for developing the database?? SQL mobile edition or RMS!!! If you say RMS, how should i create the relationships between my tables?? thnx
View Replies !
Update Sql Server 2005 Mobile Edition
I have use this guide to make a application for windows mobile 5.0. http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm Everything is work. I can add, remove data in the dataset. But i can't update the sql server database. can somebody tell me whats wrong? Nitro.
View Replies !
SQL Server 2005 Mobile Edition Free?
Hello I have a question: is the SQL Server 2005 mobile edition free? or is it necessary to buy a licence when i use it combinated with a comercial program which i have delevoped by myself and i sell it? greetings stefan lederer
View Replies !
Creating SQL Server 2005 Mobile Edition On Desktop
Hello Everybody I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application. Anybody having this solution for this prob. Regards Chikuu
View Replies !
Memory Usage Of SQL Server 2005 Mobile Edition
Hi forum readers, we are working on a release 2.0 mobile solution right now. In our version 1.0 we did not have to worry about memory issues as our application was the only application running on our target devices (e.g. T-Mobile MDA Compact II Pocket PCs, WM2005). Now we need to share the available memory with others. As our application relies on its SQL Server 2005 Mobile Edition database we are wondering about memory usage of that server. We know that a Pocket PC divides its memory into Storage and Program. If our application uses a 5 MB database and 1.5 MB for DLLs and it's exe-file. These files reside in the storage space when not loaded. When the application starts up it is loaded in the program memory. What happens to the 5 MB database file? Is is loaded into Program memory as well? Are only portions of that file loaded? Or is nothing loaded at all? Does anyone have a deeper insight into that server an can answer my questions. Best regards, Tobias
View Replies !
SQL Mobile Server 2005 To SQL Server Developer Edition 2000
I am looking for a detailed tutorial that explains how to set-up merge replication services for a major project. I have seen all of the claims that SQL Mobile Server 2005 is able to connect to a merge publication with SQL Server 2000. However, where are the tutorials? I must have a proof of concept in a few days to quote this project. Can anybody help with this issue? Thanks!
View Replies !
Mobile Solution With SQL Server 2005 Express Edition And Smartphone
Hi,i want to create a solution which shall consist of a sql server 2005 -data base (express edition if the following features are available byexpress edition) and a mobile windows application (running on asmartphone under windows mobile 5.0).The sql server shall be installed on a ordinary laptop using windowsxp (not professionall edition).Which would be the best way to exchange the data between mobile deviceand pc? I learned that there is a SQL Server Compact Edition for themobile device and that rda would be a way to exchange data - but theni would need internet information system and this does not run on xphome edition.Which alternatives would you suggest me?Thanx in advanceWolfgang
View Replies !
SQL CE 3.0 SQL Server 2005 Mobile Edition Database Password Problem
Hi, I was wondering if someone could help me as this is a bit of a puzzle. I have created a database using a password, the create table scripts are executed successfully using the connection string however when I try and use the same connection string to insert some data into the database an error is produced, with the following message 'The specified password does not match the database password'. I have opened the database using the SQL Server 2005 Management Studio and provide the password and I can access the database without a problem. When the connection object is first instantiated all the Connection String property, the connStr variable and the modifiedConnStr are all correct (by this I mean that the data source and the password are present). However when the connection object is accessed again the Connection String property and the connStr variable are both set incorrectly (by this I mean that the password= section of the string is missing) however the modifiedConnStr is set correctly (by this I mean that the password= section is present in the string). The connection object does not get set in between creating and accessing the connection object. I have resorted to using no password, however I really need to be able to use a password. Here is a copy of the connection string I am using (Copied directly from the quick watch window): "Data Source = '\Program Files\Application\DataBase\MyDatabase.sdf'; password="Pa55word";" I am sorry this a little long winded however I would like to provide as much information as possible. I hope someone can help me with this problem. Thank you for reading. Paul Diston
View Replies !
SQL Server 2005 Mobile Edition Using Server Tools
I have installed SQL Server 2005 Mobile edition and also the server tools. I configured a website to sync with my mobile application. When I go t check the SQL server Mobile agent with this url: http://localhost/MobileTest/sqlcesa30.dll i get a http 500 internal error I am using remote desktop to access the machine, when I am directly on the machine there is no error I get the correct message in the browser "SQL Server Mobile Server Agent 3.0" Is access to the web site via remote desktop a problem? jawahar
View Replies !
SqlCeConnection Failing To Open A Connection To The SQL Server 2005 Mobile Edition
Good day, I am writing an application using VB.Net 2005 for the Windows CE 5.0 device and it is connecting to a SQL Server 2005 Mobile Edition Database. The trouble I'm having is establishing a connection to a SQL Server Mobile database on the device. Here is the code I am using: Code Snippet Public gConnectionString As String = "Data Source=Program FilesMobAppMobDB.sdf;Persist Security Info=False;" Code Snippet Imports System.Data.SqlServerCe Public Class DBManager Public Shared gSQLCEConnection As SqlCeConnection Public Shared Function OpenDB() As Boolean If gSQLCEConnection IsNot Nothing Then Throw New InvalidOperationException("Connection already open.") End If gSQLCEConnection = New SqlCeConnection(gConnectionString) Try gSQLCEConnection.Open() 'Error occurs here Return True Catch ex As SqlCeException MsgBox(ex.Message & vbCrLf & ex.HResult & vbCrLf & ex.NativeError & vbCrLf & ex.Source) Return False End Try End Function In the immediate window I recieve the following messages: A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll I believe that the first few lines are caused by the icons/pictures that I have included with my app, but the SqlCeException line occurs when the connection to the .SDF file is trying to be established. Here is the exception output: Message: "" (Blank) HResult: -2147024882 NativeError: 0 Source: SQL Server 2005 Mobile Edition ADO.NET Data Provider Programs under Remove Programs on the PDA are: Microsoft .NET CF 2.0 ENU-String R... Microsoft .NET Compact Framework... Microsoft SQL Client Microsoft SQL Mobile 2005 Microsoft SQL Mobile 2005 [EN] Microsoft SQL Server 2005 Compact... Microsoft SQL Server 2005 Compact... Microsoft SQL Server 2005 Compact... Microsoft SQLCE 2.0 Microsoft SQLCE 2.0 Dev Any ideas on what could be stopping this connection from being established? It was working before but all of a sudden just stopped. I have warm booted, cold booted, and rebuilt with no luck and also checked that SQL Query Analyzer is not running on the PDA and that the connection string is valid. The call to OpenDB occurs in the form_load of the startup object. Thanks in advance, Leon
View Replies !
Query Performance Issue Of Sql Server 2005 Mobile Edition On Device
Executing a select query with left outer joins etc takes .53 seconds to execute on sqlce 2.0. Same query on sql 2005 mobile ed. takes 11 minutes . on database having same data. Sample query SELECT routes.location,routes.equipment_type, routes.contract_type, routes.maintenance_interval,routes.bank_description,routes.Unit_Des, routes.Unit_no,max(task_last_completed.date_completed)as date1,min(case when task_last_completed.due_date is NULL then getdate()-1 else due_date end) as due_date FROM routes left outer join tasks on tasks.model = routes.model and tasks.eqtyp = routes.equipment_type inner join task_by_contract_type on tasks.task_id = task_by_contract_type.task_id and task_by_contract_type.contract_type = routes.contract_type and task_by_contract_type.model = routes.model left outer join task_last_completed on routes.unit_no = task_last_completed.equipment_Id and tasks.task_Id = task_last_completed.task_Id WHERE routes.location LIKE 'S153825-01%' group by routes.location,routes.equipment_type,routes.contract_type,routes.maintenanc e_interval,routes.bank_description,routes.unit_des,routes.unit_no ORDER BY routes.location, routes.bank_description, routes.Unit_Des WHY????????????????
View Replies !
Help Needed In Merge Replication, SQL Server 2005 Mobile Edition And VC# 2005
I have written following code in my application I just want to display all the data of a Single table into a Data Grid, I know that we can drag and drop the table on to a form and datagrid is generated, but here I want to retrive those values through my code, how should i do that I am getting following errors while running the program Error 1) Error No. 28037, MS SQL Server 2005 Evrywhere Edition Error: A request to send data to the computer running IIS has failed. For more information see HRESULT Error 2) Error No. 0, SQL Server 2005 Evrywhere Edition ADO.Net Data Provider Error: The specified table does not exist [ JobLists ]. Can anybody please tell me, where I went wrong ??? In this code anywhere else???? Note: While adding a Data Source of SQL Server 2005 Mobile Edition, I have added that .sdf file into my project, thats why I have written the Data Source as : .DbFile.sdf @"Data Source = .DbDotNetCF.sdf"; The code is as follows: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlServerCe; namespace DeviceApplication1 { public partial class Form1 : Form { string filename = @".DbDotNetCF.sdf"; private DataSet dsJobLists; public Form1() { InitializeComponent(); } private void DeleteDB() { if (System.IO.File.Exists(filename)) { System.IO.File.Delete(filename); } } private void Sync() { SqlCeReplication repl = new SqlCeReplication(); repl.InternetUrl = @"http://localhost/WebsiteDotNetCF/sqlcesa30.dll"; repl.Publisher = @"RAHU"; repl.PublisherDatabase = @"DotNetCF"; repl.PublisherSecurityMode = SecurityType.NTAuthentication; repl.Publication = @"PubDotNetCF"; repl.Subscriber = @"SubDotNetCF"; repl.SubscriberConnectionString = @"Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;"; try { if (!System.IO.File.Exists(filename)) { repl.AddSubscription(AddOption.CreateDatabase); } repl.Synchronize(); } catch (SqlCeException ex) { DisplaySQLCEErrors(ex); } finally { repl.Dispose(); } // Display Same Data In Another DataGrid : dataGrid1 SqlCeConnection cn = new SqlCeConnection(@"Data Source='" + filename + "'"); SqlCeDataAdapter daJobLists = new SqlCeDataAdapter("SELECT JobListsID, JobID, PersonID FROM JobLists", cn); if (dsJobLists == null) { dsJobLists = new DataSet(); } try { dsJobLists.Clear(); daJobLists.Fill(dsJobLists, "JobLists"); dataGrid1.DataSource = dsJobLists.Tables["JobLists"]; } catch (SqlCeException ex) { DisplaySQLCEErrors(ex); } } private void DisplaySQLCEErrors(SqlCeException ex) { for (int i = 0; i < ex.Errors.Count; i++) { MessageBox.Show("Index #" + i.ToString() + "" + ex.Errors.Source + "" + "Error: " + ex.Errors.Message, "Error No. " + ex.Errors.NativeError.ToString()); } } private void Form1_Load(object sender, EventArgs e) { Sync(); DeleteDB(); if (DbDotNetCFDataSetUtil.DesignerUtil.IsRunTime()) { // TODO: Delete this line of code to remove the default AutoFill for 'dbDotNetCFDataSet.JobLists'. this.jobListsTableAdapter.Fill(this.dbDotNetCFDataSet.JobLists); } } } } I have created a merge replication correctlly( I suppose, there were no errros) Please help Your help will be appriciated
View Replies !
Cannot Build SQL Server Mobile Solution For Windows Mobile 5
Using MS VS 2005 (incl SQL Server Mobile) MS Pocket PC 2005 SDK I am working on a project that builds for Pocket PC on both Mobile 2003 and Mobile 5. The project uses/will use SQL Server Mobile to store local data. Project created from new with support for both platforms. I include required header files ssceerr30.h and ssceoledb30.h. Project builds fine in WM2003 configuration, release and debug. When I build for WM5 the compiler cannot find the header file transact.h. This is included from within ssceoledb30.h. Same as under WM2003. In WM2003 configuration if I highlight the ssceoledb30.h include in Visual Studio and open the header, it takes me to <Visual Studio dir>SmartDevicesSDKSQL ServerMobilev3.0. I then locate the include for transact.h and do the same, which takes me <Visual Studio dir>SDKPocketPC2003include. The file exists. If I repeat the above 'browsing' under the WM5 configuration, ssceoledb30.h takes me to a different copy in the WM5 SDK directory. There is no diff between the file here and the other copy used by WM2003. If I attempt to open transact.h - file does not exist. Fix (which I'm not too sure about, i.e. is it OK?) - If I copy transact.h to the WM5 SDK directory, the project builds. Why has transact.h disappeared from WM5 SDK? I can find no ref's to this problem anywhere. Is my installation of the WM5 SDK corrupt? What else could I be missing? Is there a sample for SQL Server mobile (like the NorthwindOLEDB sample) that comes configured to build for WM5?
View Replies !
SQL Server Mobile Tutorial And Getting Proper Mobile DB Installation
Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem. I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information. I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles. The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message. My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it? Your time and any knowledge sharing is greatly appreciated. Thank you, -Dana
View Replies !
Isqlw For Sql Server Mobile Edition (sql Ce 3)
In sql ce 2.0 in window ce 2003, I use isqlw20.exe to create database and table. Developed application with eVC++ 4.0 Now I have to use window mobile 5, VS 2005 for native C++ development, sql server mobile edition, but I can't found isqlw for this version of sql. I do not have sql server install in my desktop PC. So how could I create database and table with the pocket pc's database ? Thanks.
View Replies !
Creating A Mobile Application With SQL Server Mobile - FIX
This is a great tutorial and it's a shame one of the more important steps was missed. In the €œCreate the snapshot user€? section you you find the steps to create the snapshot_agent account. Then in the €œCreate the snapshot folder€? section you find the share and folder permissions. However, at no point do the instructions advise you about adding the snapshot_agent to the SQL Server Logins. The result is that agent cannot perform the initial snapshot but you won't find this out until 50 steps later after Step 10 in the section €œCreate a new subscription". To get back on track, openthe Object Explorer's Security section and add the snapshot_agent to your logins. Then using the "User Mappings", set an appropriate level for the SQLMobile database role. Once completed you then need to run the agent. Right-click the SQLMobile publication you created and select "View Snapshot Agent status". From that dialog you can select "Start" to run the agent. When it completes, you can return to the tutorial section "Create a new subscription" and continue with the tutorial.
View Replies !
Creating A Mobile Application With SQL Server Mobile
I am studying the tutorial in SQL Server 2005 Mobile Edition Books Online, and the topic is Creating a Mobile Application with SQL Server Mobile. I have got a problem when creating a new subscription after created a new SQL Server Mobile database. And the problem is shown below: New Subscription Wizard - Beginning Synchronization (Success) - Synchronizing Data (100%) (Error) Messages * 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. HRESULT 0x80004005 (29061) * 無法完æˆ?作æ¥ã€‚ - Finalizing Synchronization (Stopped) - Saving Subscription Properties (Stopped) Before I have met this problem, I have finished all the task. And I can browse the localhost web site by using anonymous account even I use internet explorer or browse the directly in IIS. Does anyone can solve it?? Thank you very much~~~
View Replies !
SQL Server Compact/Mobile Edition Versions
I am confused about the version numbers for SQL Server Compact/Mobile. It _looks_ like the versions went from CE 2.0 to Mobile 2005 to CE 3.0 (or 3.1). Is this correct? In fact, I found one location the specifically said Compact Edition is the next version of Mobile. In another location I saw Compact Edition referred to as 2005 CE. This has got me going because I am creating a Mobile/CE app and I keep getting a "Initialize SQL Server Reconciler" and the best information I can find indicates a mismatch between the server component and the client component. So, what are the current versions of Mobile/CE? Is there a location that lists all of the components and what version they should be? Thanks. Chris Mecum
View Replies !
How Do I Use The Crosstab Query In Sql Server Mobile Edition
I can use crosstab query(intersection table) in sql server. for example : CREATE TABLE [Test] ( [id] [int] IDENTITY (1, 1) NOT NULL , [name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [subject] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Source] [numeric](18, 0) NULL ) ON [PRIMARY] GO INSERT INTO [test] ([name],[subject],[Source]) values (N'mike,N'math,60) INSERT INTO [test] ([name],[subject],[Source]) values (N'tom',N'English',70) INSERT INTO [test] ([name],[subject],[Source]) values (N'mike',N'france',80) INSERT INTO [test] ([name],[subject],[Source]) values (N'jane',N'English',75) INSERT INTO [test] ([name],[subject],[Source]) values (N'mary',N'france',57) INSERT INTO [test] ([name],[subject],[Source]) values (N'tom',N'math',80) INSERT INTO [test] ([name],[subject],[Source]) values (N'mike',N'Englist',100) Go -------- declare @sql varchar(8000) set @sql = 'select name,' select @sql = @sql + 'sum(case subject when ''+subject+'' then source else 0 end) as ''+subject+'',' from (select distinct subject from test) as a select @sql = left(@sql,len(@sql)-1) + ' from test group by name' exec(@sql) But I cannot use it in sql server mobile editon. HOw do I? thank you very much!!!
View Replies !
SQL Mobile 2005 Replication - SQL Mobile DLL Could Not Be Loaded - Error 28559
I am migrating a pocket PC application from VS 2003 to VS 2005 and a few weeks ago I hit the following problem when replicating A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name=sqlceca30.dll] Scanning forums for help I saw that other people had had this problem and one http://www.eggheadcafe.com/aspnet_answers/NETFrameworkCompactFramework/Feb2006/post25814466.asp suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications. I did this and it works a lot better now but ever so often I get another error which is Native Error 28559 SQL Mobile encountered problems when opening the database My only option at this point is to stop and start the application which cures the problem.
View Replies !
File Sharing Violation In SQL Server Mobile Edition
Hi, I am facing a wierd problem working with SQL Server Mobile edition database. The code works fine for some time and then it suddenly starts throwing "There is a file sharing violation. A different process might be using the file." I am disposing and closing the connection after each operation. Please find the function code below which is being used for any database operation. SqlCeConnection sqlCon = null; try { sqlCon = ConnectionFactory.getInstance().getPrimDsConnection(); sqlCon.Open(); readCmd = sqlCon.CreateCommand(); this.prepareStmtManyRows(); dataReader = this.readCmd.ExecuteReader(); IList result = this.populateManyRows(); return result; } catch (SqlCeException sqlEx) { StringBuilder builder = new StringBuilder( @"SqlCe Error in BaseReader.executeList() - ").Append( sqlEx.Message).Append(':').Append(sqlEx.NativeError); Log.getInstance().log(builder.ToString()); throw new DataAccessException(sqlEx); } finally { try { if( null != dataReader && ( !dataReader.IsClosed )) { dataReader.Close(); dataReader.Dispose(); } if( null != readCmd) readCmd.Dispose(); if( null != sqlCon) sqlCon.Close(); } catch (System.Exception ex) { } } I have also made sure that Query Analyzer is not running on my PDA. I have been working on this since last one week but could not find a soultion. Thanks, A Islam
View Replies !
Query: Master..sysservers In SQL Server Mobile Edition
Hi, I have a program in VB.NET 2003 where I have query "SELECT COUNT(*) FROM master..sysservers WHERE srvname = '" & strServerName & "'". This program copies data from .MDF file to another .MDF file. This query is written since I have created linked server. Issue 1: But now I to copy data from .SDF (SQL Server Mobile Edition) to desktop .MDF file. For this I cannot fire the above query on .SDF file. What is the other alternative? Issue 2: In the existing prgram that copies data from .MDF to .MDF, I have created linked server. Can I do the same with mobile edition? Regards, MI
View Replies !
Data Source Problem In SQL Server Mobile Edition
Hi, I am using SQLCE and VS 2005 to create a database named "student.sdf" (inside my projects folder, of course). When click on the button, it will test for connection of database. Everytimes I run the program, it will pop up an error message "The database file cannot be found. Check the path to the database. [File name = .student.sdf]". How do I fix it? Code Snippet Imports System.Data.SqlServerCe Public Class loginForm Private _conn As SqlCeConnection Private Sub ButtonLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonLogin.Click _conn = New SqlCeConnection("Data Source =.student.sdf") Try _conn.Open() MessageBox.Show("Correct") Catch ex As SqlCeException MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1) Finally _conn.Close() End Try End Sub End Class
View Replies !
Microsoft SQL Server Mobile Edition Data Source
i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true anyway, on the 5th exercise wherein i'm supposed to add a new data connection through the server explorer.. when i chose the option of adding a new data source and was prompted to select a data source i couldnt find the Microsoft SQL Server Mobile Edition data source.. is there anything else that i need to download in order to have that data source?
View Replies !
Replication Between 2000, 2005, && Mobile Edition (with Identities)
Hi, I have a server "A" (which is SQL 2000), a server "B" (SQL 2005), and mobile devices running SQL mobile edition. I need to set up transactional replication between server A & B (with A as the publisher/distributor), and then B needs to be setup with merge replication between it and the mobile devices. Basically I have mostly reference data being pushed out from server A (with only one or two updateable tables) to server B. The mobile devices then connect to server B via a web service, to receive the latest data. The mobile devices can update data, but send the updated data back to server B via another web service (not via merge rep). Server B then sends this updated data back to server A, also using a service (as apposed to native replication). The problem I have is that most tables have identity columns set as their primary keys. I've read about identity management, and would like to specify identity ranges for servers A & B, but this only seems to be possible when using merge rep (or tran. with updating subscribers), not normal (i.e. one-way) transactional rep. Is there a way to get around this? I was going to just replicate without worrying about having identities on the tables on server B, but of course it needs the primary keys (and therefore the identities) for its merge replication to the mobile devices. Any assistance would be hugely appreciated. Thanks, David
View Replies !
Uninstalled SQL SERVER 2005 Express But SQL Server 2005 CTP Component Not Uninstalled
hi, i tried to uninstall SQL Server2005 Express Edition which was installed as a component when i installed visaual studio 2005. i removed it from control panel, add/remove programs. but SQL server 2005 CTP component is still there in programs section. it is not removed. what should i do to completely remove all the related files of SQL server 2005 Express edition, as i want to use SQl Server 2000 for my project. plz reply asap.
View Replies !
SQL 2005 Mobile Edition Error: The Buffer Pool Is Too Small Or There Are Too Many Open Cursors.
I am working with merge replication. The db server is running Windows 2003 Server Std x64 with SQL 2005 Std x64. The IIS server is running Windows 2003 Server Stx x86. The clients are Windows Mobile 5.0 running SQL 2005 Mobile. I have previously been able to get the test client to initialize a subscription to the publication. I made some changes recently and added about 7 tables, bringing the total articles to 104. Some of the articles have unpublished columns, which means they are using vertical filtering as well. This publication is also using parameterized filters. During publication creation, there are several warnings that "Warning: column 'rowguid' already exists in the vertical partition". The snapshot agent runs without any errors. When the client attempts to initialize, I get the error "The buffer pool is too small or there are too many open cursors." My question is 2 part. First, what is causing this error, and second, how can it be resolved?
View Replies !
Use SQL Server Mobile On Your Desktop (create/use Sql Server Mobile Databases On Your Desktop)
After a little bit of search, I succeeded! Here are the guidelines for using an SQL server mobile dataset residing in your desktop computer on your desktop (populating a SQL Server mobile database on your desktop). At the end of the guidelines, I give a sample program to populate an sqlce database from a text file. I hope you will find these guidelines and sample program usefull. You may contact me at toncu@nospam.e-kolay.net (remove nospam for actual address) (You should have VS2005 and Sql Server 2005 installed on your desktop computer) 1. create a Windowsapplication project File->New Project Choose Windows in Project Types and Windows Apllication from Templates 2. Insert a reference to SQL Server Mobile Project->Add Reference->Browse c:Program FilesMicrosoft Visual Studio 8 Common7IDESystem.Data.SqlServerCE.DLL 3. Insert imports system.data.sqlserverce at the top of your form file 4. Write your application just as you would as if your project was a Smartdeviceapplication. i.e. use sqlconnection and other constructs. A sample application is as follows: (dbtableexist is a subroutine which shows how to process the SCHEMA. In this subroutine, change TABLES to INDEXES and TABLE_NAME to INDEX_NAME to search for an index) Imports system.data.SqlServerCe Imports System.IO Public Sub createaccessfile(ByVal a$) 'curdbpath is the path of the database e.g. d:my sql databases Dim connStr As String = "Data Source = " & curdbpath & a$ & ".sdf" Dim conn As SqlCeConnection = Nothing Dim command As SqlCeCommand Try conn = New SqlCeConnection(connStr) conn.Open() command = conn.CreateCommand() If dbtableexist(conn, "ACCESSFILE") Then command.CommandText = "DROP TABLE ACCESSFILE" command.ExecuteNonQuery() End If command.CommandText = "CREATE TABLE ACCESSFILE ( code nchar(20),field nchar(3),totalrecs nvarchar(255),indexbits ntext)" command.ExecuteNonQuery() command.CommandText = "CREATE INDEX codeindex on ACCESSFILE (field,code)" command.ExecuteNonQuery() Catch ex As SqlCeException Dim m1 = ex.Message Dim m2 = ex.Source Dim m3 = ex.NativeError MsgBox(m1 & m2 & m3, , "open " & a$ & " for accessfile creation") Exit Sub End Try ' Create and prepare a SQL statement. command.CommandText = " insert into accessfile values (?,?,?,?);" ' Read and insert the lines from the file until the end ' of the file is reached. Dim accfname As String = curdbpath & a$ & "_accessfile.inp" Dim fs As FileStream = New FileStream(accfname, FileMode.Open) Dim sr As New StreamReader(fs) Dim line As String, codestr As String, fieldstr As String, totalrecsstr As String, indexbitsstr As String Dim line1 As String, flagstr As String, field As Integer line = sr.ReadLine : line1 = line Dim currec As Integer = 0 ' Note: Even though named parameterized queries are not supported, we still need ' to provide unique parameter names so that we can manipulate parameter collection; command.Parameters.Add("@code", "a") command.Parameters.Add("@field", 1) command.Parameters.Add("@totrecs", "c") command.Parameters.Add("@indexbits", "d") Do currec = currec + 1 If currec Mod 10 = 0 Then dispcaption(Str(currec)) flagstr = before(line, Chr(9)) : line = after(line, Chr(9)) codestr = before(line, Chr(9)) : line = after(line, Chr(9)) field = Val(before(line, Chr(9))) : line = after(line, Chr(9)) totalrecsstr = before(line, Chr(9)) : line = after(line, Chr(9)) indexbitsstr = line Try command.Parameters(0).Value = codestr command.Parameters(1).Value = Format(field, "000") command.Parameters(2).Value = totalrecsstr command.Parameters(3).Value = indexbitsstr ' Calling Prepare after having set the Commandtext and parameters. command.Prepare() command.ExecuteNonQuery() Catch ex As SqlCeException Dim m1 = ex.Message Dim m2 = ex.Source Dim m3 = ex.NativeError MsgBox(m1 & m2 & m3, , "Add record to Acessfile") conn.Close() sr.Close() Exit Sub End Try line = sr.ReadLine : line1 = line Loop Until line Is Nothing sr.Close() conn.Close() End Sub Private Function dbtableexist(ByVal dbconnection As SqlCeConnection, ByVal tablename As String) As Boolean Dim cmd As SqlCeCommand, rdr As SqlCeDataReader Dim iname As String, tablename1 As String, i As Integer tablename1 = UCase(tablename) cmd = dbconnection.CreateCommand cmd.CommandType = CommandType.Text cmd.CommandText = "select * from INFORMATION_SCHEMA.INDEXES" Try rdr = cmd.ExecuteReader Catch ex As SqlCeException Dim m1 = ex.Message Dim m2 = ex.Source Dim m3 = ex.NativeError MsgBox(m1 & m2 & m3) Stop End Try Do While rdr.Read iname = rdr("TABLE_NAME") If UCase(iname) = tablename1 Then dbtableexist = True : Exit Function Loop dbtableexist = False End Function
View Replies !
SQL Server Mobile 2005 - Licensing
Hi, Could someone pl explain how is SQL Server mobile 2005 licensed. Do we need to buy license for each device ? or CAL? In my app, I need a database which is accessed by .net compact framework app. synchronization is also done by our own app, no direct communication from sql server mobile to sql server db. we have a server side .net app which talks to the sql server and a windows mobile app which talks to the sql mobile db, these two .net apps talk to each other like: sql server mobile db <--->.net compact framework app <--->.net desktop app <-->sql server 2005 Needless to say, there would be multiple devices having the above setup. However only one desktop side app and database. In this scenario, how would licensing be calculated? regards, D2
View Replies !
MSDE && SQL Server 2005 Mobile Server Tools Problem
After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error. "You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components" Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??
View Replies !
Sql Server 2005 Mobile/RDA Connection Problem
I have a working Pocket PC 2003 app that uses RDA to exchange data with SQL Server 2000. I'm attempting to port it to a Windows CE 5.0 device. (I'll be porting to Mobile 5 in the near future, but the gadget I have at the moment is CE). I installed SQL Server 2005 Mobile Edition on the computer running IIS according to package directions, and used the wizard to set up a virtual directory with sscesa30.dll. The directory I was previously using with sscesa20.dll is still there, and still works. I set up the virtual directory to use basic authentication without SSL. (I know that's not advisable). I have confirmed that I can reach the URL using the username and password I supplied to the wizard. When I try to pull data I get the following: ------------------- SQL CE Exception Error Code: 80004005 Message : An error has occurred on the computer running IIS. Try restarting the IIS server. Minor Err.: 28022 Source : Microsoft SQL Server 2005 Mobile Edition I have tried restarting IIS without effect. Any clues?
View Replies !
Merge Replication Between SQL Server 2005 And SQL Mobile
Hi, I'm currently investigating the feasibility of having SQL Mobile on a number of devices running Windows CE. These devices will have to synchronize with the server (either using merge replication or RDA) over GPRS. The problem I have is that some of these devices will never be online. Is there are a way of synching these offline devices? The model I had in mind was using a USB key (or some other storage device) to download the latest updates from an online device and transferring this data to the offline device, and vice versa e.g. from offline to online and then merging. Is this feasible? Thanks Csharper
View Replies !
VS 2005 With SQL Server CE 2.0 For Windows Mobile 5 Devices ?
I Have a smart device application developed in VS 2003 (VB.Net) and Sql server ce 2.0. Now I have upgraded the application to VS 2005 (VB.Net). My question is, Can the Application developed in VS 2005 can communicate with Sql server ce 2.0 and Sql server 2000 sp4 or Do I need to change the Sql server ce 2.0 to sql server 3.0 to work with windows Mobile 5 and Pocket PC 2003 SE devices ?
View Replies !
Windows Mobile 5 Connecting To SQL Server 2005
Can't get winmobile 5 to connect to my sql server 2005 (using vs2005). Here's the connect string: "Data Source=tcp:XXXXXXdefault,1433;Database=YYYYYY;" _ & "Integrated Security=SSPI;" This very same string, and variations of it, work in a vs2005 winforms app, but not a windows mobile 5. I'm (obviously) using system.data.sqlclient. MS documentation says it's supported on both platforms with no syntax changes. Any suggestions?
View Replies !
|
TRACKER
