Mike
Fri Feb 20 08:14:58 CST 2004
This is a multi-part message in MIME format.
------=_NextPart_000_00DE_01C3F7CC.AF64BE30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Data View is just that i.e. for viewing.
It is not suitable for editing, deleting etc.
The only way that I would do that (hesitantly) in a WSS site would be to =
write some ASP scripts that access the database and put them in the =
appropriate ready made web part for them (probably the Page Viewer web =
part - someone will correct me if I'm wrong)
But then you said you didn't want to write ASP ...
Mike Walsh, Helsinki, Finland
"Cliff Hooker" <chooker@ff1.co.uk> wrote in message =
news:86nZb.4$bT3.711@news.dircon.co.uk...
Thanks for the advice...
What I'm looking at doing is to create pages on the Share point server =
that I can program to access, edit, delete etc data from an SQL server =
on a separate box.
I use the database connection wizard to do this normally (Being too =
lazy to learn ASP for my simple needs).
I'll see what I can do with the data view.
Many thanks.
Cliff.
"Mike Walsh [MVP]" <englantilainen@hotmail.com> wrote in message =
news:uj6sMGh9DHA.2392@TK2MSFTNGP11.phx.gbl...
Cliff, adding to Gregg's (which of course he knew)
If the latter then use FP 2003's Data View feature to access the SQL =
Server information and present it in web part form on your WSS site.
Mike Walsh, Helsinki, Finland
WSS FAQ at wss.collutions.com
Please post questions to the newsgroup only.
"Gregg Smith" <SharePoint_MSDN@hotmail.com> wrote in message =
news:uDDBhzW9DHA.2044@TK2MSFTNGP10.phx.gbl...
I am not entirely sure what it is you are trying to do? Can you =
give some more details. Are you looking to move your MSDE install over =
to your SQL install or are you just trying to access some data and =
display it on a web part page.
"Cliff Hooker" <chooker@ff1.co.uk> wrote in message =
news:msqYb.1$vm5.1829@news.dircon.co.uk...
I Have set up Sharepoint services 2003 using MSDE on the =
Sharepoint server (Not wanting to mess with my existing SQL 2000 =
installation on a separate machine). Is it possible to create a network =
connection (I also have Frontpage 2003), from the Sharepoint web site to =
the external SQL datasource? It seems data connections for external =
non-Sharepoint data sources are disabled?
Is this right or am I completely mistaken?
Thanks in anticipation.
Cliff.
------=_NextPart_000_00DE_01C3F7CC.AF64BE30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Data View is just that i.e. for=20
viewing.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>It is not suitable for editing, =
deleting=20
etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The only way that I would do that =
(hesitantly) in a=20
WSS site would be to write some ASP scripts that access the database and =
put=20
them in the appropriate ready made web part for them (probably the Page =
Viewer=20
web part - someone will correct me if I'm wrong)</FONT></DIV><FONT =
face=3DArial=20
size=3D2></FONT><FONT face=3DArial size=3D2></FONT>
<DIV><BR><FONT face=3DArial size=3D2>But then you said you didn't want =
to write ASP=20
...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>Mike Walsh, Helsinki, Finland<BR></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Cliff Hooker" <<A=20
href=3D"mailto:chooker@ff1.co.uk">chooker@ff1.co.uk</A>> wrote in =
message <A=20
=
href=3D"news:86nZb.4$bT3.711@news.dircon.co.uk">news:86nZb.4$bT3.711@news=
.dircon.co.uk</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for the advice...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>What I'm looking at doing is to =
create pages on=20
the Share point server that I can program to access, edit, delete etc =
data=20
from an SQL server on a separate box.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I use the database connection wizard =
to do this=20
normally (Being too lazy to learn ASP for my simple =
needs).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'll see what I can do with the data=20
view.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Many thanks.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Cliff.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Mike Walsh [MVP]" <<A=20
=
href=3D"mailto:englantilainen@hotmail.com">englantilainen@hotmail.com</A>=
>=20
wrote in message <A=20
=
href=3D"news:uj6sMGh9DHA.2392@TK2MSFTNGP11.phx.gbl">news:uj6sMGh9DHA.2392=
@TK2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Cliff, adding to Gregg's (which of =
course he=20
knew)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>If the latter then use FP 2003's =
Data View=20
feature to access the SQL Server information and present it in web =
part form=20
on your WSS site.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>Mike Walsh, Helsinki, Finland<BR>WSS FAQ at=20
wss.collutions.com<BR>Please post questions to the newsgroup =
only.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Gregg Smith" <<A=20
=
href=3D"mailto:SharePoint_MSDN@hotmail.com">SharePoint_MSDN@hotmail.com</=
A>>=20
wrote in message <A=20
=
href=3D"news:uDDBhzW9DHA.2044@TK2MSFTNGP10.phx.gbl">news:uDDBhzW9DHA.2044=
@TK2MSFTNGP10.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I am not entirely sure what it is =
you are=20
trying to do? Can you give some more details. Are you looking to =
move your=20
MSDE install over to your SQL install or are you just trying to =
access=20
some data and display it on a web part page.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Cliff Hooker" <<A=20
href=3D"mailto:chooker@ff1.co.uk">chooker@ff1.co.uk</A>> =
wrote in=20
message <A=20
=
href=3D"news:msqYb.1$vm5.1829@news.dircon.co.uk">news:msqYb.1$vm5.1829@ne=
ws.dircon.co.uk</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I Have set up Sharepoint =
services 2003=20
using MSDE on the Sharepoint server (Not wanting to mess with my =
existing SQL 2000 installation on a separate machine). Is it =
possible to=20
create a network connection (I also have Frontpage 2003), from =
the=20
Sharepoint web site to the external SQL datasource? It seems =
data=20
connections for external non-Sharepoint data sources are=20
disabled?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Is this right or am I =
completely=20
mistaken?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in =
anticipation.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial=20
=
size=3D2>Cliff.</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOC=
KQUOTE></BODY></HTML>
------=_NextPart_000_00DE_01C3F7CC.AF64BE30--