Thursday, March 12, 2009

SqlCeCmd command line query tool now available

The beta release of SqlCeCmd is now available at CodePlex. Read more about the features here.

kl.

9 comments:

  1. jamesMarch 19, 2009 at 2:57 PM

    hello

    I saw a post of yours on MSDN forum. You seems to know everything about CE database. So I clicked on the url in your profile and came to this blog.

    I am currently having a problem with using ADODB with a CE database. May I ask you a question regarding to that?

    Thank you

    ReplyDelete
  2. ErikEJMarch 19, 2009 at 3:10 PM

    Thank you for your confidence in me, James. I suggest you post your question in this MSDN Forum: http://social.msdn.microsoft.com/Forums/en-US/windowsmobiledev/threads/

    ReplyDelete
  3. jamesMarch 19, 2009 at 6:22 PM

    I have been searching this since last week. I originally posted in the VB section of msdn forum since I was using VB 2008.

    However, so far on one really answered my question; and the last person referred me to a question which you gave answer to

    here is the url to my thread
    http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/ed623b06-d63c-4260-b998-8c5597556593

    basically it's an error called "Multiple-steps operations generates error" message.

    All my code are in that thread.

    Please have a look if you are free by any chance.

    thank you very much m(__ __)m

    ReplyDelete
  4. ErikEJMarch 19, 2009 at 7:22 PM

    I have posted a reply on your forum thread.

    ReplyDelete
  5. jamesMarch 20, 2009 at 12:59 PM

    Hello Erik,

    Thank you for your reply on msdn forum, and sorry for messaging you again.

    After trying to make a insert statement, there are still some errors.

    I included the part of new code which error occured in the same thread.
    http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/ed623b06-d63c-4260-b998-8c5597556593


    Thank you so much for your help again.

    Good day

    ReplyDelete
  6. jamesMarch 22, 2009 at 1:38 PM

    Hello Erik,

    Thank you very much for your advice. Now I can insert any record into a local data base as I will.


    However, I have one last problem. (sorry for bothering you again). After writing my code if I Debug my code, they updates as normal; but when I click on Build and then Publish and run the new program created. It don't do what they do when I just Debug them.
    As in they update well if I just debug, but if publish, then they won't update.


    I was wondering if you know it.


    Thank you so much for your help

    good day

    ReplyDelete
  7. ErikEJMarch 22, 2009 at 5:22 PM

    Hi James, suggest you psot your question here: http://social.msdn.microsoft.com/forums/en-US/sqlce/threads/ and maybe leave more details about any error messages and other relevant information.

    ReplyDelete
  8. jamesMarch 22, 2009 at 8:12 PM

    Thank you very much for replying. I made a post there with full details of what happened.

    here is the url to it http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/3e07ebfc-1573-41d0-95be-da1eb672133e

    Thank you again

    ReplyDelete
  9. jamesMarch 25, 2009 at 12:39 AM

    Hello Erik,

    I tied to use |DataDirectory| following the example in the other post. It didn't work, I think it was because I didn't know how to set it up correctly.

    I got some examples from google as well as searching for MSDN library. Neither worked.

    I put full details in my last post. http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/3e07ebfc-1573-41d0-95be-da1eb672133e/?ffpr=0


    Could you kindly have a look what is the problem I'm having with it at the moment please.

    Thank you very much, and sorry for messaging you so many times.

    ReplyDelete