Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Calling SQL Server With A BlackBerry Phone Expand / Collapse
Author
Message
Posted Tuesday, February 8, 2011 10:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 5, 2014 4:04 PM
Points: 52, Visits: 266
Comments posted to this topic are about the item Calling SQL Server With A BlackBerry Phone

R Glen Cooper
Post #1060834
Posted Wednesday, February 9, 2011 12:02 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
Something innovative and out of the box thinking, appreciated.

Satnam
Post #1060853
Posted Wednesday, February 9, 2011 2:42 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:00 AM
Points: 76, Visits: 354
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]
Post #1060930
Posted Wednesday, February 9, 2011 4:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, December 14, 2014 8:33 AM
Points: 24, Visits: 564
Great Article, I never imagined this kind of use for SQL Server...
Post #1060993
Posted Wednesday, February 9, 2011 6:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 15, 2011 7:17 AM
Points: 2, Visits: 33
Great article,

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

Thanks,
Dejan
Post #1061056
Posted Wednesday, February 9, 2011 6:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 1:02 PM
Points: 1,414, Visits: 4,545
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

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #1061057
Posted Wednesday, February 9, 2011 8:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 5, 2014 4:04 PM
Points: 52, Visits: 266
Good idea - thanks for that.



R Glen Cooper
Post #1061169
Posted Wednesday, February 9, 2011 8:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 10:42 AM
Points: 103, Visits: 811
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
Post #1061179
Posted Wednesday, February 9, 2011 8:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:00 AM
Points: 76, Visits: 354
@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]
Post #1061218
Posted Wednesday, February 9, 2011 8:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 5, 2014 4:04 PM
Points: 52, Visits: 266
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
Post #1061226
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse