Calling SQL Server With A BlackBerry Phone

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by R Glen Cooper » Calling SQL Server With A BlackBerry Phone

28 posts, Page 1 of 3

1 2 3 »»»

Calling SQL Server With A BlackBerry Phone

Rate Topic

Display Mode

Topic Options

Author

Message

Glen Cooper

Posted Tuesday, February 08, 2011 10:56 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:20 AM
Points: 47, Visits: 221

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

R Glen Cooper
glencooper.tel

Post #1060834

Satnam Singh

Posted Wednesday, February 09, 2011 12:02 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 3:42 AM
Points: 291, Visits: 1,064

Something innovative and out of the box thinking, appreciated.

Satnam

Post #1060853

James A Skipwith

Posted Wednesday, February 09, 2011 2:42 AM

Valued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 8:20 AM
Points: 59, Visits: 276

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

jr81

Posted Wednesday, February 09, 2011 4:45 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 2:55 PM
Points: 24, Visits: 507

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

Post #1060993

cecedeki

Posted Wednesday, February 09, 2011 6:23 AM

Forum 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

alen teplitsky

Posted Wednesday, February 09, 2011 6:24 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:15 PM
Points: 1,409, Visits: 4,509

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

Glen Cooper

Posted Wednesday, February 09, 2011 8:05 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:20 AM
Points: 47, Visits: 221

Good idea - thanks for that.

R Glen Cooper
glencooper.tel

Post #1061169

grovelli-262555

Posted Wednesday, February 09, 2011 8:10 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 1:22 PM
Points: 81, Visits: 680

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

James A Skipwith

Posted Wednesday, February 09, 2011 8:40 AM

Valued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 8:20 AM
Points: 59, Visits: 276

@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

Glen Cooper

Posted Wednesday, February 09, 2011 8:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:20 AM
Points: 47, Visits: 221

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
glencooper.tel

Post #1061226

« Prev Topic | Next Topic »

28 posts, Page 1 of 3

1 2 3 »»»

Permissions