Image insertion to ss2005 from Windows Mobile

SQL Server Compact Edition

Index ‹ SQL Server

- Previous
  - 1
    - Help - Can't get Compact Edition to work with CE.NET 4.2 ! Hi Ilya, I'm not sure what you mean by this The OS is CE.NET 4.2 and I've installed the CF 2.0 SP1 and I've tried to install (seperately) SQL Server 2005 Mobile Edition, SQL Server 2005 Compact Edition and the HotFix. What other dependencies are required Tag: Image insertion to ss2005 from Windows Mobile
  - 2
    - What solutions make returning from a disaster easier? I'm trying to figure out what solution (replication, mirroring, clustering) would work best for me. I have been reading many articles in BOL and in this forum. Most talk about getting data TO a backup/standby/subscriber, but I can't find a lot of info regarding getting the data BACK after a disaster is over. We have a main office and a disaster recovery facility. Most of the time there are no data updates at the disaster location. So, I need to get data to the disaster facility via WAN (latency is not a huge issue - end of day syncing is fine) for backup purposes. In the event of a disaster, the main office will be offline and data changes will happen at the disaster site. When the disaster is "over" and we return to the main office, what's the best scheme to reverse the data back to the main office to start business again We are a financial company, and have gigabytes of relatively static data. Most changes are current day. So, to snapshot a 100GB database when I know only a few hundred MB changes a day doesn't seem feasible to me. Most replication scenarios (at least from what I see) can't easily "reverse" the replication after a disaster situation. I'm looking at merge replication on a schedule which seems to look good, but was wondering if anyone else has any ideas or suggestions Tag: Image insertion to ss2005 from Windows Mobile
  - 3
    - Error while importing Text file using Import Export Wizard OK, time for me to eat some crow. Long story short, turns out there was a corruption being introduced in the flat file from a zip extraction library. I was having this problem with multiple files, all of which had been extracted in the same way. The corruption did not exist in another copy of the file that I had, which is why I was so convinced that there was nothing wrong with the file. The copy of the file that was testing with BULK INSERT directly had the same corruption. My apologies to the SQL team at Microsoft for being so convinced there was a bug here. :-) Dan Tag: Image insertion to ss2005 from Windows Mobile
  - 4
    - Read the transaction log (ldf) file. My first post ever :) J-A.G. wrote: I know there exist som applications that can read log files, like Lumigent Log Explorer. But it would be nice with an freeware version TANSTAAFL But in order to learn you can always use something like the undocumented DBCC LOG ( Northwind , - 1 ) Tag: Image insertion to ss2005 from Windows Mobile
  - 5
    - SSIS Connection Manager passwords Already tried that, as well as SQL SP2. No luck. Tag: Image insertion to ss2005 from Windows Mobile
  - 6
    - How to drill down on fields Hi All , I am new to Sql Server and Reporting services .. I was trying to make a drill down report I have created Grooup on detail row and set the Visibility with one of the group rows just above .. But when preview the report I cannot see any data .. How ever If I Delete the Groups I can see the data .. Is there anything that I am missing Please help Tag: Image insertion to ss2005 from Windows Mobile
  - 7
    - System.Data.SqlServerCE.dll reference causes error ... Hello All ... I am attempting to create a program that will run on the PocketPC 2003 environment. I have upgraded Visual Studio to SP1, I have installed SQL Server Compact Edition on my development machine and I have installed SQL Server Compact Edition Tools For Visual Studio on the development machine. I have created a new project Visual Basic - Smart Device - Pocket PC 2003. I have created a form for user input. I build and deploy the form to the Symbol Pocket PC to test - no connection to data and it works. I then add a reference to System.Data.SqlServerCE.dll and rebuild and redeploy the application to the handheld. When I attempt to open the form I receive the following error: psmPocket.exe NotSupportedException System.Drawing.Bitmap at System.Resources.ResourceReader.LoadObjectV2() at System.Resources.ResourceReader.LoadObject() at System.Resources.RuntimeResourceSet.GetObject() at System.Resources.ResourceManager.GetObject() at System.Resources.ResourceManager.GetObject() at pmsPocket.frmSetSOPType.InitializeComponent() at psmPocket.frmSetSOPType..ctor() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.ContrcutorInfo.Invoke() at System.Activator.CreateInstance() at MyForms.Create__Instance__() at MyForms.get_frmSetSOPType() at psmPocket.SetSOPType.Main() Now the confusing part is that I haven't changed any of the forms or the code behind the forms, I have simply added the reference to the project. Any idea why adding the reference to System.Data.SqlServerCE.dll would cause the system to start generating these errors I've checked, the install process has loaded the .NET 2 framework to the handheld. And as indicated at the beginning of this message, the application showed the form prior to my adding the reference. Thoughts Thanks ... Tag: Image insertion to ss2005 from Windows Mobile
  - 8
    - Deploying reports to MOSS 2007 Hello, I wonder if anyone can help me save the few remaining hairs on my head I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any. I have the Reporting Services database set up to use Windows credentials and my Domain adminstrator account so I presume that this is user that I should be providing when prompted when deploying. Can anyone give me any clues Thanks, Michael Tag: Image insertion to ss2005 from Windows Mobile
  - 9
    - How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005 What version of SSIS are you using RTM SP1 SP2 Tag: Image insertion to ss2005 from Windows Mobile
  - 10
    - Help with expression to display a per-week daterange value! Here is the table I’m working with: dbo.Reject Rejections Amount Date 5 12 1/4/07 9 3 1/6/07 1 6 1/23/07 0 0 2/11/07 7 8 2/20/07 Is it possible to write an expression for RS2005 in the details row in a table that will separate and add the rejection and amount field values for each calendar week and lay them out to look like below: Week Rejections Amount 1 14 15 2 0 0 3 0 0 4 1 6 5 0 0 6 0 0 7 0 0 8 7 8 I’m trying to make a report that shows the number of rejections and amounts on a week to week basis. So I need RS2005 to add the rejections and amounts for each week date range and display it line-by-line automatically on a per-week basis. Week 1 is 1/1/07-1/6/07 according to DATEPART(WEEK,Date) and so on… Thanks in advance! Tag: Image insertion to ss2005 from Windows Mobile
  - 11
    - Trigger programming SQL 2005 vs SQL 2000 Sorry, I do not have an explanation about why this change in behavior from 2000 to 2005. I have seem this question several times in the newsgroups and decided to find an approach to make it work. AMB Tag: Image insertion to ss2005 from Windows Mobile
  - 12
    - Problems with Roles and sp_helpRoleMember Sorry...using SQL 2005. Tag: Image insertion to ss2005 from Windows Mobile
  - 13
    - Join Using a substring function That Really helps, Thanks a lot, howevere another small thing, I have my datatypes different on the Dimesion table and the Stage table , its not allowing me to do a lookup, is there any workaround for this also If I end up writing sql queries inside this task then I might be better of using the same SP to load the fact, any suggestions on this from performance perspetive. Appreciate your help. Tag: Image insertion to ss2005 from Windows Mobile
  - 14
    - What's wrong? Ok. I took Anthony advice and did a PRINT. It alwyas comes up as 1. So now I'm confused. I thought it would show how many rows are returned. My reults are returning 7 rows, or when I up the number of months to 67 or something, I get no results. I thought that would return a 0. So how can I set this up so I can send one email when there is a results, and the other when there isn't. Thanks! Rudy Tag: Image insertion to ss2005 from Windows Mobile
  - 15
    - error 1155 message Can anyone help please, I'm trying to install post smile. www postsmile.com. I keep getting the error setup message. Unable to execute file code 1155 Shellexecute Ex failed. I haven't a clue what this means except it won't connect me to the site and I have paid for this and entered the code. I've altered my firewall to accept it in case it was this but still no luck.Is it a fault with the company or my computer Many thanks in advance. Tag: Image insertion to ss2005 from Windows Mobile
  - 16
    - Running job error in schedule Dear Satya SKJ, Thanks for response. Actually the job run 20% successfully. We run the calculate and update the tables and only 20% of the table is properly updated after that it fails. But if we use the same script to run on the query analyser it works just fine. We assign the job to SA. This means that there must be something wrong with the job. It used to work okay before but just these few days. Please advise. Regards, LG Tag: Image insertion to ss2005 from Windows Mobile
- Next
  - 1
    - error hi i tried this SET DATEFORMAT dmy select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr,Case when IsDate(AdditionalField5)=1 Then Convert(datetime, AdditionalField5,103) Else NULL END as 'ValDate',AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalField21 'Drawer Name' from Tbl_CMS_UploadDetails with(nolock) where Compare_Status='Pending' and ltrim(rtrim(CMS_Upload_Details_ID)) not in (select top 0 ltrim(rtrim(CMS_Upload_Details_ID)) from Tbl_CMS_UploadDetails with(nolock) where Compare_Status = 'Pending ' and Format_ID =83)and Compare_Status='Pending' and Format_ID =83 now getting error Server: Msg 241, Level 16, State 1, Line 2 Syntax error converting datetime from character string. Tag: Image insertion to ss2005 from Windows Mobile
  - 2
    - Second opinion on how to build this cube i Matt: Sorry it is my mistake that I did not clearly explained in the post. The two tables are not directly related and there is NO PK to FK relationship. The lookup table is just the summary of the population for all the cities with the year and 10 years age grouping breakdown and this data is static until next time I update it from other source. I tried to use the population information with the year, city and age grouping, mapped to the production olap cube to calculate the percentage, "customer distinct count/population" for the same age grouping, year and city. Thanks. Tag: Image insertion to ss2005 from Windows Mobile
  - 3
    - Named Pipes Provider, error: 40 - Could not open a connection to SQL Server Nan, I'm probably going to thank you for your help every time I post - so again, thanks for your help. I've tried the basic connectivity tests (below is the command line output) and they were successful. I have had no connectivity issues using SQL Studio or otherwise, unless it involves using the 'Copy Database' task and SQL Server Agent. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Steve>sqlcmd -S 401Server -i C:\TestQuery.sql Changed database context to 'Test'. Location_ID Location_Name ----------- -------------------------------------------------- 0010-10 ADAMSVILLE 0011-10 ALLENTOWN 0011-11 EASTON 0011-12 BETHLEHEM 0011-13 EASTON RENTAL MART (5 rows affected) C:\Documents and Settings\Steve>osql -E Stcp:401Server 1> exit C:\Documents and Settings\Steve> Has anyone been able to successfully execute a 'Copy Database' from one SQL Server 2005 to another Steve Tag: Image insertion to ss2005 from Windows Mobile
  - 4
    - SQL databases and SBS 2003 I have run into this issue repeatedly when installing applications on SBS 2003. The application needs a database and looks for one when installing. It sees the SQL 2000 databases pre-installed on SBS 2003 for monitoring and reporting and assumes it can use them. Ultimately the program grinds to a halt because these instances cannot be used for the application (I'm assuming). The program should install it's own instance of SQL . I end up spending quite a bit of time mending the installation by manually installing some "lite" version of SQL and piecing it to the application. Is there anyway to use the existing SBS 2003 SQL databases for a new app, like a backup program There is no SQL management software on SBS 2003, so how is that done Should I always install a new instance of SQL server for a new application I would love to see some official documentation on how to do this. Thanks! Tag: Image insertion to ss2005 from Windows Mobile
  - 5
    - MDX calculated measure Thanks Bryan, I’m new to MDX so I didnt knew there was a CurrentMember.Parent command. I guess that is what I’ve been looking for Your code sample helped me alot. Thanks again! Tag: Image insertion to ss2005 from Windows Mobile
  - 6
    - SQL 2005 Pull Subscriber stuck "Uploading data changes to publisher" It sounds like you need to update statistics on the tables involved in the query. Tag: Image insertion to ss2005 from Windows Mobile
  - 7
    - How to export to a fixed width flat text file with row delimiters? Sorry, didn't realize you were trying to do this through the wizard. You do need to use ragged right. I'm not sure if this will work (I don't spend much time in the wizard), but select Ragged Right as the format, and include your empty string in the select and see if that works. If it does not, you can do what I suggested above (which I am positive does work), by saving the package from the wizard, and then editing it in the Business Intelligence Design Studio (BIDS), which gives you a lot more options on what you can configure within the package. When you open the package in BIDS, the connection managers will appear in the lower portion of the window. Tag: Image insertion to ss2005 from Windows Mobile
  - 8
    - Management Studio - Script Date Comments Hello, This may sound like a stupid question, but I have looked a number of times where the options are for the comments that are added to a SQL Script that is updated or newly created. Ex this is the line that is added: /****** Object: StoredProcedure [dbo].[Rpts_SelectDesignLumberInv] Script Date: 08/21/2007 19:42:50 ******/ I would like to be able to add the developer name, date created etc to the default comment that is added by the designer.. So more or less I would like to be able to define what is commented. Does anyone know how to do this Thanks, Leo Tag: Image insertion to ss2005 from Windows Mobile
  - 9
    - Grouping records Hi, The results are the same as I got Here's some sample data Town TownCode TownName 1 Conteck Area AreaNo AreaName TownCode 1 Area1 1 2 Area2 1 3 Area 3 1 4 Area4 1 5 Area5 1 6 Area6 1 7 Area7 1 Locality LocNo AreaNo 1 1 2 1 3 1 1 2 2 2 1 3 2 3 3 3 4 3 1 4 2 4 1 5 2 5 3 5 RequestType reqid reqdtls 1 Addition 2 Removal 3 Relocate WebSummit SummitId RequestorName DateOfRequest reqid AreaNo 1 John 12/6/2007 1 1 2 Jack 13/6/2007 1 1 3 Bill 12/6/2007 2 2 4 Ben 12/6/2007 2 2 5 Dale 14/6/2007 2 3 6 Evjen 15/6/2007 3 1 7 Fuller 16/6/2007 1 4 8 Jimmy 16/6/2007 3 4 9 Kart 16/6/2007 1 5 10 Fuller 16/6/2007 1 5 Regards, Vidya. Tag: Image insertion to ss2005 from Windows Mobile
  - 10
    - rank Ordering Hey guys, this is a repost of an old question, but with a different idea. I have created a rank measure to rank customers in terms of their sales. This has worked. Now, i have a reporting requirment, which says i must show YTD, MTD and Prior YTD figures in the one report, along with the customer rank. I have built the report with my time calculations as columns, and customers as rows. I have put sales amount and customer rank in the data section. Is there a way in the MDX Rank function to say Order it by the YTD Sales Amount value. and not the MTD value. At the moment, i cannot sort on anything. As if i choose YTD, it just sorts the headings and not the data. same if i say Sort the Customer based on the Sales Amount, it just doesnt sort it.. Or, another idea i had, was is there a way i can concatanate the Rank Value and the Customer Name together, so that in the report i could then just sort it on Customer I can provide my current MDX statement if needed. Thanks again guys, Scotty Tag: Image insertion to ss2005 from Windows Mobile
  - 11
    - Special charecters in SQL server All, Is there a comprehensive list of special charecter which would interfere with SQL queries I am writing some code to read excel sheets, I want to pass the list to users so that they do not use those special charecters in column headers. Thx. Tag: Image insertion to ss2005 from Windows Mobile
  - 12
    - Retrieve name of running stored procedure Yes, that's exactly what I need. Many thanks! Tag: Image insertion to ss2005 from Windows Mobile
  - 13
    - How do I do "If statement" in SSIS? Vita wrote: How do I create expresiion Column Name - MonitorType MonitorType "SA" : @MyVariable This shows error. I want to see if the MonitorType field returns "SA" and if yes - use the variable I have. If it returns for example "BA" use another variable. MonitorType == "SA" @[MyVariable] : @[SomeOtherVariable] -Jamie Tag: Image insertion to ss2005 from Windows Mobile
  - 14
    - Cannot Reference Database.Tables Collection By TableName --? I have been using SMO for a while with no issues... But I just installed the AdventureWorks sample (AdventureWorksDBCI), and when I try to reference a table by name I get a null value: Code Snippet db.Tables[7] //this works fine; I can access table props/methods db.Tables["EmployeePayHistory"] //returns a null a null value is returned. (not just tables ,but just about any SMO collection). This same syntax works great with many other databases. This returns true, however: Code Snippet db.Tables[7].Name == "EmployeePayHistory" // returns true So is there some kind of character encoding or something that I need to use when referencing one of these collection items by name Tag: Image insertion to ss2005 from Windows Mobile
  - 15
    - Importing data into SSE hi, that means another "full" version of SQL Server 2005 must be available on your network... just to add additional ways, you can perhaps have a look at 2 free prjs of mine , amScript and amInsert.. amScript is able to generate exaustive and complet DDL code of the original database, where amInsert can produce INSERT INTO scripts to populate the destination database based on the original one.. you can then execute the resulting DDL and DML scripts to recreate a copy of the original database.. regard Tag: Image insertion to ss2005 from Windows Mobile
  - 16
    - JDBC Driver for SQL Server 2005 Can any version of the SQL Server 2000 JDBC driver connect to SQL Server 2005 or do I have to install the new JDBC version 1.1 to connect to my 2005 instance Tag: Image insertion to ss2005 from Windows Mobile

Aneesh Abraham

Hi ,

I am trynig to insert an image from the Windows mobile to the SQL database.

Is it possible to perform this using RDA

After some search in this forum , I got an impression that the only way to do this by storing the image in a local database and then do a merge replication.

I do not want to do the merge replcation just fo rthis reason.

Is it possible in RDA

Debugging shows only some part of the data is getting updated.

While trying to retrieve the image in a webpage error is poping up.

My code is :

string strbytes = (Convert.ToBase64String(bytes)).ToString();

DbObj.GetSubmitSql("Update Odrs set SignedBy ='" + txtSign.Text + "', Signature = Convert(Image,'" + bytes + "') where OrderId=" + orderNo + "");

Please help....

Top

Re: Image insertion to ss2005 from Windows Mobile

Ilya Tumanov

No, that is not possible to do using SqlCeRemoteDataAccess.SubmitSql() which I presume you’re trying to use.

Use SQL Client and use parameters to pass a byte array with image instead.

Top