ADO error accessing - Access Database

[Christopher Knapp]

Hello,

I have an Access database that is setup as a System Datasource on a Win2k Server. This Access database is accessed by about 15 workstations using another program already and has a file lock (.lck). I am trying to access the Access database via ASP on the IIS server at the same time but am getting an ADO error (Source: ADO Number: -2146824584 (0x800a0e78)) that it can not make the connection. Is this because the other program has a file lock?

If I copy the access file to another directory I can get the server to connect to it beautifully, but I need to pull live data over to the web server. Any input would be greatly appreciated. Thanks.

--
CHRISTOPHER KNAPP
[email]chris@foarm.com[/email]

[Aaron Bertrand [MVP]]

What is the TEXT (read: the important part) of the error message?

Sorry, I'm working on it, but I haven't memorized all the 0x800... error
codes just yet.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]






"Christopher Knapp" <chris@foarm.com> wrote in message
news:OAAoiawIEHA.2744@TK2MSFTNGP10.phx.gbl...
Hello,

I have an Access database that is setup as a System Datasource on a Win2k
Server. This Access database is accessed by about 15 workstations using
another program already and has a file lock (.lck). I am trying to access
the Access database via ASP on the IIS server at the same time but am
getting an ADO error (Source: ADO Number: -2146824584 (0x800a0e78)) that it
can not make the connection. Is this because the other program has a file
lock?

If I copy the access file to another directory I can get the server to
connect to it beautifully, but I need to pull live data over to the web
server. Any input would be greatly appreciated. Thanks.

--
CHRISTOPHER KNAPP
[email]chris@foarm.com[/email]

[Christopher Knapp]

Hello,

Here is the entire error-


================================================== ========
Title- Database Connection Error

Text- The server encountered an error while procession a database request.
For more information, click Details.

Details- Server error: Unable to retrieve the list of record sources from
a database using the connection string: DSN=shpdb;DRIVER={Microsoft Access
Driver (*.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)
================================================== ==================








--
CHRISTOPHER KNAPP
"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:O0ZUFjwIEHA.3572@TK2MSFTNGP10.phx.gbl...

> What is the TEXT (read: the important part) of the error message?
>
> Sorry, I'm working on it, but I haven't memorized all the 0x800... error
> codes just yet.
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
>
>
>
>
> "Christopher Knapp" <chris@foarm.com> wrote in message
> news:OAAoiawIEHA.2744@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> I have an Access database that is setup as a System Datasource on a Win2k
> Server. This Access database is accessed by about 15 workstations using
> another program already and has a file lock (.lck). I am trying to access
> the Access database via ASP on the IIS server at the same time but am
> getting an ADO error (Source: ADO Number: -2146824584 (0x800a0e78)) that

it

> can not make the connection. Is this because the other program has a file
> lock?
>
> If I copy the access file to another directory I can get the server to
> connect to it beautifully, but I need to pull live data over to the web
> server. Any input would be greatly appreciated. Thanks.
>
> --
> CHRISTOPHER KNAPP
> [email]chris@foarm.com[/email]
>
>
>
>

[Aaron Bertrand [MVP]]

> DSN=shpdb;DRIVER={Microsoft Access Driver (*.mdb)}

Is this your actual connection string? Where did you learn to construct a
connection string this way?

Please see [url]http://www.aspfaq.com/2126[/url] and try your page with a proper and
valid connection string.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Christopher Knapp]

I am using the Database Results Wizard in FrontPage and it is what is giving
that string and error.

If I copy the database to another directory it works perfectly...but I need
live data.

--
CHRISTOPHER KNAPP



"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:O7KH6swIEHA.3440@TK2MSFTNGP09.phx.gbl...

> > DSN=shpdb;DRIVER={Microsoft Access Driver (*.mdb)}

>
> Is this your actual connection string? Where did you learn to construct a
> connection string this way?
>
> Please see [url]http://www.aspfaq.com/2126[/url] and try your page with a proper and
> valid connection string.
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>

[Aaron Bertrand [MVP]]

>> I am using the Database Results Wizard in FrontPage

Have you tried NOT doing that?

[Christopher Knapp]

Hello,

Well...you forced me to give up my crutch and I thank you for that! I just
spent the last hour reading and typing...and now I finally understand how
the connection works and how to pull the data without using the FrontPage
stuff. I have rewritten the connection string and query, and they are now
working. I actually like it this way much better. I feel like I have more
control over what I am doing, rather than being bound to the constraints of
the Results Wizard. Thanks for all the input!

--
CHRISTOPHER KNAPP


"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:%23cvF54wIEHA.2876@TK2MSFTNGP09.phx.gbl...

> >> I am using the Database Results Wizard in FrontPage

>
> Have you tried NOT doing that?
>
>

[Ray at]

I plan on using this as a quotable quote. This is outstanding! It's often
difficult to wean someone off of Frontpage, Dreamweaver, whatever, for
ASP-coding, but when it happens, this is what the result SHOULD be. It
doesn't usually happen, and when it does, certainly not as fast as this.
And it's usually quite some time before the person would begin to see the
light about having more control and what not. Bravo Christopher!

Ray at home

"Christopher Knapp" <chris@foarm.com> wrote in message
news:O2iQfcxIEHA.2844@tk2msftngp13.phx.gbl...

> Well...you forced me to give up my crutch and I thank you for that! I

just

> spent the last hour reading and typing...and now I finally understand how
> the connection works and how to pull the data without using the FrontPage
> stuff. I have rewritten the connection string and query, and they are now
> working. I actually like it this way much better. I feel like I have

more

> control over what I am doing, rather than being bound to the constraints

of

> the Results Wizard. Thanks for all the input!