[dhanashree.rao]

Hi Friends,

I want to start a blackberry application to fetch the email addresses from BES. On BES there is mapping of PIN to Email. So can we write any method to retrieve email address mapped on BES by sending some PIN or IMEI number as a parameter on my blackberry application? If anyone knows, please help me.


Thanks in advance

[Happe79]

I hope I got your point.

So, you want to get the mail address by sending the PIN of any blackberry?

The only way I know is to check the PIN in the BES database (the "userconfig" in DB "BESmgt").

But maybe there is a better way.

Happe

[dhanashree.rao]

Thanks Happe for ur valuable suggession.
But how can I check in the BES database programatically?

[Happe79]

In this case you have to develop a Client-Server-Application.

Then you send the PIN from the BB to the server and then the server checks the PIN in the databse (of course you need a sql server authentification to the BES Database).

I know it is tricky but I think there is no way to connect directly from the BB to the BES database.

Happe

[dhanashree.rao]

Thanx Happe.
Do you have any idea to access the server side BES database (directly/indirectly) through any api?

Thanks,
Dhanashree

[Happe79]

Depends on the programming language you use for the server ;).


If you use Java then you could use Connection Object.

import java.sql.Connection;
import java.sql.Statement;

Class.forName("com.mssql.jdbc.Driver");
		
String url = "jdbc:mssql://localhost:port/database";
		
Connection con = DriverManager.getConnection( url, username, password);
Statement stmt = con.createStatement();

stmt.execute("SQL Query");
stmt.close();

If you use C# then System.Data.SqlClient.SqlConnection Object is very useful.

SqlConnection conn = new SqlConnection(CONNSTRING);

SqlCommand cmd = new SqlCommand("SQL Query", conn);
SqlDataReader rdr = cmd.ExecuteReader();

while (rdr.Read())
 {
         String  exchange_server = rdr[0].ToString();
         .
         .
         .
 }
 rdr.Close();

Hope this helps.


Happe

[dhanashree.rao]

For a normal database connectivity, we use the above programming technique. Pleses let me know is there any different technique to connect to the BES database. and if the same logic we have to use then what will be the connection string to connect to the BES database?

[Happe79]

You mean, you use the java technique?

There shouldn't be a difference. It is a usual MS SQl connection.

The connection string is e.g. "jdbc:mssql://[BESServer]:[BESPort]/BESMgmt"

and the query could be "SELECT MailBoxSMTPAddr FROM UserConfig WHERE PIN LIKE 2100000a"


Maybe take a look in the table UserConfig of BES database before!

Happe

[dhanashree.rao]

Thanks Happe,
i will definatly try it.

[qc_metal]

Originally Posted by dhanashree.rao

Hi Friends,

I want to start a blackberry application to fetch the email addresses from BES. On BES there is mapping of PIN to Email. So can we write any method to retrieve email address mapped on BES by sending some PIN or IMEI number as a parameter on my blackberry application? If anyone knows, please help me.


Thanks in advance

See my signature - if for nothing else, there are a ton of SQL queries in the reporting section of BerryStats that may help you with some of the verbage if going the ADO route.