I am modifying the aplication to visual.net from visual studio 2005 but I have problems ( in this moment i working in my pc , with sql 2000 personal ,windows xp , sql mobile and pc pocket emulator for window ce 5.0)
I don't know but i can't make the Pull in the server.
1) the http://localhost/driver2005/sqlcesa30.dll?diag is correct
2) I don't have the windows firewall
3)the anonimous user have all the permition in the virtual directory..
I'm facing a problem when sychronization data between pocket PC and database server.It shows error "A request to send data to the computer running IIS has failed".How can I fix? I'm using Pocket PC 2003 emulator. I can access replication internet url by pocket IE. I also open port for HTTP and HTTPS both.
I am running a .Net application (VB.Net, .Net Framework 2.0) on a Windows CE 5.0 handheld device. I am relatively having good success with SQL CE replication, however sometimes (2 users out of 30 every 2 weeks), are freezing up in the application.
Here is what CE SQl software versions I installed: sqlce30.dev.ENU.wce5.armv4i.CAB sqlce30.repl.wce5.armv4i.CAB sqlce30.wce5.armv4i.CAB
I have a trace log in my application, and here is what pops up before the hang (warm rebooting the handheld works)
NativeError: 28037 SQL Msg: A request to send data to the computer running IIS has failed. For more information, see HRESULT.
NativeError: 28600 SQL Msg: The database is currently synchronizing with the server.
I am using a Thread to syncronize (microsofts built in class), as you can see I am well aware of 28600, it just means some other thread is already syncing, so I can wait until next time to syncronize. However, my users apps are freezing just after both error codes occur. Anything in the code below causing issues??? (maybe _repl.Dispose() is freezing up my handheld, because its freezing after this line of code (see below code):
"MTM.SPUD.Utilities.Utilities.Log("[DEBUGQLThread#" + threadId + "]: End of Thread Life.")"
Public Sub AsyncSyncronize(ByRef PendingData As Boolean, ByVal Publication As String, ByVal Subscription As String, ByRef LastSyncDateTime As DateTime) Dim _repl As New SqlCeReplication() Try ... savedAsyncResult = _repl.BeginSynchronize(objDelegate1, objDelegate2, objDelegate3, objDelegate4, _repl) Catch ex As Exception Finally End Try
End Sub
Public Sub OnSynchronizeComplete(ByVal asyncResult As IAsyncResult) Dim _repl As SqlCeReplication = Nothing Dim threadId As String = "" Try _repl = DirectCast(asyncResult.AsyncState, SqlCeReplication) threadId = _repl.InternetPassword _repl.EndSynchronize(asyncResult) dataIsPending = False
dataIsPending = True If exce.NativeError.ToString = "28600" Then MTM.SPUD.Utilities.Utilities.Log("[WARNINGQLThread#" + threadId + "]: Will try again next time") Return End If
Catch ex As Exception Return 'MTM.SPUD.Utilities.Utilities.Log("App Exception: " + ex.Message) 'Throw New Exception("EndSynchronize Failed: " + ex.Message)
Finally MTM.SPUD.Utilities.Utilities.Log("[DEBUGQLThread#" + threadId + "]: End of Thread Life.") If _repl IsNot Nothing Then _repl.Dispose() _repl = Nothing End If End Try End Sub
i have restored site using stsadm, site get successfully restored. all user of the site able to access the site but the unable to access from same machine on which it is restored. i got the error The file exists. (Exception from HRESULT: 0x80070050)
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.
From a couple of days I have a strange and annoying problem on my development machine. Every time that I try to use the Import/Export wizard in the Management Studio I receive the error HResult E_Fail error refererencig to the dtsruntimewrap.
If I try to open a SSIS package and to check the setup of the connection I receive instead a message stating Could Not Edit OleDB Connection, error E_FAIL(0x80004005). (System.Data)
I receive error 25123 on my PPC (audiovox 6600) in a reproducable way (usually) with .net 2.0 application that is using SQL CE that I wrote:
Open the application Connect to the database Close the applicaton Re-Open the application Connect to the database <-- Error occurs
I will also receive the error if my application isn't the first application launched (or very close to the first to launch).
I don't believe it's a memory issue as according to the memory manager I have plenty of memory:
At boot up only start screen items loaded: 18.46 Used 49.89 Free Launch Resco File Explorer to click EXE: 19.18 Used 49.18 Free Launch my application (no DB connection): 23.64 Used 44.71 Free Connect to the DB and do select count(*) from a table with 0 rows: 26.27 Used 42.08 Free Close the application (this.Close() on the form: 19.38 Used 48.97 Free Relaunch App and connect to DB receive error: around 38 Used around 30 free
I was unable to reproduce the issue right now while typing this message, the last sets of numbers are from memory, and include other applications that are currently running.
The only way I have to get SQL CE to load again is to soft reset the PPC. If the application is able to connect to SQL CE at least once it is fine up till I close it and re-open the application. So it either connects and runs great, or it can't connect at all.
Any help in resolving this issue would be greatly appreciated. Wayne
I guys, I have this store procedure which does a bulk insert to a session table from a XML file. This store procedure used to work fine until couple of month ago and now all of the sudden it stopped working. Whenever this procedure is executed I get following error:
Msg 6511, Level 16, State 82, Procedure up_XNetSessionBulkInsert, Line 42 Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x8007000e. You may fix the problem and try again later. I also tested same procedure on the development sql server and it works fine. the settings on the production and development are same. I was wondering if any of you have a solution for it. Here is the procedure which causes error. dbo.up_SessionBulkInsert '<sessions><s id="6" val="45465465" len="9" /></sessions>'
ALTER PROCEDURE [dbo].[up_SessionBulkInsert] ( @sessionXml text ) AS SET NOCOUNT ON declare @handle int exec sp_xml_preparedocument @handle output, @sessionXml INSERT INTO SessionTb ( sessionID ,session ,length ) SELECT sessionID ,dbo.udf_DecodeBase64StringToBinary(session) as RawBytes -- Base64-decode to byte[] before we insert. ,length FROM OpenXml(@handle, '/sessions/s', 1) WITH ( sessionID varchar(88) '@id' ,session varchar(max) '@val' -- This value should be a base64-encoded string ,length int '@len' ) select @@rowcount exec sp_xml_removedocument @handle SET NOCOUNT OFF
What is the cause of this failure to install (Microsoft SQL Server 2005 9.00.3042.00 fetched from http://download.microsoft.com/download/1/5/8/15840bb5-30d9-4ba2-b6bd-32424d22f0f9/SQLEXPR_ADV.EXE) :
Code Snippet Machine : DX5150 Product : SQL Server Management Studio Express Error : An error occurred during the installation of assembly 'msddsp,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="8.0.0.0",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. -------------------------------------------------------------------------------- Machine : DX5150 Product : Microsoft SQL Server Management Studio Express Product Version : 9.00.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_DX5150_SSMSEE_1.log Last Action : InstallFinalize Error String : An error occurred during the installation of assembly 'msddsp,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="8.0.0.0",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. assembly interface: IAssemblyCacheItem, function: Commit, component: {FB603825-921B-4781-9FF3-1B1800281E29} Error Number : 1935
hi, I'm working on "MERGE REPLICATION"...i followed the procedure same as the book "SQL SERVER CE DATABASE DEVELOPMENT WITH the .NET COMPACT FRAMEWORK"Author Rob Tiffany, ch9,10
i got one error msg that..."a request to send data to the computer funning IIS failed,for more information seeHRESULT " ..When my program hits rep.Syncronize()...
i m getting the following error while exporting an excel file in SSIS
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
I get following error trying to use SQLCMD OR OSQL
Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I searched this forum for answers and I found one solution where it was said that Remote connections for TCP and Named Pipes needs to be enabled. I have them enabled, but I still get this error. I had working SQL server before, but I had to uninstall it. Now after installing ti again I started to get this error.
Anything else besides disabled remote connections cause this problem? I'm trying a local connection. I heard elsewhere that this could be firewall related, but shouldn't it use local connection always when I try to connect it with sqlcmd and no other parameters given?
Where can i get the full error when viewing the report in visual studio...
"An unexpected error has occurred (Exception from HRESULT: 0x800300FD (STG_E_UNKNOWN))
This seems strange.. I am using a cube.. and the second I drag certain field to the grid in the query designer it crashes. When I take that field out its fine.. in my report I have NOTHING. just an empty report with a dataset.
I have ran into the same problem ... Importing from Access into SQL 2005 using SSIS and get the error:
[Connection manager "SourceConnectionOLEDB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
I work with February CTP of SqlServer 2008. I have an Assembly with several UDTs inside. Version of assembly is 1.0.* I use CREATE ASSEMBLY statement to register this assembly, and it runs without any errors. Then I rebuild CLR solution without doing any changes in source code. In that case the only difference between new and old assemblies is version (difference in fourth part of version). Then I try to update assembly in SqlServer. I use ALTER ASSEMBLY <name> FROM <path> WITH PERMISSION_SET = UNSAFE, UNCHECKED DATA statement for this. Statement runs with error: Msg 6509An error occurred while gathering metadata from assembly €˜<Assembly name>€™ with HRESULT 0x1. I found the list of condition for ALTER ASSEMBLY in MSDN: ALTER ASSEMBLY statement cannot be used to change the following: · The signatures of CLR functions, aggregate functions, stored procedures, and triggers in an instance of SQL Server that reference the assembly. ALTER ASSEMBLY fails when SQL Server cannot rebind .NET Framework database objects in SQL Server with the new version of the assembly. · The signatures of methods in the assembly that are called from other assemblies. · The list of assemblies that depend on the assembly, as referenced in the DependentList property of the assembly. · The indexability of a method, unless there are no indexes or persisted computed columns depending on that method, either directly or indirectly. · The FillRow method name attribute for CLR table-valued functions. · The Accumulate and Terminate method signature for user-defined aggregates. · System assemblies. · Assembly ownership. Use ALTER AUTHORIZATION (Transact-SQL) instead. Additionally, for assemblies that implement user-defined types, ALTER ASSEMBLY can be used for making only the following changes: · Modifying public methods of the user-defined type class, as long as signatures or attributes are not changed. · Adding new public methods. · Modifying private methods in any way.
But I haven€™t done any changes in source code, so new version of assembly satisfies all this conditions. What could be the reason for such behavior? P.S. I€™ve got the same error, if I add or change any method in assembly before rebuilding.
I was trying to run my application that has to Synchronize data between sql mobile and sql 2005. In the emulator all is fine and executes without any error.But when I deploy the application in real device it throws an exception:"Authentication failed in server running IIS". The device is WM5.0
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.
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 ?
Just released small piece of software with SQL Compact Edition, version 3, dll files distributed with the application.
Now feedback from 2 people suffering an error message as follows: SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU.
Both using XP under Admin accounts.
My own testing did throw up this error prior to release, but only when I tried to run the program as a Limited User. I was unable to find out why. Running the program under an Administrator account never produced this error message.
The test-bed was a fresh install of XP, SP 2, running within VMware. An Administrator account was set up. No development software was installed, nor anything to do with SQL. I tried to make it a clean environment to be used by a non-technical user.
I've been trying to convert an application to use the CF 2.0, and of course to SQL Server Mobile. There have been some kinks along the road, but I've worked all of them out except an error on replication. When I call the SqlCeReplication's Synchronize() method, the connection goes fine, it works for about 20-30 seconds, and then comes up with the following error:
Error code: 0x80004005 Message: The data types cannot be converted implicitly. [ Source data type = nvarchar,Destination data type = image ] Native error: 25932 Source: Microsoft SQL Server 2005 Mobile Edition Error Param: nvarchar Error Param: image
I've tried upgrading from SQL Server 2000 to 2005 to see if that helped, but got the same result. I even tried running this from a fresh install of SQL Server 2005, hoping that'd integrate better with SQL Server Mobile, but that didn't help either.
I found a knowledge base article about error code 0x80004005: http://support.microsoft.com/kb/912428 However, none of my tables are even remotely close to having 127 columns, so that can't be it.
I do have an image data type column in one of my tables, but why is a column being converted from nvarchar to image? Both SQL Server 2005 and SQL Server Mobile support the image data type, so I don't understand how that could be causing a problem in the first case.
Any ideas? I've run out of things to try and would appreciate any feedback.
I'm going to try and explain this the best I can. I am trying to pull tables from SQL Server 2000 to my Handheld Device (Dell Axim). I've installed the RDA to my web server which is running IIS 6. The RDA is installed correctly cause when I go to http://is-sql-s2/rda/sqlcesa30.dll, I get "SQL Server Mobile Server Agent 3.0." I've installed SQL Server Mobile to my handheld and setup the application but when I try to pull the tables I get an error unable to download tables.
I've gone in to check the RDA Diagnostic informaton and noticed that there is an error. Can seem to find any information about the error. Can someone help me out. THANKS!
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?
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
I have been trying to place a binary byte array into the sql server mobile 2005 database and continually get an error "The Identifier cannot be an empty string." when attempting to save this sql to the database:
the byte array ChangeStamp is a timestamp datatype in the Sql Server Database and is pulled into a custom business object as the .net datatype Byte()
in the debugger, the byte array looks like it should as a timestamp comprised of 8 bytes with the values: 0,0,0,0,0,0,63,181 . but when i attempt to execute the sql statement, i get the sqlceexception "The Identifier cannot be an empty string." if i change the byte to a string and save it as an nvarchar, the value is preserved and i can then pass it back to compare it to the timestamp when synching up to the Sql Server Database later, but i would prefer to maintain the type as a binary datatype, and avoid the string conversion...
When i am creating the sqlstring (which i then run using a sqlcommand/nonquery) i add the binary data to the sqlstring by referencing the .tostring character ... do you think this may be what is causing the error, and if so, is the only way to insert binary data to a sql ce db by using sqlcecommand parameters?
i have found no information to assist with this error, any ideas are much appreciated
Hi, in my app I connect to and read from a Sql Mobile database numerous times. Eventually and inconsistently my app will no longer be able to access the database and a SqlCeException is returned with native error 25123. This error translates to: "A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name = sqlceqp30.dll ]". I've seen similar (and unsolved) problems involving RDA/replication, but I am not using any of that in my program. It simply connects to database, queries and retrieves data, then closes the connection. I am properly disposing of all SqlCE objects.
I'm not sure what the error really means. Once the program gets this error it is never able to access the database again until the program is restarted. I am still able to connect to that database from the Query Analyizer even after the program gets the error and hasnt been restarted (meaning if the program tried again after the QA's success it will still have same error).
Common suggestions for the similar RDA error are to put the initializion at the beggining of the program. In my case the database connection will succeed several times before the error occurs.
anyone have similar issue where you are not using replication but get error 25123?
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.
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.
I have an SDF using SQLCE 2.0. When I run the app on a Pocket PC device running Windows Mobile 5.0 I get 0x80004005 and 0x80040e21 errors. The same app executes fine on PPC 2003.
The app is written in VC++ using and uses the SQLCE OLEDB Provider to access the SDF. It is complied with eVC 4.0
Please provide some help regarding the "Interface Defining Error: IID_IDBDataSourceAdmin" error while trying to create a SDF database using Query Analyzer on a Windows CE 5.0 mobile device (Symbol MC3000).
Error: 0x80004005 E_FAIL Native Error: 28558 Description: SQL Mobile encountered problems when creating database [,,,,]
PS. Basically I have developed a mobile application that programmatically creates the database, the code worked on a similar device (Win CE 50), trying to run the application on a new device resulted in database creation errors. I tried creating a test database manually .. and this is what I got.
Browsing MSDN or searching on the Forum did not help.
The development environment & the SQL Box are two different boxes.
I am trying to create a simple application where I want to synchronize data between Pocket PC application's ( Emulator) local database(SQL Mobile) to SQL 2005 Database. I have tried the steps outlined in the following link
Once I have completed all the steps as per the steps in the above link, I have copied the .sdf file to an another machine where I have the development environment. I have created a device application in VS 2005 and created a datasource poiting to the file (.sdf) copied locally.
Then I have added the following code string filename = @"e:VelsunMobileTest.sdf";
if (VelsunMobileTestDataSetUtil.DesignerUtil.IsRunTime()) { // TODO: Delete this line of code to remove the default AutoFill for 'velsunMobileTestDataSet.Customers'. this.customersTableAdapter.Fill(this.velsunMobileTestDataSet.Customers); }
}
private void DeleteDB() { if (System.IO.File.Exists(filename)) { System.IO.File.Delete(filename); } }
private void Sync() { SqlCeReplication repl = new SqlCeReplication();
