Front-End of SQL?
Matt Scheperle
decide between VB, HTML, or Access 97. We are limited on money, manpower
and time. Our users will fight using any kinda standards.
How would you suggest we set up our frontends on the workstations that
would be easy to develop for us... and easy for the user to use.??
Please Help.
Email me at msch...@mail.state.mo.us
Thanks for any help you can provide.
Matt Scheperle
Ivan Santhumayor
issues with Jet Engine. It usually downloads the entire curorset onto the
workstation and hence does not funnel only the required rows.
Matt Scheperle
in VB? Or is there a simpler way. Also, does SQL come with any type of tools
to assist with VB/ADO??
Ryan Novak
97. In Access 2000, you can create an Access Data Project, which uses SQL
as a backend instead of Jet. It allows you to access the SQL tables just as
you would a normal Access table. However, I am not entirely sure of the
pros/cons of using VB vs A2K for a FrontEnd, but Access 2000 is better than
A97.
"Matt Scheperle" <msch...@mail.state.mo.us> wrote in message
news:38D6A0B1...@mail.state.mo.us...
Martin Lanza @ Home
If money, manpower and time are big issues
AND you don't the answer to this question,
you're up a creak without a paddle :-(
Access will be the quickest given lack of knowledge
but it's not the best way to do it and can be problematic.
VB over ADO is pretty good, great even.
HTML will only provide simplistic functionality - which may be enough ???
Good luck.
Martin...
Neil
user of Access. There's also the issue of rolling out new versions of the
application. If you have a large number of users, this would be a major
problem, whereas if it is web based, there won't be any rolling out to do.
However, Access and VB will have a richer user interface because web based
applications, because they have to support multiple platforms tend of be
very blend. If you already has Access license for all users, and the user
base is small, Access might be the best answer. For web based application (I
assume you will be using ASP) there will be a lot of coding to be done, so
the time factor must be taken into account.
We are using ASP (web based) for those applications that support a large
user base (300+), and use Access for some applications which has a small
user base (around 10). There is a balance because it is more feasible to do
a web based application for the 300+ users because it would be impossible to
update each user's desktop, but for the smaller user base, we use Access
because it is the fastest way to develope the app. and very convenient
enough to rollout to such a small group.
John Winterbottom
you can distribute your front end's as royalty-free Runtime applications, in
other words, you don't need to buy a licence for each user.
Neil <scu...@catcha.com.sg> wrote in message
news:8b83pa$49b$1...@coco.singnet.com.sg...
Brian King
to SQL and virtually every other application, database, ERP, legacy system
on the market.
No program code, so scripting. The developer simply drags objects onto the
screen and then drags their data onto the object. Drags a connector line
from one object to another and the code is written for you.
You can do anything with this software. We have well over 1100 clients
using it and love it. The reports deploy through your users browsers so no
version updates need to occur on anyone's desktop. You have your choice of
deployment using Java, ActiveX and in about another month, DHTML.
Check out the web site, download a free eval which allows you to connect up
to SQL or MS OLAP, or anything else you have. www.arcplan.com
Feel free to call if you have any questions.
Regards,
Brian
925 825-6125
Johan van Zyl
http://www.topspeed.com
http://www.jvz.co.za/mssql
http://www.capesoft.com
http://www.clarionmag.com
and many more!
Regards
Johan van Zyl - Somerset West South Africa
jo...@jvz.co.za
Clarion 5ee, FM2, SecWin
Pastel Accounting
Customised Software
Ryan Novak
DOS-based back then...ahhh, the good old days LOL (a half sarcastic laugh)
"Johan van Zyl" <jo...@jvz.co.za> wrote in message
news:38e39716...@news.intekom.com...
Johan van Zyl
And it is now in version 5.5 Enterprise Edition, is now web enabled
Windows Industrial Strenght RAD tool.
I have used VB and Delphi and if I can help it will neve touch them
again. There is NOTHING faster than Clarion.
For Business or any other database orientated programs this is the
tool of choice.
Take a look at the websites below.
Have a glorious day!
Johan van Zyl
Tom Loach
Excuse me for being a skeptic, but I took a look at the web site
and I'm alway leary when the advertisment tells me "no need to
program". It ususally means significant limitations on what you can
do. That said, I'm always on the look out for a package that our
programming staff can use to meet the users needs. Our group mainly
does departmental projects in either Access or VB. You mention in
you note that the package is inexpensive, but I couldn't find any
information on cost on the web site. Perhaps you could give me an
idea of the cost and what the limitations of the package are.
Thanks,
Tom
Brian King
Not a problem I use to work as a client providing solutions directly to the
CIO and CFO of a very large fortune 500 corporation myself, so I completely
understand where you are coming from.
My statement is truthful and right on the money. dynaSight was designed so
the developer (if you want to call them that with a tool like this) writes
absolutely no code, no Java script, no ActiveX, no HTML or DHTML, nothing,
nada, zilch.
All the code is scripted for you transparently. Very slick solution. When
the dimension, member, characteristic, value, whatever the lingo of the
backend, is dragged onto the objects you decide to use, there is a SQL or
MDX statement written and held by that object. Again, this is transparent
to the user and developer alike. But... if the developer wishes to see the
code, they can flip it to see what is going on with the various calls to the
backend, or how the query statement is being modified as you go.
I myself am not a programmer nor with to be. I self taught myself what I
know with this software while I was a client evaluating it for an SAP R/3
implementation. In two weeks with no training, I was building reports
allowing drilldown, charting, presenting KPIs, spotlighting, it was so cool
all I wanted to do was build reports anymore. And I absolutely hated
writing reports before.
Limitations....Hmmmmm that is a hard one to answer. I have found that we
can come up with a solution in most every business case laid on the table.
Once in a blue moon is their a specific functionality we are asked to do
that we simply cannot. Usually it is not around functionality, but purely
that the client wants to view something in an exact way that they will not
budge on and its a lame request to begin with.
If you want to fire off a list of specifics, I will be honest and say yes or
no to them. As an FYI - we pull and present data from SQL, MS OLAP, SAP R/3
and BW, Oracle Express and RDBMS, Applix TM1, Informix MetaCube, Sybase
Warehouse Studio, Hyperion Essbase and Enterprise, and any ODBC source.
You can do Dashboards, Write Back, Spotlighting, Nest Hierarchies, present
data from multiple back ends on the same report and even build calcs and
chart this non-relational data. It is really hard to list it all Tom.
For what you can do with this, pricing is very inexpensive compared to using
many other apps. ~ 21K will get you the development tools, the server
component to deploy the solutions over the web, and 20 seats. ~350 for each
seat there after, but breaks are offered depending on the size of your
implementation.
Hope this helps, sorry for the novel.
Brian
"Tom Loach" <tc...@virginia.edu> wrote in message
news:38e4adf9...@murdoch.acc.virginia.edu...
Thomas Dauria
Matt Scheperle <msch...@mail.state.mo.us> wrote:
: What kind of programming would be required? Would we be doing a lot of coding
: in VB? Or is there a simpler way. Also, does SQL come with any type of tools
: to assist with VB/ADO??
: Ivan Santhumayor wrote:
:> VB with ADO is a great front-end tool to SQLServer. Access97 has too many
:> issues with Jet Engine. It usually downloads the entire curorset onto the
:> workstation and hence does not funnel only the required rows.
:>
:> Matt Scheperle wrote:
:>
:> > What is the best front-end to use with SQL Server? We are trying to
Thomas Dauria
Brian King <brian...@arcplan.com> wrote:
: I would suggest you evaluate dynaSight. It is a very inexpensive front end
: to SQL and virtually every other application, database, ERP, legacy system
: on the market.
: No program code, so scripting. The developer simply drags objects onto the
: screen and then drags their data onto the object. Drags a connector line
: from one object to another and the code is written for you.
: You can do anything with this software. We have well over 1100 clients
: using it and love it. The reports deploy through your users browsers so no
: version updates need to occur on anyone's desktop. You have your choice of
: deployment using Java, ActiveX and in about another month, DHTML.
: Check out the web site, download a free eval which allows you to connect up
: to SQL or MS OLAP, or anything else you have. www.arcplan.com
: Feel free to call if you have any questions.
: Regards,
: Brian
: 925 825-6125
: "Matt Scheperle" <msch...@mail.state.mo.us> wrote in message
: news:38D6A0B1...@mail.state.mo.us...
:>
Brian King
Thats ok, some have and some have not. The 1200 companies that own it, use
it for everything.
We are the ONLY reporting front-end chosen to be put in the MS Windows 2000
Professional Unleashed. This is the largest publication of all the MS
books. MS sought us out and asked us if we were interested in printing our
solutions in their book. We also have our eval software on the included CD.
Gartner Group has arcplan as one of the leading visionary companies. We are
right up there with Microsoft, Hyperion, and SAP.
Brian
"Thomas Dauria" <tda...@bu.edu> wrote in message
news:8c3odh$d8g$2...@news3.bu.edu...
Steven Louis Boscarine
uses Cold Fusion. It is worth the high license price.
Steven
cold fusion developer
"Thomas Dauria" <tda...@bu.edu> wrote in message
news:8c3o7o$d8g$1...@news3.bu.edu...
> If you are a beginner then use Access it's by far the easiest.
>
> Matt Scheperle <msch...@mail.state.mo.us> wrote:
> : What kind of programming would be required? Would we be doing a lot of
coding
> : in VB? Or is there a simpler way. Also, does SQL come with any type of
tools
> : to assist with VB/ADO??
>
> : Ivan Santhumayor wrote:
>
> :> VB with ADO is a great front-end tool to SQLServer. Access97 has too
many
> :> issues with Jet Engine. It usually downloads the entire curorset onto
the
> :> workstation and hence does not funnel only the required rows.
> :>
> :> Matt Scheperle wrote:
> :>
Paul Ilacqua
systems in a high capacity automotive plant. We build 3 - 4 million units a
year. The key is to use ODBC direct recordsets in Access. They are
lightening fast and easy to create. Its actually faster to create an ODBC
Direct workspace and fill a local table, than it is to create a Jet based or
straight ODBC workspace. I do not have on attached table in my front end.
Simply put I am very impressed with Access 97 to SQL Server, and I'll defend
it to the end.
Paul Ilacqua pila...@twcny.rr.com
"Matt Scheperle" <msch...@mail.state.mo.us> wrote in message
news:38D6A0B1...@mail.state.mo.us...