Hmm. I must not be holding my tongue right. I think I will uninstall and try again. If that doesn't work, I will try again at home with a fresh machine.

The time stamp is right, I unzipped it on a Linux box and found the policy names in there so I'm at a loss as to what is wrong.

Has anyone else gotten this same error? I am unable to reproduce the error.

I just made an effort to reproduce this error to make sure I didn't forget something I did.

I opened ITPolicy2.sql in windows notepad and and saved the file (I didn't make any changes). I tried to load the data and got the same error message.

Thanks for helping out with the testing ebj. I am at work at the moment, so I can't easily duplicate. You are Correct. Since the file contains binary data, opening it with a text editor and saving it will corrupt it. I also would assume that a non-binary FTP transfer would corrupt it as well. Only extract it from the zip file once you are at your final destination (The Unite box). That is why I uploaded it as a zip to begin with.

Maybe I missed something here, but does the default ITPolicy installed by Unite disable bluetooth connectivity to the Desktop Manager? Or is it just a matter of bluetooth connectivity to Unite not working?

OK, at home I did a complete fresh install of all the stuff following Grim's instructions. Downloaded the zip file to the Unite box (was doing that before, just had a look at it on the linux box to insure something wasn't messing with it in transit). Extracted it and kept my paws off. Same error.

Would it be possible to post the hex strings for the blobs, or send them as a private message? Sorry to be so needy, I'm not normally this helpless when it comes to this stuff.

Any way, in my thrashing about to solve this I have come to some other conclusions that may assist others. Some of this may seem obvious, it does to me now that I think about it, but I'll post it in case it may help someone.

Grimlin, and anyone else, correct me if I'm wrong here, but from tinkering with BES Express I concluded that a BES has fewer IT Policies than handhelds. This is of course the rational way to do it. The BES UI modifies the IT Policy record, and the modified policy is pushed out to all units configured for that policy.

Unite seems to use one policy per handheld. Since it is only going to support 5 units, this is not onerous and it simplifies the UI. The issue is that if one creates a single instance of a Policy and links a user or users to it, then uses the Unite UI to alter some Device Management Services parameter Unite will alter that policy record, affecting all users linked to it. This makes sense from a BES point of view, but would not be as documented. Of course when one modifies the controlling database behind the back of the program, one can't really expect behavior to be as documented. Just something to be aware of. And you may want to keep a backup copy of your ITPolicy2 table, just in case.

Finally, even though I haven't been able to use your file Grimlin, I want to thank you for publishing all of this data. If nothing else, I can go back and dust off my BES Express and replicate your work. Sounds like fun!

Oops, gotta go, have a Vet appointment to keep.

Unless I am mistaken, the default functionality of a blackberry is to not allow bluetooth connectivity. ...or at least a blackberry with any ITPolicy at all. Unite lays down an ITPolicy. This blocks Bluetooth connectivity and any other browsers other than the Unite Browser. This is done so that you can control the browser through Unite.

When I was initially toying with it, I made a vbscript that read the handheld blob out of the database and displayed it. I will see if I can find it. If not, I will recreate. It will be later tonight or tomorrow though.

Great observation. That is absolutely correct and I should have pointed this out to everyone earlier. The reason for the ITPolicy per user is because to enable and disable phone, browser, etc, the Unite server has to modify the ITPolicy for the device.

If we were to really make this user friendly, we would need to create 6 new identical policies and completely replace the ITPolicy2 table. My current instructions only append to it. Why 6? Default is the one that the Unite server uses as a template. Unite1 - 5 are assigned to users. I assume that if you remove a user and add a new one back, it does not reuse an old policy, it probably creates a new one (Unite6, etc) and orphans the old policy. It would do this by making a copy of default and calling it Unite6. Then assign the new user to Unite6.

So, who is going to be the BB Unite! admins for all these "home users" who install Unite?

Seriously, this is neat stuff guys. Good work!

If you can find it great, otherwise you should be able to get it out by doing a select SQL querry in SSMSE. I did that to copy the blob from the default policy to Unite1 which gave me back my Internet and browsers (without putting the default policy at risk by linking to it ):

then:
You are correct about the orphan Unite<n> policies. At one particular excursion I deleted then added my blackberry, I ended up with Unite1 and Unite2 policies.

I also noticed that if you modify the blob in an active policy with the BB processes running it is pushed out almost immediately.

Wirelessly posted

Cool. Will play with it more tonight.

Wirelessly posted

I reread your post. Are you actually getting something back in ssmse? I just get blob. Not the hex value. That is why I used BCP to export. I can use the console queries to copy stuff, but not to export blobs. I have to use vbscript or bcp.

Wirelessly posted

In ssmes I click on new SQL Querry, enter the select statment, right click, select execute.

Mobile now so that's from memory, but yes I see the HEX. When I just open the table I see <binary>.

Wirelessly posted

I was just opening the table, that was the problem. Will pull hex values for you when I get home.

Wirelessly posted

Sweet! Thanks.

Here is my ITPolicy2 table (the parts that matter)

Will update top post later with instructions for not using BCP

Updated my selected policy with your HEX for Tracking. Withing minutes the dialog informing me tracking was activated start location processing (or words to that efffect) Yes/No came up. There is also now a Location Tracking option on the GPS options page. SyncLBS eventually got a record with the UserConfigId of my BB. Location and Alt are 0 but that could be due to signal strength in the house.

I would say its a success! Thanks again.

Wirelessly posted

Now. We need to write a webpage that interfaces with the google maps api... the Kidtracker 4000. Mwahahaha. As an added feature, you can sync your childs significant other with your unite server and have it set off alarms anytime the GPS coordinates are within 10 feet of each other.

Just wanted to thank Grimlin and hrbuckley for their work on this. The BCP method didn't work for me but changing the HEX value did. Great to have the usefulness of Unite, a functioning web browser and bluetooth connectivity again!

any chance you can add the html policy to unite?

i saw a thread about adding it to the BES.

Just a thought.

HOWTO: Enable/Disable HTML Email Processing and Rendering in BES 4.1 SP5 | BlackBerryNews.com

beautiful..............I installed your modifications. all i wanted was to unlock the use of other browsers. works now.

THANK YOU!!!!

i do not have BES. i did it all only with sqlserver 2005.

i also tried to put the html email on. that did not work...

using 4.5

I do not have a device with 4.5 yet. I will look at the server piece tonight though and see if it is possible to enable manually. Did the fields even exist? I haven't looked.

I'm getting that same error that hrbuckly was getting, but am a little unsure how to make those modifications manually. Anytime you can post step by step instructions would be greatly appreciated.

i dont know if the field exists. i was just hoping it did and went for it. didnt seem to affect it.
i also created a new email address to use with this. didnt want to make it mess up with the BIS accounts. i thought the unite emails would have a different color around them. (at least according to the security settings)

keep up the amazing work.

i tried to do my regular sync with desktop manager today. (on my pc, not the one running unite.) and it gave me a warning/error that it could not sync my address book, calendar, and notes. says they were set to do wireless sync....
i changes the address book and notes on the device. i make changes all the time and i want my outlook to reflect that. what are my other options? the only calendar that needs to be synced wirelessly is unite! can we mod this?

yeah that aggrivated me too about the policy

i put my wife on it, when i enter an appointment on my curve within seconds its by her too. now interstingly she on her 7130e can open and edit it. changes will reflect by both of us. i can not open it, even though i was the one who made it.

hmm. i cannot open any entries, even those not on unite. something really odd. i must have messed something in the database by me.

i can create appointments, the second i save them, they are locked

I don't use Outlook myself, but this behavior is not unexpected since the code is a stripped down BES. There may be a policy option on the BES to allow local syncing and wireless sync, Grim may be able to clarify. What we can't do is expect Grim, or anyone else, to publish all possible combinations and permutations of policy flags that anyone might need.

I see two ways forward: someone writes/adapts a tool to allow users to edit the policies themselves; or users lobby RIM to provide greater flexibility in Unite. In the absence of either of these you might want to look at a tool that will sync your Outlook to/from a SQL database. A little Googling turned up GeniusConnect, there must be others. This is not an endorsement of GeniusConnect, I haven't tried anything like this, not being an Outlook user, so YMMV .

You can also disable wireless sync. If not from calendar, options. Then definitely by going into advanced options/enterprise activation. Type Alt cnfg (pearl users use double tap). You can set wireless sync to No in there. Desktop sync should work after that.

I am glad you mentioned that. I was looking and it appears that the new Admin Tools put out by RIM (yesterday?) have some policy reporting and importing/exporting tools. I downloaded at work, but haven't had a chance to install. If they have potential, I will bring them home and test them on the Unite DB. I have a lot going on this week, so unless I have insomnia my postings will be sparse. Sorry.

we are anxiously awaiting your posts.

what i have been doing now is going into the calendar and address book and setting it to no. then after it finishes i turn it back on

No worries Grim, will look forward to reading what and when you can post.

I hope RIM will come up with a more flexible way of setting policies, that the average family computer maven can use. At the risk of starting a flame war I think Unite, with a few improvements, will do more to stave off iPhone encroachment into the Blackberry market, and advance Blackberries in the consumer market than any flashy new handheld.

Updating top post now. I made a User-friendly VBScript. You should no longer need to install the SSMSE

Almost there...just a couple more tweeks and I may have to jump in again

For such a manly avatar, you sure are a chicken...

Seriously though, what's missing for you? Not making promises, just curious.

Grimlin, YOU ARE SIMPLY THE BEST!!
This script works perfect, I have now Unite installed and all my browsers are back, amazing

If I could figure out a way to sync bith calendars and contast back to outlook I would be all over this again. I just dont want to have to keep two calendars

Can you clarify a bit. Do you want to have unite without shared contacts and calendar or do you want to have shared contacts and calendar along with wired outlook sync?