Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Calling SQL Server With A BlackBerry Phone


Calling SQL Server With A BlackBerry Phone

Author
Message
Glen Cooper
Glen Cooper
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 287
Hi grovelli,

You need to download the enhanced package from my site:

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

which includes the revised article containing the explanation, better IP address handling, and an XML configuration file which self-explains how it can be used to avoid displaying parameters in the browser.

R Glen Cooper
grovelli-262555
grovelli-262555
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 872
Thanks Glen, I've downloaded and extracted all the files in your Images.zip, what's the name of the file holding the revised article containing the explanation?
It's just a little vbscript on the desktop web server making connections to SQL Servers and issuing SQL queries on those servers.

What's a desktop web server?
Glen Cooper
Glen Cooper
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 287
Hi grovelli,

After you unzip Images.zip you need to unzip one of its components ImagesPackage.zip. This will yield the source code (the explanation is in the XML file).

By desktop web server, I mean IIS that comes with XP Professional (the Home version doesn't offer it).

R Glen Cooper
spikenology-616218
spikenology-616218
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 28
Glen, good article. I have things set, I believe - and and getting a response from my iis - but it is also showing an error occurred...but not much details on what that might be. Below is the page readout -

Any thoughts would be appreciated -

Images

Host SQL Server spikenology
Host SQL Login spike
Host SQL Password ****
Host Database ImageHost
Client SQL Server spikenology
Client SQL Login spike
Client SQL Password ****
Client Database ImagesClient


Host SQL Server is currently specified as:

Host SQL Server = spikenology
Host Login = spike
Host Password = spike2
Host Database = ImagesHost

Client SQL Server is currently specified as (required for downloading to client):

Client SQL Server = spikenology
Client Login = spike
Client Password = spike2
Client Database = ImagesClient

An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error.
Glen Cooper
Glen Cooper
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 287
Ok you have helplevel = 2 so parameters are displayed showing both databases are connected.

I assume you are using the package on my web site.

Can you view an image?

You could put a line in imagedownload.asp, if you are downlading, to display the openset query (disable the actual call) and then use query analyzer to run it manually.

R Glen Cooper
borge
borge
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 149
Hi Alen Tiplitsky, who wrote:
"...it's a lot easier done with iphones and android phones. and without the need to keep your home computer on 24/7"

Can you elaborate with an example; or give a link to more information?

Thanks!
aiseblair
aiseblair
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 85
I was trying to implement this but got an error on the images.asp screen

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'ImagesHost'.
Glen Cooper
Glen Cooper
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 287
I assume you can open any htm file on your desktop Web directory from your phone, eg.

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

where nnn.nnn.nnn.nnn is your server's external IP address.

Your router must redirect port 1433 to the host machine, and your firewall must not prevent that (you might turn it off temporarily).

Also, check that you can run any asp file on your server from your phone.

If not, try running the app directly on your server using its own internal IP address.

I don't know how you called the images.asp page, but increasing the help level to 2 or 3 might help diagnose the problem:

http://nnn.nnn.nnn.nnn/images/images.asp?helplevel=2

You might try adding a response.write(driverHost) statement on the program's driverHost variable to see what it looks like (while disabling the actual connection: connectionHost.Open driverHost).

That variable is set as:

driverHost = "DRIVER={SQL Server};SERVER=" & hostServer & ";UID=" & hostLogin & ";PWD=" & hostPassword & ";DATABASE=" & hostDatabase

The other place where connectivity might be an issue is where you can get the opening page, but you can't retrieve a file that's listed (which resides in the SQL database). For simply viewing a file, go to the image.asp file (not images.asp) and put in the same sort of diagnostics.

These are the places where things generally fail, and it usually has something to do with simply connecting to the server (the app itself is fairly trivial).

Basically, if you can connect to your SQL Server from your phone's Web browser using direct calls that by-pass the app, the app should work OK.

R Glen Cooper
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search