BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-29-2005, 10:10 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8300
Carrier: EntelPCS
Posts: 41
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Connecting to SQL Server

Please Login to Remove!

Hi,
Before we go out and buy 20 BBs (7230), I nned to be sure that we can have a custom app that can interact with a SQL 2000 data base. Are there any sample code out there? developer sites?

Thanks.
George.
Offline  
Old 07-29-2005, 10:18 AM   #2 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2005
Model: 7520
Posts: 40
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

If anything, you can always use the BB Browser to read data off the SQL server via an http connection. You can also code an ASP.NET site using the MOBILE INTERNET TOOLKIT to also interact with the data. On both counts you can do the standard issued add, update, delete and etc. functions.
Offline  
Old 07-29-2005, 12:27 PM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2004
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Our application talks to SQL server via ASP. We use different asp pages and pass them parameters in the URL. for example, http://www.blah.com/getRecords.asp?u...&table=myTable

then, inside the .asp page (which is executed on the server side) it would use the username and password provided in the parameters to login to the sql server and get the records from the specific table. just parse the response. we currently use a delimiter for the fields, although i think we're gonna start using the xml parser soon.

hope this helps!
Offline  
Old 07-29-2005, 03:59 PM   #4 (permalink)
BlackBerry Extraordinaire
 
Join Date: Dec 2004
Location: in a house...
Model: lots
Carrier: Rogers
Posts: 1,148
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

AFAIK you should be able to use JDBC. It's going to be a lot of work and your jar file may be bloated, but it should work.

cd.
Offline  
Old 07-30-2005, 08:38 AM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Location: Metro NYC
Posts: 175
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The best approach is to create a J2ME app that runs on the device. This app would store data locally. A server-side process would push data to your device-side app and perform the updates to your SQL database.

A second approach is to create a thin-client app using ASP.NET, JSP, PHP, etc. The downside of this approach is that your users won't have access to their data if they are out of coverage. In addition, many users find the "slowness" or latency of a thin-client app too much.
__________________
-- Aric Rosenbaum
BlackBerry consulting, BlackBerry development
www.arconsultinginc.com
BlackBerry consulting and development (RIM SI Partner)
Offline  
Old 07-30-2005, 05:50 PM   #6 (permalink)
CrackBerry Addict
 
T-Roy's Avatar
 
Join Date: Jan 2005
Model: 8800
Carrier: Darth Vader
Posts: 704
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would think it would be easiest to create an webapp to return the data in XML and have the blackberry read and parse the xml data via http.

Your XML structure could easily be extended for other system that may need or require it in the future.

No?
Offline  
Old 08-02-2005, 10:43 AM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8300
Carrier: EntelPCS
Posts: 41
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

arconsulting,
Did you say you can create an app via .net? Is this a "web site" that runs on the server and is accessed via the BB? or is it a .net app that runs on the BB and access data on the server?

G.
Offline  
Old 08-02-2005, 09:36 PM   #8 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Location: Metro NYC
Posts: 175
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The first. You create a .NET app that runs on the server and is accessed via the BlackBerry browser.

For device-side, you can only use J2ME.
__________________
-- Aric Rosenbaum
BlackBerry consulting, BlackBerry development
www.arconsultinginc.com
BlackBerry consulting and development (RIM SI Partner)
Offline  
Old 08-02-2005, 11:19 PM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2005
Model: 7520
Posts: 40
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by cyberfire
arconsulting,
Did you say you can create an app via .net? Is this a "web site" that runs on the server and is accessed via the BB? or is it a .net app that runs on the BB and access data on the server?

G.
[cough] mobile internet toolkit

cyberfire, that's what the mobile internet toolkit is for.
Offline  
Old 08-03-2005, 06:34 AM   #10 (permalink)
New Member
 
Join Date: Jul 2005
Model: 7100T
Posts: 12
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

create a webservice then use ksoap.
Offline  
Old 08-04-2005, 05:23 AM   #11 (permalink)
Knows Where the Search Button Is
 
Join Date: Jan 2005
Location: MAH
Posts: 38
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BlackBerry DabaseViewer application on Cellica.com

Hi,

You can find the similar application which may meet your requirement on URL:
http://www.cellica.com/bbdbviewer.htm

RimZim.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.