FP2003 and Datasources

S

Steve C

Just installed FP 2003 and tried to use the wizard to create an Activex
Chart connected to a system DSN on an asp page. For some reason no matter
what I do only DSN entries local to my desktop are available, which of
course is useless. I have gone through the Site Settings and created
connections there to the avilable system DSN and I am able to verify them no
problem. Can someone provide an example of how to place an activex chart
that uses an odbc connection and a SQL query?



Thanks
 
J

Jim Buyens

-----Original Message-----
Just installed FP 2003 and tried to use the wizard to
create an Activex Chart connected to a system DSN on an
asp page. For some reason no matter what I do only DSN
entries local to my desktop are available, which of
course is useless. I have gone through the Site Settings
and created connections there to the avilable system DSN
and I am able to verify them no problem. Can someone
provide an example of how to place an activex chart
that uses an odbc connection and a SQL query?
Click to expand...

Here are some typical values.

For Connenction:

Provider=MSDASQL.1;Persist Security Info=True;Extended
Properties="DSN=MS Access
Database;DBQ=C:\whatever\myaccess.mdb;DefaultDir=C:\whatev
er;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;";Initial
Catalog=C:\whatever\myaccess

and for Data Member, Table, View, Or Cube Name:

`C:\whatever\myaccess`.`mytable`

To create this:

1. On the DataSource tab, select Data From A Database
Table Or Query.
2. On the Data Details tab, click Edit.
3. In the Select Data Source dialog box, click New
Source.
4. In the Data Conenction Wizard, select the type of
data source you want, then click Next and satisfy
the prompts.

I must warn you, though, that the Office Chart control is
part of the Office desktop software, and will only be
available to Web visitors who have Office installed on
their computer.

Also, the Office Chart control retrieves the data while
running on the visitor's PC. This means the visitor must
have direct access to the data, without going through the
Web server.

If this meets your eeds, fine. But if you want the more
usual arrangement where a program on the Web server
retreives the data, draws the chart, and sends it to the
browser as a GIF image, you'll need to find another
solution.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
S

Steve C

I see. This is why I cannot use a system DSN rather than a machine DSN. That
is unfortunate. Well, that ptretty much makes that component useless for
most web applications since more often than not the data is available only
to the webserver and is provided to the client through a webpage. Is this
typical of most chart compenents or just this one? I really need a way to
build a dynamic chart without having to setup individual DSN's on each
clients machine....:(
 
J

Jim Buyens

-----Original Message-----
I see. This is why I cannot use a system DSN rather than
a machine DSN. That is unfortunate. Well, that ptretty
much makes that component useless for most web
applications since more often than not the data is
available only to the webserver and is provided to the
client through a webpage. Is this typical of most chart
components or just this one?
Click to expand...

No, accessing the database from an ActiveX control that
runs inside the broswer is a very unusual technique. But
this comes from the Excel group, and they obviously lean
toward fat client approaches.
I really need a way to build a dynamic chart without
having to setup individual DSN's on each clients
machine....:(
Click to expand...

There are a couple of billion products out there that do
this; you can find them by searching google or yahoo
for "web charting windows". Or, if the chart isn't too
complicatedand you have some programming skills, try this
article:

http://msdn.microsoft.com/msdnmag/issues/02/02/aspdraw/


Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Top