Re: Database connection error (re-post)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Thoughtcat (richard_at_thoughtcat.com)
Date: 07/17/04 

Date: 17 Jul 2004 12:54:42 -0700

Hi Kathleen,

Many thanks for your reply and suggestions. My web server does have
the FP extensions loaded. The issue, it seems, is with the database
server they use. I contacted my web host again to convey your last
piece of advice and asked them if this meant that I could not
therefore design and host an Access/FP website with them. They
replied, "You can have your website designed with frontpage [if you
use] MySQL as database running on our server which is very easy to
access and is used by almost all hosting providers avaliable today,
instead of using Frontpage 2003 with Access 2003 database." This seems
to mean therefore that my choice is either to change my web host to
one that supports Windows Sharepoint Services, or keep the host and
buy MySQL for about £145. I suppose from a Microsoft point of view you
would advise me to change the web host, especially as I am familiar
with Access and not with MySQL. This would be an inconvenience but it
would save me £145. If however I did keep the host and start using
MySQL, is there anything special I will need to do to configure
Frontpage to take the data from the MySQL database?

Sorry if I'm being dense, but I have little experience of this matter.
Thanks for any further advice you can give.

Regards
Richard

"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in message news:<#dxX6IEaEHA.2016@TK2MSFTNGP09.phx.gbl>...
> Richard:
> To use Data Views, your site must be running Windows SharePoint Services on
> Windows Server 2003. To use the Database Results Wizard, your site must be
> on a Windows Server that supports ASP and Access and preferably the
> FrontPage 2000 or 2002 server extensions. It is possible to use the wizard
> without the server extensions, but you don't really want to go there. If you
> are going to develop live on the hosting server, you will need the server
> extensions to do that. See this page for more specifics: FrontPage Server
> Configuration Options and Features
> http://www.microsoft.com/office/frontpage/prodinfo/servers.mspx
>
> I recommend VIA USA http://www.vianetworks.net/index.aspx
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft FrontPage MVP
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Thoughtcat <richard@thoughtcat.com> wrote:
> > Hi Kathleen,
> >
> > Thank you very much for your response. I contacted my web hosting
> > company and they responded as follows:
> >
> > "Currently, all of our Web servers are running RedHat. We support only
> > apache ASP. This is not full windows ASP. We support MySQL database
> > which is very easy and for more information about that you can visit
> > the following URL :
> > http://www.mysql.com"
> >
> > Does this mean I can't use this hosting company at all for the
> > purposes I outlined, or is there a way round this? If I need a new
> > firm altogether, can you recommend one or let me know the best way to
> > find one?
> >
> > Many thanks again,
> > Richard
> >
> >
> > "Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in
> > message news:<Onc06HtZEHA.264@TK2MSFTNGP10.phx.gbl>...
> >> Dear Frustrated:
> >> To use Data Views, your site must be hosted on a Windows 2003 Server
> >> using
> >> Windows SharePoint Services:
> >>
> http://office.microsoft.com/assistance/preview.aspx?AssetID=HP010489401033&CTT=1&Origin=EC790000701033&QueryID=tEj53y3YP0&Query=data+view&Scope=TC%2cHP%2cHA%2cRC%2cFX%2cES%2cEP%2cDC%2cXT
> >> If you are doing this on your live site, you need to find out more
> >> about the
> >> web server your site is on and what their 'rules' are for database
> >> connections.
> >>
> >> --
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> Thoughtcat <richard@thoughtcat.com> wrote:
> >>> Trying, trying again...
> >>>
> >>> Hi. I'm running Office 2003 on Windows XP Pro. I have designed a
> >>> database in Access 2003 and want to design a website using FP2003
> >>> where users
> >>> can retrieve selected information through the page from that
> >>> database.
> >>> I have tried several times to set up a database connection on FP but
> >>> have had no luck. When trying insert/database/data view or
> >>> data/insert
> >>> data view, I get this message: "The FP Data View features can only
> >>> be
> >>> used on servers running Windows SharePoint Services. If you do not
> >>> have a Web site hosting service, find one that supports FP or WSS by
> >>> using the Web Presence Provider." However, I do have a web site
> >>> hosting service that supports FP.
> >>>
> >>> Next, when I try insert/database/results and go through the ensuing
> >>> wizard, I always get the following error message, even when using
> >>> the
> >>> built-in sample "Northwind" database:
> >>>
> >>> Database connection error
> >>>
> >>> Server error: Unable to retrieve the list of record sources from a
> >>> database using the connection string:
> >>>
> >>> DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb.
> >>>
> >>> The following error message comes from the database driver software;
> >>> it may appear in a different language depending on how the driver is
> >>> configured.
> >>> -------------------------------------------------------
> >>>
> >>> Source: ADO
> >>> Number: -2146824584 (0x800a0e78)
> >>>
> >>>
> >>> I have tried detect & repair but there's no change. As I say, my web
> >>> host supports FP extensions so that can't be at fault. I had this
> >>> problem with FP2002 as well, and switched to Office 2003 partly to
> >>> try
> >>> and resolve this. Any ideas?
> >>>
> >>> Many thanks,
> >>> Frustrated of London

Relevant Pages

  • Re: hitting the limits
    ... relatively straight forward MySql database. ... 10K visitors a month and an 80Mb database are nothing. ... heavily loaded server. ... But the connection will hang around until the garbage ...
    (comp.lang.php)
  • Re: Database connection error (re-post)
    ... MySQL is a database server, it is not a desktop database like Access, you have to work with directly ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Re: Confusion about database updates
    ... all connecting to the same database server. ... MySQL can easily handle many simultaneous clients. ... AlphaCluster all open multiple connections to a MySQL server running on ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: Using MySQL as the backend
    ... I need to learn MySQL, ... > the impression you're not familiar with the concept of a server DB. ... > doesn't need to have Access installed to access the database, ... >> install the server or maybe I have it installed but I just don't know how to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: MySQL Insert Unicode Problem
    ... I'm trying to insert some data from an XML file into MySQL. ... The database server has to support Unicode, ...
    (comp.lang.python)