Re: connecting to Database

Hi,
It is a setting in your IE that is causing this problem. Just select cancel
and you should get the page.
(Your browser is sending your current credentials to my site which doesn't
understand them so it prompts for a correct logon even though the site is
anonymous).

Regards,
Ian
"betrek" <betrek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:34F38740-220A-414C-B665-3059D178971B@xxxxxxxxxxxxxxxx
> Hi,
>
> The link you send me is password protected. Is there another way to get
> those instractions?
> Thank you.
> Betre
>
> "Ian Morrish" wrote:
>
>> Hi,
>> Here are some simple instruction on how to connect 2 web parts so that
>> clicking on an item in one filters the results in the other.
>> http://www.wssdemo.com/Pages/connections.aspx?menu=Articles
>> I would try this with 2 sharepoint lists to start with, then replace one
>> of
>> the web parts with a Data View web part that is connected to your SQL
>> table.
>>
>> Regards,
>> Ian
>> http://www.wssdemo.com
>>
>> "betrek" <betrek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:0D323DB2-7924-49B6-BA90-F04256692DAA@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I don't have a knowledge to create a web part. Is it possible for you
>> > to
>> > explain each stapes so that I can follow it. As I tolled you before I
>> > am
>> > new
>> > to this environment.
>> >
>> > Thank you for your help
>> >
>> > Betre
>> >
>> > "Ian Morrish" wrote:
>> >
>> >> There is no OOTB option to use another source for a SharePoint list
>> >> column
>> >> other than another SharePoint list.
>> >> What I was getting at is that if you manually enter the customer ID in
>> >> the
>> >> Task list then you can create a web part page that when you select a
>> >> task,
>> >> it will show the customer details in a DVWP coming from another
>> >> database,
>> >> or, on selecting a customer from the DVWP, any tasks assigned to that
>> >> customer in the SharePoint list will be displayed.
>> >>
>> >> Regards,
>> >> Ian
>> >> http://www.wssdemo.com
>> >>
>> >> "betrek" <betrek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:589FFF30-0C15-45AB-A6B2-41AD6F152F64@xxxxxxxxxxxxxxxx
>> >> > Hi Ian Morrish,
>> >> >
>> >> > Thank you for your help. I have some more questions. I can connect
>> >> > the
>> >> > portal server to SQL and I can see now the table that I want to see.
>> >> > Now
>> >> > my
>> >> > question is I want to see the customer ID on the Task list as a drop
>> >> > dwon
>> >> > list. Is there any iedia?
>> >> >
>> >> >
>> >> > "Ian Morrish" wrote:
>> >> >
>> >> >> Hi,
>> >> >> There is no Web Part coding required to use the DVWP. Some
>> >> >> understanding
>> >> >> of
>> >> >> XML/XSL helps.
>> >> >> Start here...
>> >> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_fp2003_ta/html/odc_FPUsingDIWwFP.asp
>> >> >>
>> >> >> Regards,
>> >> >> Ian
>> >> >> http://www.wssdemo.com
>> >> >>
>> >> >> "betrek" <betrek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> news:FF1543C1-01D7-409E-B126-0567C0F99872@xxxxxxxxxxxxxxxx
>> >> >> > HI Ian Morrish,
>> >> >> >
>> >> >> > I am new in this area, could you please tell me some information
>> >> >> > where
>> >> >> > I
>> >> >> > can
>> >> >> > get this webparts and how to configure Frotpage 2003 with spps? I
>> >> >> > don't
>> >> >> > have
>> >> >> > a knowlage to write a webpart.
>> >> >> >
>> >> >> > Thank you-- Betre
>> >> >> >
>> >> >> > "Ian Morrish" wrote:
>> >> >> >
>> >> >> >> Hi,
>> >> >> >> The best way to connect the task list with foreign data is via a
>> >> >> >> Web
>> >> >> >> Part
>> >> >> >> connection between the list and a Data View Web Part.
>> >> >> >> The Data View Web Part is configured with FrontPage 2003 to
>> >> >> >> connect
>> >> >> >> to
>> >> >> >> the
>> >> >> >> SQL table via an OLEDB connection defined in the Data Sources
>> >> >> >> section
>> >> >> >> which
>> >> >> >> can be accessed in FrontPage from the Data menu.
>> >> >> >>
>> >> >> >> So long as there is a column in both the SQL table and your task
>> >> >> >> list
>> >> >> >> then
>> >> >> >> you can use the selected task item to be used as a filter
>> >> >> >> parameter
>> >> >> >> for
>> >> >> >> the
>> >> >> >> Data View Web Part so that only relevant records are returned
>> >> >> >> from
>> >> >> >> the
>> >> >> >> SQL
>> >> >> >> table.
>> >> >> >>
>> >> >> >> Regards,
>> >> >> >> Ian
>> >> >> >> http://www.wssdemo.com
>> >> >> >>
>> >> >> >> "betrek" <betrek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> >> news:604C9F75-09DA-4EBA-905A-7A681F717091@xxxxxxxxxxxxxxxx
>> >> >> >> > HI evrybody!
>> >> >> >> >
>> >> >> >> > I want to connect SPPS2003 to one of the table in SQL-server.
>> >> >> >> > The
>> >> >> >> > SQL-server
>> >> >> >> > is in the same domain with SPPS2003. I want to achive to
>> >> >> >> > connect
>> >> >> >> > this
>> >> >> >> > table
>> >> >> >> > with Task list. What is the best way to do this? Thank you for
>> >> >> >> > your
>> >> >> >> > help.
>> >> >> >> >
>> >> >> >> > Betre
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages