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 2 of 3

««1 2 3 »»

Calling SQL Server With A BlackBerry Phone

Rate Topic

Display Mode

Topic Options

Author

Message

grovelli-262555

Posted Wednesday, February 09, 2011 9:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:22 PM
Points: 81, Visits: 680

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.

Post #1061248

Glen Cooper

Posted Wednesday, February 09, 2011 9:22 AM

SSC Rookie

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

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

Post #1061276

ronald_yoh

Posted Wednesday, February 09, 2011 3:52 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:01 PM
Points: 3, Visits: 43

I cannot see any code implementation???

Post #1061609

SQLRNNR

Posted Wednesday, February 09, 2011 3:56 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337

Thanks for the insight.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1061610

Glen Cooper

Posted Wednesday, February 09, 2011 3:56 PM

SSC Rookie

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

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

Post #1061611

sqlride

Posted Wednesday, February 09, 2011 10:06 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, October 01, 2012 12:27 PM
Points: 12, Visits: 149

Cool article, but i'd like to know if you use the blackberry toolkit from vb.net and then you use a web service?? or wath did you do?

thanks alot and nice article
Smile

Post #1061691

Glen Cooper

Posted Wednesday, February 09, 2011 10:53 PM

SSC Rookie

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

It's just a little vbscript on the desktop web server making connections to SQL Servers and issuing SQL queries on those servers.

R Glen Cooper
glencooper.tel

Post #1061700

grovelli-262555

Posted Thursday, February 10, 2011 1:20 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:22 PM
Points: 81, Visits: 680

Hi Glen, I've downloaded the files and I'll be looking at them(on and off Smile

) during the weekend.
In a previous reply, you say, "The updated article explains how this enhancement works", where's the updated article?
In your last reply, you say, "desktop web server". What is it?

Post #1061745

ben.parker

Posted Thursday, February 10, 2011 2:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 11, 2011 9:57 AM
Points: 1, Visits: 5

Nice article.

As an FYI. BlackBerries can get to https pages as long as the certificate is from a trusted Certificate Authority such as Verisign.

Regards

Post #1061765

Glen Cooper

Posted Thursday, February 10, 2011 6:02 AM

SSC Rookie

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

Hi Ben,

Thank you for that update on trusted authorities. Also, while we're in error correction mode, third-party PDF readers are only required for reading downloaded files (not sure why BB doesn't give better support for this).

R Glen Cooper
glencooper.tel

Post #1061890

« Prev Topic | Next Topic »

28 posts, Page 2 of 3

««1 2 3 »»

Permissions