ASP/Access error

[Carroll]

I have been receiving this message today:
Microsoft OLE DB Provider for ODBC Drivers
error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Unknown

/setup/test/chordslyricsdetail.asp, line 18

I have not had any problems on my local machine until I
noticed yesterday that I could not run ASP/Access. If I
copy the work to the server I have no problems at all
running the exact same files that gave me the above error
on my local set up machine... any help would be great.

Note: I have re-installed the MDAC and the latest
greatest Access Jet downloads.

Regards,

Carroll

 

[ThunderMusic]

in your connection string, do you have "Mode=Share Deny None" ? maybe adding
it could help (it helped me with the same problem).

I hope it helps

ThunderMusic

 

[Carroll]

Where would I place this: Mode=Share Deny None ?
I tried it in the

<%'set up dsnless connection
mydsn="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath(".") & "\db\chordslyrics.mdb "

But I got a new error I had never seen... Catastrophic
Error... new one for me.

Regards,

Carroll

 

[ThunderMusic]

first of all using the access driver directly in a ASP page is not
recommended. You should use the jet oledb:
ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("./db/chordslyrics.mdb ") & ";MODE=SHARE DENY NONE" (the caps
are only to be coherant with the rest of the connection string.)

I hope it helps

ThunderMusic

 

[ThunderMusic]

for reference, you can go to http://www.tsn.cc/faq/access.txt

 

[Carroll]

I've tried as you suggested with your string and with my
connection and still the same error... except now it does
not mention: [Microsoft][ODBC Microsoft Access Driver] now
it just says: Unknown

Like this:

Microsoft JET Database Engine error '80040e14'
Unknown

/setup/test/chordslyricsdetail.asp, line 18


Here's what I put:

<%'set up dsnless connection

mydsn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("./db/chordslyrics.mdb ") & ";MODE=SHARE

DENY NONE"

The funny thing is this code runs fine on my Live server,
it's my local setup machine that won't run the connection
to the database or almost not. Here's exactly what's
happening:

I Open a connection to the Chords & Lyrics ASP page and it
gives me a the full index of the Bands that are in the
database like it should, but when I click on any link to
see all of one bands Chords & Lyrics that is listed under
that field this is when that error comes up.

Didn't hurt to try it though.

Regards,

Carroll

 

[ThunderMusic]

oh... the problem is different then... can you tell me what is the query
you're using? (because it could be the problem).

 

[ThunderMusic]

and by the way, are you sure you always close your connections? because it
could be the problem. If you don't close them, they stay open for a while
(if not forever) and it could cause this problem.

 

[Guest]

0x80004005 is the error message that I'm getting after i followed the advices below.
I use tomcat with the same database and all runs fine...


I have been receiving this message today
Microsoft OLE DB Provider for ODBC Drivers
error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Unknown

/setup/test/chordslyricsdetail.asp, line 18

I have not had any problems on my local machine until I
noticed yesterday that I could not run ASP/Access. If I
copy the work to the server I have no problems at all
running the exact same files that gave me the above error
on my local set up machine... any help would be great

Note: I have re-installed the MDAC and the latest
greatest Access Jet downloads

Regards

Carrol

 

[Carroll]

I was also running Tomcat, just finished a format and I
guess I won't be installing my Laser printer on my work
machine. Everything is back to normal. Blasted Tomcat
corrupted my IIS somehow.