Blackberry Enterprise Server – Only Remote SQL Available Local Greyed Out

I was installing Blackberry Enterprise Server 5.03 on a Small Business Server 2008 Box. Following through the receommend guide here http://www.edutech.me.uk/bes-express/installing-bes-express-on-sbs2008-server/

However after the reboot of the server it brought up the Database Management prompt and would not allow me to select a Local Server even though I had asked the Blackberry setup to create a New Database. Looking through the SQL Server 2005 Configuration it didn’t look like the BLACKBERRY Database had been setup. After a brief look online it looks like the blackberry account ( besadmin ) setup needs to modify through Active Directory via the following:

Account tab > Account options: Select option: Use Kerberos DES encryption types for this account.

I made the change, uninstalled the software and went through re installation again , and after the reboot , the database had been created this time and setup was able to complete

Tags: Blackberry Enterprise Server, Only Remote SQL Available Local Greyed Out

Sage Payroll 2010 Splash Screen Goes Away

After installing Sage Payroll 2010 on a Windows 7 machine the program loads with a splash screen then disappears. Even after running is with administrator rights and Windows XP compatibility mode the issue still occurs.

The fix is to Open a Command Prompt Screen , Start , Type CMD right click and run as administrator

Enter “regsvr32 msxml3.dll”

Reinstall Sage Payroll Over the Top

Sage Payroll now works !

Tags: regsvr32 msxml3.dll, Sage Payroll 2010 Splash Screen Goes Away

How to get the product ID on the WP Ecommerce Transaction Results Page

The page here has a solution however it doesn’t work : http://wpquestions.com/question/show/id/1840 and the topic is closed hence for this post!

You need to edit this file : wpsc-transaction_results.php

I placed my code after the true statment for correct purchase

 if ( ( true === $echo_to_screen ) && ( $cart != null ) && ( $errorcode == 0 ) && ( $sessionid != null ) ) {           
The value you need is $cart[0][prodid];

There are 2 array’s you can get information from $purchase_log and $cart

 

 

Tags: How to get the product ID on the WP Ecommerce Transaction Results Page

Windows 7 Installation Setup stuck on “starting windows”

Recently I was trying to install Windows 7 on a custom built system with an asus m2n-sli deluxe motherboard. When running through the Windows 7 Setup , the screen would stay on the “Starting Windows” screen and then eventually come back with a Blue Screen with the Error machine check exception. I tried different power supplys , windows disks and memory. Eventually I found machine check exception is in fact an issue with the processor speaking to the memory. I increased the CPU voltage from 1.41 volts to 1.51 and increased the DDR2 memory to 1.9v and Windows 7 setup went through fine!

Tags: asus m2n-sli deluxe, Windows 7 Installation Setup stuck on "starting windows", windows 7 machine check exception

Iphone or Mobile Device only recieves email read through WebAccess or Outlook Open

Recently a user synced his iphone to an SBS 2003 box , however email would only come through when their Outlook was open recieving mail , or the user would read the email in Web Access. This is an issue to do with Active sync and Trend Antivirus that the below registry entry fixes :

Browse to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSExchangeIS\VirusScan via regedit

Change the value of “ProactiveScanning” to 1 and close.

Restart IIS and Exchange services to make sure it gets applied.

Tags: new emails unless Outlook is open, Outlook Open for Iphone Recieve Emails, Read emails webacess come through on iphone

ASP Code to Read from a .mdb access file

Recently a collegue contacted me for some help with his university degree. The project was to create a website that was backed by a database. My background is mainly PHP and MySQL however, the course had been teaching them how to manipulate an MDB Access Database file using ASP. The outline of the task was a document management system for projects.

• A user would enter their unique company number into a page
• It would list available projects for that company
• User would select the project and login with a username and password
• The website would list all files which he had permission to access

The tutorials the lecturer had given out used dreamweaver to create the ADODB.Connection , however it seemed an over complicated way of doing it. After a bit of online research my first ASP project is below ( Could be better but only had an evening to do it! )

index.asp

code here : http://pastebin.com/7s739FKa

This code manages the Company ID input then list the projects from that company

login.asp

Takes the project ID from index.asp and checks the permissions table after username and password verficiation for files they have access to

code here  : http://pastebin.com/BmNiXZgz

db.mdb

File here : http://www.pariswells.com/upload/db.mdb

4 Tables

Users -> Username , Password and ID

Projects -> Project Name , Company ID Associated with that Project and Project ID

Permissions -> FileID and UserID

Company -> Company Name , Company Number and ID

 

Definitely prefer PHP to ASP!

Tags: ASP Code to Read from a .mdb access file, Inner Join Asp, mdb asp lookup, query mbd with asp

Windows 7/XP Install Printer Without Being Local Administrator

If you run a “locked down” group policy model and need users to add new network and local printers to their machine without being Local Administrators you will need to configure the below group policy. This will stop the  UAC Box in Windows 7 coming up and asking to administrator permissions to run “C:\windows\system32\NtPrint.exe”. This can be applied through a domain controller via a networked group policy or locally using gpedit.msc

In Windows XP this setting is configured in

User Configuration -> Administrative Templates -> Control Panel -> Printers

However in Windows 7 this setting is configured in

Computer Configuration -> Policies -> Administrative Templates -> Printers : Point and Print Restrictions

N.B. If you want to deploy the below group policy you will need to have your Domain Controllers up to the 2008 R2 Schema or use this tool to Modify the Windows 7 Policy

http://blogs.technet.com/b/iftekhar/archive/2009/08/13/remote-server-admin-tools-rsat-for-windows-7-now-available.aspx

You need to set Point and Print Restrictions to DISABLED

Tags: C:\windows\system32\NtPrint.exe, Install Printer Without Being Local Administrator, PSetupElevatedInstallDownloadLegacyDriverW, User Account Control Adding Printer

Easyspace’s TXT DNS Records

Most Cloud Services such as Frontbridge or Google Apps now require you to verify ownership of your domain with a TXT DNS Record. I recently had to update this for a domain hosted with Easyspace and a quick search around the control panel and google for how to add this proved fruitless. Their control panel only gives you A Record, MX or CName…

Turns out after further investigation, you can’t do this yourself and you either have to raise a support ticket through your Customer Login or a bit quicker – call them on

Support : 0370 755 5066 ( 0370 calls are charged at a local rate in the UK )

Over the phone , they will give you an email to send the request to. This can take up to 3 hours for them to action , then another few hours to propagate

This information would have been really useful on here

http://helpdesk.ufindus.com/faq.php?do=article&articleid=1488 Where they tell you what a TXT Record is , or their DNS Records Page

http://helpdesk.ufindus.com/faq.php?do=article&articleid=1558

Hope this information helps someone else!

Tags: Easyspace TXT DNS

Before proceeding you must first launch Adobe Acrobat and accept the End User License Agreement

When a user tried to open a PDF Document via Adobe Reader X after an Adobe Reader Update it produced the following error message “Before proceeding you must first launch Adobe Acrobat and accept the End User License Agreement” I thought this related to the End User License Agreement of Adobe Reader , so I tried to open it standalone but it did not bring the terms and conditions. The machine previously had Adobe Acrobat 8.0 Installed as a trial , but this was unistalled so Adobe Acrobat 6.0 Licensed copy could be installed. I tried to open adobe acrobat 6.0 however there was no End User License Agreement either. It looks like Adobe leaves some old registry information , so a complete unistall of Adobe Products on the machine and reinstall should fix the problem. However an easy fix, is to open up Adobe Ready , Go to Edit / Preferences / General Then tick the box to “Enable Protected Mode”

Tags: Adobe Acrobat 6.0, Adobe Acrobat 8.0, Adobe Reader X Protected Mode, Before proceeding you must first launch Adobe Acrobat and accept the End User License Agreement

Excel 2003 Slow Opening From Network Share

Recently a user was having issues opening excel files , were by a 600kb file could take around 20 seconds to open. When you copied this file locally to the computer it opened it straight away , and other computers accessing the file had no problem. What I did notice was when you opened the file , the network usage would spike to 7mb/s for the entire time while only retrieving a 600kb file. Opening .pdf / .doc files around double or triple the size would open instantly A bit of research online only proved the fault/fix with a Windows 7 setup accessing office 2003 documents http://support.microsoft.com/kb/982860 I tried the “Under the registry entry, disable these two registry keys: Right-click Enablesecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK. Right-click Requiresecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK.” However no success , my setup however was Windows XP and Office 2003. After much searching the fix was actually pretty recent from microsft http://support.microsoft.com/kb/2570623 “reduces performance due to the network traffic when reading in the parts of the workbook” So upgrade to 2007/2010 or disable OFV!

You can perform the below fix manually , or I have create a .re file which does it http://www.pariswells.com/upload/fix.zip

You can use the EnableOnLoad registry entry to configure how you want Excel to handle opening workbooks for the OFV. By default, the EnableOnLoad entry is not present in the Windows registry. To add the EnableOnLoadentry to the Windows registry, follow these steps:

1. Exit Excel.
2. Click Start, click Run, type regedit, and then click OK.
3. Locate and then click to select the following registry key: **EDIT** Thanks to Frank in the comments , the proper key is ” HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0″ Old key “HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\”
4. After you select the key that is specified in step 3, point to New on the Edit menu, and then click Key.
5. Type Excel, and then press ENTER.
6. Select Excel, point to New on the Edit menu, and then click Key.
7. Type Security, and then press ENTER.
8. Select Security, point to New on the Edit menu, and then click Key.
9. Type FileValidation, and then press ENTER.
10. Select FileValidation, point to New on the Edit menu, and then click DWORD Value.
11. Type EnableOnLoad, and then press ENTER. Note: The default value is 0 which disables the validation.
12. On the File menu, click Exit to quit Registry Editor.

Tags: .xls slow from network share, 2570623, Excel 2003 slow to open network, Excel Slow Opening From Network Share, High Network Usage Office 2003, OFV, The Office File Validation, Windows XP Excel 2003 slow opening