Archive for October, 2009

SQL Publishing of Oracle database using OLE DB Provider

Posted by Mark Raborn in WIGITAL on 2009/10/25

Article in progress…

Oracle Publishing to SQL Server

MSDN – Oracle Publishing Overview

http://msdn.microsoft.com/en-us/library/ms151229.aspx

MSDN – Heterogeneous Database Replication

http://msdn.microsoft.com/en-us/library/ms151149.aspx

TECHNET – How Oracle Publishing Works

http://technet.microsoft.com/en-us/library/ms151845.aspx

TECHNET – Configuring a Oracle Publisher

http://technet.microsoft.com/en-us/library/ms151243.aspx

MSDN – Configuring an Oracle Publisher

http://msdn.microsoft.com/en-us/library/ms151243.aspx

TECHNET – Design Considerations and Limitations for Oracle Publishers

http://technet.microsoft.com/en-us/library/ms151859.aspx

MSDN – Publishing Data and Database Objects

http://msdn.microsoft.com/en-us/library/ms152559.aspx

MSDN – Data Type Mapping for Oracle Publishers

http://msdn.microsoft.com/en-us/library/ms151817.aspx

Oracle Business Intelligence

Oracle Clients

http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Oracle Provider for OLE DB

http://www.oracle.com/technology/tech/windows/ole_db/index.html

Oracle BI Publisher 10g R3: Fundamentals – LVC

http://education.oracle.com/pls/web_prod-plq-dad/web_prod.view_pdf?c_id=D70237GC10&c_org_id=1080544&c_lang=US

, , , , ,

No Comments

Visio Icons Stencils Templates and Downloads

Posted by Mark Raborn in WIGITAL on 2009/10/18

Visio Downloads and Visio Learning

Visio is a powerful tool for network diagrams, server topology, the mapping of ( switch, router and firewall ) routes and all types of hierarchical drawing. To learn more about Microsoft Visio, visit the Visio section of Microsoft’s Office site here.

At WIGITAL, we use Visio to provide diagrams to our clients. Visio’s sophisticated features include data binding to Excel, Exchange, SQL, ODBC, etc… as the basis for logically controlling Visio shapes in Visio diagrams.

For Visio users, the hope of finding useful Visio stencils and icons to include in diagrams can lead to a number of hours of web searching. Fortunately there are a few good sites and Visio MVP contributions to choose from on the internet.

Here are some of the free download resources we found for Visio on the web. Please share them with others as you need.

Microsoft’s Visio Sites on the Web

There are two primary Visio sites that Microsoft hosts.

The first is a part of Office.Microsoft.com and for Visio go to http://Office.Microsoft.com/Visio

Microsoft’s newest Visio specific website is http://visiotoolbox.com/
Where you can download:

There is also:

Visio Learning Resources

To learn Visio quickly, we suggest these Visio learning tools

Microsoft’s Videos Site – search word Visio

VisioToolbox Training Section

Microsoft Office Help for Visio

Microsoft Office Visio Training Courses

 

3rd party Visio Stencils, Plugins, and Tool Collections

A large collection of links to 3rd party Visio stencils, plugins, and tools are available in two large link lists at:

Microsoft Visio MVP’s have made a Visio link list at Visio.MVPS.org

There is also a large library of Visio stencils a Visio Cafe

Visio Icons and Stencils by Manufacturer

Lastly, here is a list of Visio resources by Manufacturer. We’re listing the full links because link list change often and become outdated. Listing the full URL should allow you to poke around at their site if they do.

No Comments

Dynamic Deletion of DNS Records Fails when Demoting Domain Controller

Posted by Mark Raborn in SBS on 2009/10/10

Event ID: 5775 The dynamic deletion of the DNS record failed on DNS server

Today we were finishing up the migration of SBS 2003 to SBS 2008 and had reached the final stage where the SOURCE Small Business Server 2003 Domain Controller was ready to be demoted using dcpromo.

Problems occurred relating to Event ID: 5775

Ultimately the solution related to auditing DNS Records and cleaning up the DNS entries as we had also reconfigured the Subnet of our SOURCE SBS 2003 Server right before migrating to SBS 2008. Although the migration went well, demoting the SBS 2003 Domain Controller did not. A careful audit of all DNS entries with deletions of all inaccurate records relating to the SBS 2003 Server was ultimately the cure.

In reading about this Error, possible other solutions for similar scenarios include running DCDiag.exe , checking the Server LAN and WAN NICs for any multi-homing ( possible in single server scenarios like SBS ), and entering the “new” DESTINATION SBS 2008 IP Address as the DNS Server entry on the SOURCE SBS 2003 Servers LAN NIC.

Reference material here:

http://support.microsoft.com/kb/259277/en-us

http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=Windows+Operating+System&ProdVer=5.2&EvtID=5775&EvtSrc=NetLogon&LCID=1033

http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=Windows+Operating+System&ProdVer=5.2&EvtID=5781&EvtSrc=NetLogon

, , , , , ,

No Comments