Still getting an error trying to connect to Access DB on web

[James Houston]

I posted this message several days ago and someone suggested that the error
was because someone else had the db open exclusively. That's not the case
here, since I'm the only one currently using this db. I'm hoping someone
might have some other ideas about what might be going on.

I'm trying to connect to an Access DB on my web site. I used FrontPage
2000's Database Results wizard, but the page it built just doesn't have the
features I need, so I've started setting up a page by hand. I snagged the
connection string out of the global.asa file and pasted it into my ASP code
like so:

dim sCon 'ado connection string
dim adoConn 'ado connection
set adoConn = server.createobject("adodb.connection")
sCon = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=CurrentShipped.mdb"
adoconn.open sCon

Which generates the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x958 Thread 0xcf0
DBC 0x24cfafd4 Jet'.
/test.asp, line 95
Anybody know what I'm doing wrong and how to fix it? Any help would be
greatly appriciated.

Best,
JIm

 

[Kevin Spencer]

If you had the database opened in Access, YOU (or more accurately, the
Access application) were the "someone else."

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[James Houston]

I still don't think that's the problem. What I'm doing is updating the
database on my local machine, then transfering it to the web server via ftp.
Its the copy on the web server that I'm trying to read from, and all I want
to do at this point is just read from it. Any updates or other changes are
made on my local PC before I upload it to the web.

I suppose there could be some process on the web server that I'm unaware of
that's marked the db as open, but that seems unlikely. As far as I know, the
only time anyone has tried to open this database is when I try to load the
asp page that uses it. I did set up another page, using FP's database
results wizard, that uses this db, but again, I'm the only person in my
company who even knows it exists at this point, and I always close it before
I try to run the other page.

Again, any help would be greatly appriciated.

Best

Jim

If you had the database opened in Access, YOU (or more accurately, the
Access application) were the "someone else."

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

I posted this message several days ago and someone suggested that the error
was because someone else had the db open exclusively. That's not the case
here, since I'm the only one currently using this db. I'm hoping someone
might have some other ideas about what might be going on.

I'm trying to connect to an Access DB on my web site. I used FrontPage
2000's Database Results wizard, but the page it built just doesn't have the
features I need, so I've started setting up a page by hand. I snagged the
connection string out of the global.asa file and pasted it into my ASP code
like so:

dim sCon 'ado connection string
dim adoConn 'ado connection
set adoConn = server.createobject("adodb.connection")
sCon = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=CurrentShipped.mdb"
adoconn.open sCon

Which generates the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x958 Thread 0xcf0
DBC 0x24cfafd4 Jet'.
/test.asp, line 95
Anybody know what I'm doing wrong and how to fix it? Any help would be
greatly appriciated.

Best,
JIm

 

[Kevin Spencer]

Do you see an .ldb file on the server? If so, try deleting it.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

I still don't think that's the problem. What I'm doing is updating the
database on my local machine, then transfering it to the web server via ftp.
Its the copy on the web server that I'm trying to read from, and all I want
to do at this point is just read from it. Any updates or other changes are
made on my local PC before I upload it to the web.

I suppose there could be some process on the web server that I'm unaware of
that's marked the db as open, but that seems unlikely. As far as I know, the
only time anyone has tried to open this database is when I try to load the
asp page that uses it. I did set up another page, using FP's database
results wizard, that uses this db, but again, I'm the only person in my
company who even knows it exists at this point, and I always close it before
I try to run the other page.

Again, any help would be greatly appriciated.

Best

Jim

If you had the database opened in Access, YOU (or more accurately, the
Access application) were the "someone else."

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

I posted this message several days ago and someone suggested that the error
was because someone else had the db open exclusively. That's not the case
here, since I'm the only one currently using this db. I'm hoping someone
might have some other ideas about what might be going on.

I'm trying to connect to an Access DB on my web site. I used FrontPage
2000's Database Results wizard, but the page it built just doesn't

have
the

features I need, so I've started setting up a page by hand. I snagged the
connection string out of the global.asa file and pasted it into my ASP code
like so:

dim sCon 'ado connection string
dim adoConn 'ado connection
set adoConn = server.createobject("adodb.connection")
sCon = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=CurrentShipped.mdb"
adoconn.open sCon

Which generates the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x958 Thread 0xcf0
DBC 0x24cfafd4 Jet'.
/test.asp, line 95
Anybody know what I'm doing wrong and how to fix it? Any help would be
greatly appriciated.

Best,
JIm

 

[chris martin]

I used to get those errors every once in a while. Did
you try using an absolute path to the database?

Something like:

Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=" &
("E:\accounts\username\members\login\site.mdb") & ";"

 

[Vijay R Gangolli [MSFT]]

Hi,

The anonymous user account might not have permissions on the TEMP folder.
Check http://support.microsoft.com/?id=315456 for resolution.

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| From: "Kevin Spencer" <[email protected]>
| References: <[email protected]>
<[email protected]>
<[email protected]>
| Subject: Re: Still getting an error trying to connect to Access DB on web
| Date: Thu, 4 Mar 2004 14:34:09 -0500
| Lines: 99
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.frontpage.programming
| NNTP-Posting-Host: dynamicsystems.com 216.54.1.213
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.frontpage.programming:30198
| X-Tomcat-NG: microsoft.public.frontpage.programming
|
| Do you see an .ldb file on the server? If so, try deleting it.
|
| --
| HTH,
| Kevin Spencer
| .Net Developer
| Microsoft MVP
| Big things are made up
| of lots of little things.
|
| | > I still don't think that's the problem. What I'm doing is updating the
| > database on my local machine, then transfering it to the web server via
| ftp.
| > Its the copy on the web server that I'm trying to read from, and all I
| want
| > to do at this point is just read from it. Any updates or other changes
are
| > made on my local PC before I upload it to the web.
| >
| > I suppose there could be some process on the web server that I'm unaware
| of
| > that's marked the db as open, but that seems unlikely. As far as I know,
| the
| > only time anyone has tried to open this database is when I try to load
the
| > asp page that uses it. I did set up another page, using FP's database
| > results wizard, that uses this db, but again, I'm the only person in my
| > company who even knows it exists at this point, and I always close it
| before
| > I try to run the other page.
| >
| > Again, any help would be greatly appriciated.
| >
| > Best
| >
| > Jim
| >
| > | > > If you had the database opened in Access, YOU (or more accurately, the
| > > Access application) were the "someone else."
| > >
| > > --
| > > HTH,
| > > Kevin Spencer
| > > .Net Developer
| > > Microsoft MVP
| > > Big things are made up
| > > of lots of little things.
| > >
| > > | > > > I posted this message several days ago and someone suggested that
the
| > > error
| > > > was because someone else had the db open exclusively. That's not
the
| > case
| > > > here, since I'm the only one currently using this db. I'm hoping
| > someone
| > > > might have some other ideas about what might be going on.
| > > >
| > > > I'm trying to connect to an Access DB on my web site. I used
| FrontPage
| > > > 2000's Database Results wizard, but the page it built just doesn't
| have
| > > the
| > > > features I need, so I've started setting up a page by hand. I
snagged
| > the
| > > > connection string out of the global.asa file and pasted it into my
ASP
| > > code
| > > > like so:
| > > >
| > > > dim sCon 'ado connection string
| > > > dim adoConn 'ado connection
| > > > set adoConn = server.createobject("adodb.connection")
| > > > sCon = "DRIVER={Microsoft Access Driver
| > > (*.mdb)};DBQ=URL=CurrentShipped.mdb"
| > > > adoconn.open sCon
| > > >
| > > > Which generates the following error message:
| > > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
| > > > [Microsoft][ODBC Microsoft Access Driver]General error Unable to
open
| > > > registry key 'Temporary (volatile) Jet DSN for process 0x958 Thread
| > 0xcf0
| > > > DBC 0x24cfafd4 Jet'.
| > > > /test.asp, line 95
| > > > Anybody know what I'm doing wrong and how to fix it? Any help would
| be
| > > > greatly appriciated.
| > > >
| > > > Best,
| > > > JIm
| > > >
| > > >
| > >
| > >
| >
| >
|
|
|