Re: Database problems!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: rifraf (rifraf_at_discussions.microsoft.com)
Date: 03/10/05 

Date: Thu, 10 Mar 2005 09:41:07 -0800

Something new...

I was trying to create a new database while on the live server... and I
received this message after Inserting Database Results, and choosing database
"fpdb/test.mdb":

**************

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/test.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'm not sure how I am connecting - everything else works fine... if I
publish any changes through FP2002, they do show up when browsing online. I
did not manually create the connection string... I simply use the Wizard in
FP..

"Mark Fitzpatrick" wrote:

> Also, make sure that the database has the correct permissions. It could be
> that the server is no longer giving the IUSR account permissions to these
> databases. Also, how are you connecting? Through a DSN? If so then make sure
> someone hasn't changed the DSN on the server. If you can supply more details
> of the connection method, or even the connectionstring used to connect to
> the db (without any usernames and passwords when posted here) that could
> help give us a hint.
>
> Hope this helps,
> Mark Fitzpatrick
> Microsoft MVP - FrontPage
>
> "rifraf" <rifraf@discussions.microsoft.com> wrote in message
> news:7B08ABC5-4CF4-43B4-BB67-614A0F5283A5@microsoft.com...
> >I have verified the database... I've even se up a brand new database just
> >the
> > test it.. It seems to go flawlessly on my computer in Frontpage... but
> > once I
> > publish it.. I get the error. I have already contracted the hosting
> > company -
> > they tell me to contact Microsoft. (!) They're no help.
> >
> > "Teri Carnright" wrote:
> >
> >> I saw your initial post - what you've given isn't enough to tell me
> >> anything
> >> except you have serious problems. I'm assuming you have verified the
> >> database(s)?? Sometimes, you have to completely remove the existing
> >> connection, then add it as a new connection and verify.
> >>
> >> If that doesn't do it, contact your hosting service immediately - they
> >> can
> >> likely see what's up by reviewing their error logs.
> >>
> >> Teri
> >> :)
> >>
> >>
> >> "rifraf" wrote:
> >>
> >> > Help!... I've had my site up and running for a few weeks - both
> >> > databases
> >> > were working fine. I was away for 3 days, and when i returned, both
> >> > databases
> >> > have mysteriously stopped working. I don't beleive I had made any
> >> > changes to
> >> > the web to incur this. Here is the message I get:
> >> >
> >> > Database Results Error
> >> > The operation failed. If this continues, please contact your server
> >> > administrator.
> >> >
> >> > I've set up a brand new database from scratch (using the database
> >> > wizard) to
> >> > rectify the situation, but I still get the same message. The other
> >> > database I
> >> > am using is a simple login/password using .asp (article 321439) - it
> >> > too does
> >> > not work. I am using FP2002 - and a relative rookie in website design.
>
>
>

Relevant Pages

  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: MySQL on Win 98
    ... Hitting the Verify Connection button in VFP produced a C5 crash. ... With a "System" DSN configured the same way (except for the Data ... Incorrect database name". ...
    (microsoft.public.fox.programmer.exchange)