| Author |
Message |
betrek
Guest
|
 Posted:
Thu Oct 27, 2005 8:51 pm Post subject:
connecting to Database |
|
|
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 |
|
| Back to top |
|
 |
Ian Morrish
Guest
|
| Posted:
Fri Oct 28, 2005 12:51 am Post subject:
Re: connecting to Database |
|
|
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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
| Quote: | 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 |
|
|
| Back to top |
|
|
betrek
Guest
|
| Posted:
Fri Oct 28, 2005 4:52 pm Post subject:
Re: connecting to Database |
|
|
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:
| Quote: | 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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
Ian Morrish
Guest
|
| Posted:
Sat Oct 29, 2005 8:50 pm Post subject:
Re: connecting to Database |
|
|
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@discussions.microsoft.com> wrote in message
news:FF1543C1-01D7-409E-B126-0567C0F99872@microsoft.com...
| Quote: | 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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
betrek
Guest
|
| Posted:
Mon Oct 31, 2005 9:51 pm Post subject:
Re: connecting to Database |
|
|
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:
| Quote: | 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@discussions.microsoft.com> wrote in message
news:FF1543C1-01D7-409E-B126-0567C0F99872@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
Ian Morrish
Guest
|
| Posted:
Tue Nov 01, 2005 9:51 am Post subject:
Re: connecting to Database |
|
|
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@discussions.microsoft.com> wrote in message
news:589FFF30-0C15-45AB-A6B2-41AD6F152F64@microsoft.com...
| Quote: | 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@discussions.microsoft.com> wrote in message
news:FF1543C1-01D7-409E-B126-0567C0F99872@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
betrek
Guest
|
| Posted:
Tue Nov 01, 2005 5:51 pm Post subject:
Re: connecting to Database |
|
|
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:
| Quote: | 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@discussions.microsoft.com> wrote in message
news:589FFF30-0C15-45AB-A6B2-41AD6F152F64@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:FF1543C1-01D7-409E-B126-0567C0F99872@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
Ian Morrish
Guest
|
| Posted:
Wed Nov 02, 2005 9:05 am Post subject:
Re: connecting to Database |
|
|
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@discussions.microsoft.com> wrote in message
news:0D323DB2-7924-49B6-BA90-F04256692DAA@microsoft.com...
| Quote: | 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@discussions.microsoft.com> wrote in message
news:589FFF30-0C15-45AB-A6B2-41AD6F152F64@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:FF1543C1-01D7-409E-B126-0567C0F99872@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
betrek
Guest
|
| Posted:
Wed Nov 02, 2005 5:51 pm Post subject:
Re: connecting to Database |
|
|
Hi,
The link you send me is password protected. Is there another way to get
those instractions?
Thank you.
Betre
"Ian Morrish" wrote:
| Quote: | 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@discussions.microsoft.com> wrote in message
news:0D323DB2-7924-49B6-BA90-F04256692DAA@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:589FFF30-0C15-45AB-A6B2-41AD6F152F64@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:FF1543C1-01D7-409E-B126-0567C0F99872@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
Ian Morrish
Guest
|
| Posted:
Sat Nov 05, 2005 9:50 am Post subject:
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@discussions.microsoft.com> wrote in message
news:34F38740-220A-414C-B665-3059D178971B@microsoft.com...
| Quote: | 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@discussions.microsoft.com> wrote in message
news:0D323DB2-7924-49B6-BA90-F04256692DAA@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:589FFF30-0C15-45AB-A6B2-41AD6F152F64@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:FF1543C1-01D7-409E-B126-0567C0F99872@microsoft.com...
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@discussions.microsoft.com> wrote in message
news:604C9F75-09DA-4EBA-905A-7A681F717091@microsoft.com...
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
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in