HELP US MICROSOFT: SYNCH BETWEEN SQL EXPRESS AND SQL MOBILE
Mar 28, 2006
Hi Everyone
As most of you do, I am eagerly awaiting the ability to synchronize my sql mobile database on the hand held to a local sql express database on my local machine
I know users in Microsoft have pointed out to us that we are getting things for free.
At the same time, Microsoft is getting our patience for free and at a cost to us developers.
Its nearly April and as one article says Microsoft will release a fix for this inadequacy
Microsoft...we are happy to pay for this. Palm offers it so what is the big deal. Its not the
reinvention of the wheel. We would have liked that instead of the server synchronization
that bypasses the local sql express database
I as many others are happy to pay
Please let us know when you will be addressing this problem.
I would appreciate the feedback and frustration of other developers. Maybe this will show them we are really running out of time with our clients
I have a query that executes just fine except that it won't recognize varchar(255) ( or any other value within the () ) and if I leave it off like this: varchar, then it executes but it leaves that value as 1 and that is just not very useful for my purposes. This also happens with anything else that requires () to add length such as char(), or nvarchar(), etc... Any ideas?
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?
I have uninstalled the SQL Server Express Edition that I have installed from the CDs that were given to me during a Chicago Conference when READY TO LAUNCH Visual Studio 2005, SQL SERVER 2005, and Biz Talk 2005. Then I went to microsoft website: http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx and downloaded and installed the so called Microsoft SQL Server 2005 Express Edition and I got the messages Error that you read below. Then I Uninstalled Microsoft SQL Server 2005 Express Edition and went again to msdn website and downloaded Microsoft SQL Server 2005 Express Edition Advanced Services SP1 and installed it. I got again the same message as below.
MESSAGE:
1. First comes a window with the title: €œsetup.exe €“ Unable to Locate Component€? And it displays a message: This application has failed to start because MSTDCPRX.dll was not found. Re-installing the application may fix this problem. 2. After I click the OK button of this window it comes another window with the title: €œMicrosoft SQL Server 2005 Server Setup€? And it displays a message: Failed to load SqlSpars.dll
Does anybody can tell what is going on with the 3 times I tried to installed different SQL Server 2005 Express Edition and I get the same message?????
Thanks for your help and support when you have time to respond. Sincerely, TonyC
MORE INFORMATION ON THE: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles
1. C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Core.txt Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 87 Aborting queue processing as nested installer has completed Message pump returning: 87
2. C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Core(Local).txt Running: InvokeSqlSetupDllAction at: 2007/1/20 1:22:8 Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Unable to load setup helper module : 87 Message displayed to user Failed to load SqlSpars.dll Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2 Running: UploadDrWatsonLogAction at: 2007/1/20 1:22:17 Message pump returning: 87
I 'm getting this error on expanding the + nodes in SQL Server Management Studio Express Object Explorer:i.e. Database -> System Databases -> Any DB selected and expanding the Tables node When I click on the nodes for Tables for any of my databases, I see it saying expanding..., but then a message box errors pops up. It was working fine until after my lunch hour when I attempted to create some new tables.Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)Additional Information:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)Could not continue scan with NOLOCK due to data movement. (Microsoft SQL Server, Error: 601)
Stephen Hickey writes "We are creating a pocket pc application that utilises data on a SQL Server 2005 express database.
Is it possible to use the rda.Pull() and the rda.SubmitSql() functions when using SQL Server 2005 Express edition.
It appears to us that it will not work because you only get the replication Subsciber agent in this edition and dont get the Replication Publisher and Distributor agents in SQL Server 2005 Express."
Hi all, Thanks in advance, I have to transfer data from sql express 2005 to sql mobile(.sdf).
Actually i have a sql server express 2005 (sqlee) in laptop... and the .sdf (sqlce) handheld device (ppc) that has been connected by activesync.
Can you please make it clear for my following questions? 1. Is it possible to write a query like " insert into ....sdf select from...sqlexp...." between 2 servers...? 2. Is there any copy command like a BULKCOPY .. to insert all records to .sdf (sqlce) from sql server express?
(or) 3. Is it correct to create a smart device application (CF 2.0) to transfer data between sql express and .sdf by using active sync...?
I am now writing application to connect SQL Server Express in Windows Mobile 5.0.
While running the code, I got error "PlatformNotSupportedException". I realized that it is a problem on different locale on the PDA and the SQL Server. So I tried to re-install the SQL Server for another collation, which is Latin1_General_CI_AI. I have also set the collation to Latin1_General_CI_AI at database-level.
Unfortunately, in the Visual Studio Debugger, I found that the error message is
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
I have a user who is trying to load SQL server 2005 Express on a new Acer laptop computer. The computer has the following: Windows Vista Home Premium 32 bits AMD Turion 64 mobile technology CPU 1790 MB of RAM When the user tries to load SQL server 2005 Express it does not load. The user after the load is getting an €œUnhandled exception has occurred in your application€? when he tries to run the application. Does anyone know how to fix this problem?
I would like to request you to kindly point me to a location where I may obtain more ideas/suggetions/details on how synchronization may be performed in a real world scenario ?
MS has been promoting smart clients and offline availability, but I cant seem to find any material that outlines some ideas/techniques/pointers as to how this may be acheived sans SQL Server replication
Essentially, what I'm looking for is someting that would guide a not-so-solid-with-databases person like me through how synchronization (sans sql replication engine) may be implemented - any watchouts etc..
:eek: :eek: :eek: :eek: Msg 156, Level 15, State 1, Line 6 Incorrect syntax near the keyword 'contains'. Msg 102, Level 15, State 1, Line 8 Incorrect syntax near ')'.
i am getting error messages like this. I want to know what this message really mean i.e list of messages corresponding to numbers........
Hi all, here are my goals: Have the same DB on two different stand-alone computers, and keep them up-to-date from each other.
Basically a user would input to a DB for a week. Then every week or two, update the other stand alone DB with the new input. The DB would be exactly the same.
What are my options for this? I'd like it as easy as possible! Are there any software packages that deal with this type of transfer, etc.? Thank you!
I have to schedule the automatic restore the standby database fortesting backups . The database was already in log shipping mode. Up towhat point do I need to restore the database without affecting the logshipping sequence? Can we query the log shipping tables for the lastscn applied and recover up to that point? Any suggestoions are welcome.ThanksTram
All,I have an Access DB. On a nightly basis, I want to look at an OtherDB (not Access, but SQL) and:+ Add any new records from Other.Clients into Access.Clients
Hi,im trying to learn SQL Server Management Expressknow a good place to start?Im trying to upload an sql database from Visual Web DeveloperIve been told that this can be done using SQL Server manegement express...cant see how to import into it yet.... any ideas?
I've downloaded Microsoft SQL Server Express 2005. Now I'm trying to connect to server and I don't know what information to put in for server type, server name of authenication. Please help me with this as soon as possible
we have a merg replication running in three regions UK,USA and AU
my question is in one of our test environment testers managed to get a few tables out of synch while the replication is out.
we have re-established the replication since then and it worked fine untill they try to update records from those out of synch tables. as usual we get conflicts.
we don't really know how many tables are out of synch either. we have about 500 tables.
is there a way to synch tables from with in the merge replication??
I am using Microsoft SQL Server 2005 Express Edition. I have also downloaded the Sql Server Express toolkit from the Microsoft site in order to get access to the server's Reporting Services. The toolkit, according to Microsoft, should have included a cut-down version of the Business Intelligence Development Studio. The problem is that after downloding and installing I cant find Business Intelligence development Studio. The shortcut in the start menu brings me to Visual Studio 2005 and not to Business Intelligence Development Studio. Am I missing something?
I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.
Please Help ME!!!
Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]
Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007 Process ID : 5244 c:84d9dbbedcbb7eee6c8eeabf58setup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2007/3/18 19:28:35 Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35 Loaded DLL:c:84d9dbbedcbb7eee6c8eeabf58xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Wed Jun 14 16:28:04 2006 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50
2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2007/3/18 19:28:35 Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true Running: ValidateMinOSAction at: 2007/3/18 19:28:35 Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true Running: PerformSCCAction at: 2007/3/18 19:28:35 Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true Running: ActivateLoggingAction at: 2007/3/18 19:28:35 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44
Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
Is Microsoft SQL Server Management Studio Express (sql 2005) compatible with Sql Server 2000 databases? I'm using Windows Vista and the sql 2000 Enterprise Manager is not fully compatible with Vista...long not responding messages. Can i use the client version of Slq 2005?
Does Microsoft officially support installing SQL 2005 Express on a server where SQL 2000 Enterprise Edition is already running (a has to keep running).
In case they do, where do i find this official info / note.
Have they released white papers on this matter?
I know it is possible to install the two together and that they can coexist, but I am worried about how the two SQL installations wil behave when being updated with patches, security updates, service packs etc. do you run the possibility of them corrupting each other? Therefor it is vital to know if Microsoft supports the two running on the same system.
Hi, Simple question really - Can I use Crystal Reports v8.5 to attach to databases in SQL Server Express and generate reports? I have done a lot of searches in these forums and using Google and I believe it is possible but if someone could confirm this it would help a lot - I'm in the specification stage of a project and would like to use SQL Sever Express for it.
I have just installed sql server 2005 but, now I have two types of server name: Microsoft SQL Server Developer EditionMicrosoft SQL Server Express Edition Which one should I use? Does it matter??thanks..
Hi ... I am converting SqlServer 2000 databases to SqlServer 2005. It is working great for the most part. The issue I am having is that a user with a schema that owns objects is established in the database and no user is defined in the instance logins. I can see where if I add the instance login then the Principal_id does not match. Cannot drop the user/schema as there are referenced objects.
I got around this in SqlServer 2000 by updating the IDs to match but now they are views and updating is not allowed.
Is there a straightforward way to resynch the database user to a newly created login?
Microsoft SQL Server Management Studio ExpressI have restored the database into it with 100tables and stored procedures.I have also created the new database in it.But,i don't know how to add the existing database in to Visual Studio.Net 2005 .I m using ASP.Net.Where are the database stored ?? I don't want to create the new database,.Can anyone pls tell me ....
Hello, I'm trying to follow a sample from microsoft for Using SQLXML Bulk Load in the .NET Environment In the sample c# console app. it says to select add reference then In the COM tab, select Microsoft SQLXML Bulkload 4.0 Type Library (xblkld4.dll) and click OK. The problem I have is I cannot find the library or the xblkd4.dll file on my pc. Does anyone have any suggestions? Any help would be much appreicated. Thanks Karl
Hi, having a bit of a problem - I'm trying to attach a database in MS SQL Server Management Studio Express. When I try in Windows Authentication I can't see any of my databases when I try to browse, so I had a look around on Google a saw mentioned that I should maybe use SQL Server Authentication. Only I don't know my user name and password, where can I configure this? I remember when I was setting up entering a password, but not a user name. Any ideas? thanksmander
