[amukhey]

Does anyone get the message Access Denied? I keep getting this.

Can anyone advise?

[noname]

Hey amukhey, the "DST Query tool" needs to be running on a computer that can connect to the SQL server. Same logic as the remote Blackberry manager.

1. Access from PC where the tool is running
2. Named Pipes and TCPIP enabled on SQL server

[Debau]

I get the same error message, and I am running it on the server that has the SQL db's!

[DarthBBerry]

It might be in the syntax of your command line for the query when you try to run it. I have my query tool in a desktop folder called: query. (duh)

"C:\Documents and Settings\blackberry\Desktop\query\DST2007Query.exe " -n SERVER NAME -db besmgmt -b all -OL "C:\Documents and Settings\blackberry\Desktop\query"

Before I got the syntax corrected, I got errors too. Be sure to use the quotes as well.
FYI - Using it this way will run the query and put the results in the same folder as the exe. Convenient!

[elgauchogrub]

If you're running SQL authentication you also need the -dbauth -dbuser <name> and -dbpass <password> switches included in the command line.

[JJimmy]

I had a lot of problems with this tool as well at first, but I finally got everything figured out. Here are some helpful tips:

1. Figure out what type of authentication you're using to your database. Open up the "Blackberry Server Configuration" in your BES server's control panel. Switch to the "Database Connectivity" tab. In the "SQL Information" section, whatever is listed as the "Database:" is the name of your db (I'm guessing for most people it is BESMgmt). The bottom section, authentication, will show you if you're using Windows authentication or SQL authentication. If you're using windows, you don't need the SQL switches, so this is important to remember.

2. Once you've figured that information out, open a command prompt and navigate to your DST2007Query.exe file. Once you're in the directory, use the appropriate switches based on your findings from step 1.

Example for a database that uses Windows authentication:

DST2007Query.exe -n SERVERNAME -db DBNAME -b all

Substitute SERVERNAME for the NetBIOS name of your BES server, and DBNAME for the name of the DB you gathered in step 1.

NOTE: While the tool says that you don't have to fill out server name and that it uses "localhost" as the default, this DID NOT work for me (even though I was running the tool on the BES server). I had to fill in my BES Server's NetBIOS name in order for the database to open successfully. Not even explicitly using "localhost" worked, I had to type in the server name.

Example for a database that uses SQL authentication:

DST2007Query.exe -n SERVERNAME -db DBNAME -b all -dbauth

Again, substitute SERVERNAME for the NetBIOS name of your BES server, and DBNAME for the name of the DB you gathered in step 1. I will also note again that not specifying the server's name or explicitly using "localhost" in the command string did not work for me, I had to use the NetBIOS name of the BES server (even if you're executing the tool on the BES server itself). I don't know if this will be true for everyone, but that was my experience. Anyway, when you execute this command, it will prompt you for the username and password of the SQL database. Fill in those details to connect.

I should note that I haven't tested the SQL command (we don't use SQL authentication), so if anyone believes it to be incorrect, please feel free to correct me.

For any other switches you may need, just execute the DSTQuery2007.exe without any other parameters and it will list out all the possibilities.

Once you are done running the utility, it will spit some data out on the command line and save a .csv file in either the directory that the DSTQuery2007.exe tool is located, or a different directory if you specified the -OL switch to use a different output path.

Hope this helps!

[centrekin]

What does N/A in the DST 2007Timezone Patcher column mean?

[Debau]

THANKS! That worked like a charm!

[amukhey]

Yup finally got this working...amazing tool when needed it the most.

[rhbergman]

Once you get the syntax of the command line utility the way you need it for your particular environment, consider putting the full DST2007Query command string into a batch file and using Windows Scheduler to call it regularly (say, twice a day). You can also create an FTP script and FTP to it a central server where you can easily audit the progress of your patch in your BES environment - this comes in particularly handy if you have multiple BlackBerry domains (SQL databases)

[stuwhite]

Originally Posted by centrekin

What does N/A in the DST 2007Timezone Patcher column mean?

It shows the version of the patch once installed. The current one is 1.5.

cheers
Stu

[stuwhite]

Originally Posted by amukhey

Yup finally got this working...amazing tool when needed it the most.

Have you tried the BoxTool DST Expert yet? Same info but nice GUI. There are a few discrepancies between it and DSTQuery right now but they are sorting them out.

cheers
Stu

[stuwhite]

Originally Posted by rhbergman

Once you get the syntax of the command line utility the way you need it for your particular environment, consider putting the full DST2007Query command string into a batch file and using Windows Scheduler to call it regularly (say, twice a day). You can also create an FTP script and FTP to it a central server where you can easily audit the progress of your patch in your BES environment - this comes in particularly handy if you have multiple BlackBerry domains (SQL databases)

Yeah this works a treat. I did that last week and have the script run every hour. OK, I am mainly using BoxTool now but having DSTQuery running every hour and dumping the file to a server is a nice sanity check.

[TonyEye]

Originally Posted by stuwhite

Have you tried the BoxTool DST Expert yet? Same info but nice GUI. There are a few discrepancies between it and DSTQuery right now but they are sorting them out.

cheers
Stu

Ajay - check out this thread... I'm downloading the BoxTone utility now.

http://www.blackberryforums.com/bes-...t-utility.html

- T -

[stuwhite]

Originally Posted by TonyEye

Ajay - check out this thread... I'm downloading the BoxTone utility now.

http://www.blackberryforums.com/bes-...t-utility.html

- T -

Make sure you get the patch if the download isn't patched. It addresses a few issues found in the first release. Top piece of kit.

[amukhey]

TONY EYE, Thanks meng good looking out.