Accessing MS Access from PowerShell

I was trying to modify some scripts on MS Technet Script Guy's blog for working with PowerShell and MS Access.

Kept getting an error when trying to open the database, the example was using an .mdb file extension. I left my test file with the Office 2007 default of .accdb.

The example had the filename and path in a variable thought that was the problem at first then realized the connection string seemed to be referring to version 4.


I found that the ADO string need to be "Microsoft.ACE.OLEDB.12.0" rather then "Microsoft.Jet.OLEDB.4.0"

Example of the error
***********************************
PS C:\code\examples-powershell\msaccess> $cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = C:\code\examples-pow
ershell\msaccess\msaccessdatadb1.accdb")
Exception calling "Open" with "1" argument(s): "Unrecognized database format 'C:\code\examples-powershell\msaccess\msac
cessdatadb1.accdb'."
At line:1 char:9
+ $cn.Open <<<< ("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = C:\code\examples-powershell\msaccess\msaccessdatadb1
.accdb")
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : ComMethodTargetInvocation

PS C:\code\examples-powershell\msaccess>



************************************



2008 Winter Scripting Games - Event 9 - MS Access PowerShell
http://blogs.technet.com/heyscriptingguy/archive/2009/08/13/hey-scripting-guy-can-i-query-a-microsoft-access-database-with-a-windows-powershell-script.aspxhttp://blogs.technet.com/heyscriptingguy/archive/2009/08/13/hey-scripting-guy-can-i-query-a-microsoft-access-database-with-a-windows-powershell-script.aspx
The file I was working with - ScriptingGamesBeginnerEvent4.ps1

Other reference:
How to find a record using ADO and Jet OLE DB provider
http://support.microsoft.com/kb/283874

Bandwidth Availability

I typed in the address of an office I am working at to see what the results were:

http://riveroffers.com/

Carrier Distance Capability
1 3.17 miles 10 mbps - 1 gbps
2 4.16 miles 10 mbps - 1 gbps
3 4.27 miles 10 mbps - 1 gbps
4 4.49 miles 10 mbps - 1 gbps
5 5.27 miles 10 mbps - 1 gbps
6 5.49 miles 10 mbps - 1 gbps
7 7.22 miles 10 mbps - 1 gbps
8 7.94 miles 10 mbps - 1 gbps

the web page then tells you that cost vary depending if fiber is already run to the building. Also they ask for contact information if you want to go forward.

Some notes about Exchange 2007

Documenting some notes on Microsoft Exchange 2007 High Availability
1) single copy clusters (SCCs) - single data center - must meet clustering hardware specs
2) cluster continuous replication (CCR) - uses MS Clustering and File Share Witness, can be done across data centers.
3) Local Continuous Replication ( LCR ) - lets you make a copy of the Exchange Stores on separate storage (hard drives) attached to the same server.
LCR does not protect against server failure.
4) SCR (Standby Continuous Replication) - 2007 SP1 - uses SQL log shipping like CCR, however the nodes do not have to clustered.

Source:
http://en.wikipedia.org/wiki/Microsoft_Exchange_Server#Clustering_and_high_availability

Another page that had lots of nice diags was:
http://telnetport25.wordpress.com/2007/11/14/exchange-2007-database-clustering-and-high-availability-features/


Question came up today....
Will Exchange 2010 support public folders....


here is a link that has discussion threads from MS MVP's who say....
http://social.technet.microsoft.com/Forums/en-US/exchange2010/thread/26d2c23d-136d-4814-b44d-0378a61f0d5c

yes! in a fashion similar to Exchange 2007 SP1.



Exchange 2007 server roles information:
# Edge Transport
# Hub Transport
# Client Access
# Mailbox - only role that can be used on SCC cluster.

Resource - Server Roles
Introduction to Exchange 2007 Server Roles
http://www.msexchange.org/tutorials/Introduction-Exchange-2007-Server-Roles.html

Getting Started with Exchange Server 2007: Server Roles
http://technet.microsoft.com/en-us/library/aa996031(EXCHG.65).aspx


Other Notes:
MS Recommended DAS - direct attached storage, also stating to check with storage vendor, but RAID 10 is recommended, for performance and reliability.

Simple svn gui for Ubuntu

I looked at several pages and post to find a good answer.

My first attempt was to install Eclipse with Subclipse, the plugin had problems installing. I will re-attempt it again later. In the past I found eclipse sluggish on low memory machines, like the one I was installing it on anyway.

I saw this posting about installing scripts for nautilus in ubuntu.
my version Jaunty 9.04.

Link
http://www.automaticable.com/2008-09-15/easy-subversion-gui-for-nautilus-and-ubuntu/

steps it outlines:
aptitude install nautilus-script-collection-svn

nautilus-script-manager enable Subversion

killall nautilus

next step is for my to switch from file urls to svn urls.
http://www.codeandcoffee.com/2007/06/how-to-setup-a-subversion-server-on-linux/

freenx and Nomachine Client on XP - ALT-TAB

I have been using ubuntu 9.04 running freenx and a windows xp client - the alt-tab not working between apps was annoying. Found this article on how to configure the nomachine client to let the session capture the ALT-TAB and Print Screen.

Link to article

Quote:
"Ctrl + Alt + K key combination to enable/disable the catching of Alt+Tab and Print Screen keys within the NX session."

Safe to check IP Address

DynDNS.org is well respected and here is a link to their IP address checker.

http://checkip.dyndns.org/


I had heard in the past doing a google search for what is my ip may land you at a page with spyware, virus, etc.

Uninstall Perl Module

Found in a Google search that someone who goes by celso has perl script for removing modules.

http://www.celsobarriga.com/2008/01/10/uninstall-perl-module/


I wanted to remove Net::LDAP after I had done a force install of in in my win32 strawberry perl setup and had answered "y" to prompt for installing optional modules. I read on a wiki for strawberry perl the that module installed fine for a user with just the mandatory modules.

Looking for FTP solutions

This is a great list of Linux FTP Server Programs
http://www.terinea.co.uk/blog/2008/03/27/linux-ftp-server-with-a-graphical-user-interface-gui/