Calling SQL Server With A BlackBerry Phone

  • Glen Cooper

    SSCommitted

    Points: 1697

    Comments posted to this topic are about the item Calling SQL Server With A BlackBerry Phone

    R Glen Cooper

  • Satnam Singh

    Hall of Fame

    Points: 3542

    Something innovative and out of the box thinking, appreciated.

    Satnam

  • James A Skipwith

    SSCommitted

    Points: 1808

    Glen,

    Nice article for a home solution. In most corporate environments however, xp_cmdshell calls will not be allowed - certainly not in mine! - however you could easily replace the calls to this with a CLR stored procedure which encapsulates the same logic, so it would still be viable.

    An enjoyable read.

    Cheers, James

    James
    MCM [@TheSQLPimp]

  • jr81

    SSC-Addicted

    Points: 448

    Great Article, I never imagined this kind of use for SQL Server...

  • cecedeki

    SSC Rookie

    Points: 42

    Great article,

    New and fun stuff to read, maybe even try and implement too.

    Thanks,

    Dejan

  • alen teplitsky

    SSC-Dedicated

    Points: 30014

    cool, but it's a lot easier done with iphones and android phones. and without the need to keep your home computer on 24/7

  • Glen Cooper

    SSCommitted

    Points: 1697

    Good idea - thanks for that.

    R Glen Cooper

  • grovelli-262555

    SSCrazy

    Points: 2603

    I see James mentioned a CLR stored procedure, what is it?

    I've also tried to follow the instructions in the article to access the C:\BlackBerry folder on my pc so I looked up my pc's IP address by typing "ipconfig" in the DOS command window and then entering

    http://10.10.137.152/blackberry/blackberry.asp?helpLevel=0

    in the blackberry browser but I get HTTP Error 404: Not Found

  • James A Skipwith

    SSCommitted

    Points: 1808

    @grovelli-262555 A CLR Stored Procedure is a Visual Studio.Net assembly that can be included into a SQL Server 2005+ database and its methods used as stored procedures, functions, and triggers. It is in effect a replacement for extended stored procedures, as it allows the database to call external code but in a tightly managed architecture. So if you had the need to do say file access, very complex maths or string manipulation for example, you could write the code in C# or VB.Net and call this as a stored procedure. Obviously you should only use these when they are appropriate but they are very useful in certain situations.

    This is a good starting point if you want to read up on these: http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/

    James

    James
    MCM [@TheSQLPimp]

  • Glen Cooper

    SSCommitted

    Points: 1697

    Hi grovelli-262555,

    Can the blackberry directory on your desktop be reached over the Web?

    I don't know your setup, but your router must re-direct port 1433 to whatever machine is hosting the asp page.

    R Glen Cooper

  • grovelli-262555

    SSCrazy

    Points: 2603

    Thanks Glen, no, the blackberry directory on my desktop can't be reached over the Web. What would I need to do to achieve that? I see you mention an asp page, do I have to create a BlackBerry.asp page which corresponds to my C:\BlackBerry folder?

    All our pc's are in a lan so I guess I don't have a router to redirect port 1433. I have WinXP SP2.

  • Glen Cooper

    SSCommitted

    Points: 1697

    You must be able to see the directory, eg.

    http://nnn.nnn.nnn.nnn/images/imageHelp.htm

    where nnn.nnn.nnn.nnn is your external IP address and /images (or whatever) is your Web directory.

    If you want to use internal IP addresses on your lan, I have an enhancement to do that (it "pulls" images, rather than "push" them):

    http://www.newdalesystems.com/Articles/Article017/images.zip

    You just need to replace the original asp/htm files with the revised ones. Also, this enhancement has a new XML configuration file that will hide the server parameters in the browser by setting a flag on (instructions are in that file). The updated article explains how this enhancement works.

    R Glen Cooper

  • ronald_yoh

    SSC Enthusiast

    Points: 197

    I cannot see any code implementation???

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks for the insight.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Glen Cooper

    SSCommitted

    Points: 1697

    I'm not sure what you're asking, but...

    When you unzip images.zip, you will see another file imagesPackage.zip that you need to unzip.

    R Glen Cooper

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply