Tuesday, December 26, 2006

SharePoint and Data View

To create data source to Backup exec database (MSDE format)
  1. Use SA and password for SA can be changed with Enterprise Manager
  2. Use table "JobHistorySummary"

For ePO database (SQL 2000) - McAfee ProtectionPilot use "AVIView_LeafNode" view, but again I was not sucsessful with Windows Integrated Authentication, so used SA

Connection to Access databases is still not clear for me, despite the article with the connection description, I tried with Office Designer 2007:

For this demo I download a sample Access database from Office Online
http://office.microsoft.com/en-us/templates/TC010185481033.aspx
and placed it in a directory on my WSS server. The MDB can't be on a network share.Enable the Data Retrieval Services from the WSS Central Adminstration.
run the following stsadm command to check the OLEDB providers that are enabled

stsadm -o getproperty -propertyname data-retrieval-services-oledb-providers


If you don't see Microsoft.Jet.OLEDB.4.0 in the list, append it to the existing list of providers and set the new list of providers similar to this:

stsadm -o setproperty -propertyname data-retrieval-services-oledb-providers -propertyvalue DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;Microsoft.Jet.OLEDB.4.0


In FrontPage, add a Data Source under Database Connection. You will have to select a Custom Connection string which should look like this

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Drop\sample.mdb

2 comments:

  1. Anonymous12:22 AM

    I found this site using [url=http://google.com]google.com[/url] And i want to thank you for your work. You have done really very good site. Great work, great site! Thank you!

    Sorry for offtopic

    ReplyDelete
  2. Anonymous11:15 AM

    [url=http://firgonbares.net/][img]http://firgonbares.net/img-add/euro2.jpg[/img][/url]
    [b]nero 9 torrent, [url=http://firgonbares.net/]software prices uk[/url]
    [url=http://firgonbares.net/][/url] microsoft office 2003 update Acrobat Pro 8
    sell our software [url=http://firgonbares.net/]Macintish Software[/url] buy used adobe software
    [url=http://firgonbares.net/]academic software windows xp[/url] does oem software
    [url=http://firgonbares.net/]academic adobe software[/url] to buy pirated software
    free download nero 9 [url=http://firgonbares.net/]2009 oem software[/b]

    ReplyDelete