Search results matching tag 'Microsoft Access'

Got problem with MS Access, please help.

Chonanis — Mon, 16 Mar 2009 09:43:53 GMT

I'm running IIS7 on Window Server 2008. There are about 100 domains in my server. Most domains work fine, but there usually has problem with domains which are using MS Access with asp. Those domains work fine for some time, then these error occur:

"Microsoft JET Database Engine error '80004005'" or "Active Server Pages error 'ASP 0113' Script timed out"

I used to try restarting IIS, it doesn't help. What I have to do is rebooting my server, then everything will get back to work as normal. This problem happen about once to twice times a week. While the problem happens, other domains which are not using MS Access work fine.

I don't think that it is because of the coding, because it happens to every domains which are using MS Access. What can be the cause? And how prevent it to happen again? Please suggest.

Access DB connection Error

ShotoCon — Tue, 17 Jun 2008 22:30:01 GMT

I developed a piece of software on my old machine using IIS on Server 2003 (Virtual PC Platform) and have moved it to my new machine to play with. Unfortunately, MSVPC not installable on Vista so using IIS 7. Although I am able to display ASP pages, I am not able to process any information from the access databaes Im using in the back end.

Original message being returned was along these lines:

Problem occured whilst processing URL. Please contact System administrator

Followed advice in other threads on this forum and turned off friendly error messages, this was then returned:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

/quizCreate.asp, line 40

The code line it is refering to is of course the db connection opening, so here is the code and all lines before pertaining to it:

            accessDb = "eBug.mdb"

            myDSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
            myDSN = myDSN & "DBQ=" & server.mappath(accessDb)

            Set dbConnection = Server.CreateObject("ADODB.Connection")
            dbConnection.Open myDSN - this is line 40

Figured that it was because I was using an Access 2003 database and only have Office (including Access) 2007 on this machine. (is this assumption correct???)

Downloaded & installed the Access Database Connection stuff from the microsoft website, saved the original db as an Access 2007 DB and changed the connection settings to this:

            accessDb = "eBug.acccdb"

            myDSN ="Provider = Microsoft.ACE.OLEDB.12.0;"
            myDSN = myDSN & "Data Source = " & Server.mappath(accessDb)

            Set dbConnection = Server.CreateObject("ADODB.Connection")
            dbConnection.Open myDSN

New error message now:

Microsoft Office Access Database Engine error '80004005'

Unspecified error

/destroyDB.asp, line 31

Dont worry that its in a different file, all my files were using the same connection settings to the same database, I am only using this one as an example as it is the one open at this time.

Every user on the machine has full control to this folder, have even run the grant user access command prompts posted in other threads.

Still have no idea why I cannot access information in the database. If you need any more information please let me know and ill happily post it, really hope someone can help me out with this.

BTW - was I correct in having to upgrade the DB to Access 2007 one, would be really really handy if i didnt have to and could still use 2003 (even if i dont have office 2003 installed) as a lot of my old projects that use access as their DB are configured to access a 2003 DB using the first method shown here.

Cheers

Vista, IIS7, MS Access 2007 DB, Error - Microsoft JET Database Engine error 080004005

bgoat1 — Thu, 01 May 2008 22:02:38 GMT

I've looked at all the posts I can find on this problem and tried all of the fixes but I'm still having a problem. The error I'm getting is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0xd40 Thread 0x17e4 DBC 0xd19004 Jet'.

/orderforms/OrderFilters.asp, line 9

Here is my connection string

Dim MM_Filters_STRING
MM_Filters_STRING = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\inetpub\wwwroot\db\AirManageFilters.accdb"
%>

Since I'm using a MS Access 2007 database it looks like I need to use the ODBC driver. When I sent up the recordset I can run a test and get all the data. It just doesn't allow me to display the asp page.

I will be forever greatful for any and all help!

Bgoat1

Error when when checking db connection with Classic ASP, Access and IIS7

AngelOfTheNight — Tue, 25 Mar 2008 23:28:04 GMT

I have a site that I moved from a Windows 2003 Server to a Server 2008. This site uses a CMS portal system. In the config routine it verifies the db connection and will only load if there are no errors. I am getting the error:

"-2147217887 : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

I have already tried the solutions provided here: http://forums.iis.net/t/1091950.aspx. As well as everything else I have found searching these forums, MS support, and elsewhere.

Now for the part that has really given me trouble trying to solve the problem. I have created two pages to isolate the issue, one with the error check and one without.

------------------------------------------------------------------------

<html>
<head>
<title>Test</title>
</head>
<body>

<%
Dim strDBPath, strConnString, my_Conn, rs

strDBPath = Server.MapPath("******/******.mdb")
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath

on error Resume Next
Set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Errors.Clear
my_Conn.Open strConnString

If my_conn.Errors.Count <> 0 Then
 For counter = 0 To my_conn.Errors.Count -1
 ConnErrorNumber = my_conn.Errors(counter).Number
 ConnErrorDesc = my_conn.Errors(counter).Description
 If ConnErrorNumber <> 0 Then
 strtemp = "" & ConnErrorNumber & " : " & ConnErrorDesc & ""
 End If
 Next
 my_conn.Errors.Clear

Set my_Conn = Nothing
 on error goto 0
 Response.Write strtemp
End If
%>
</body>
</html>

------------------------------------------------------------------------

<html>
<head>
<title>Test</title>
</head>
<body>

<%
Dim strDBPath, strConnString, my_Conn, rs

strDBPath = Server.MapPath("******/******.mdb")
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath

set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString

Set rs = my_Conn.Execute ("SELECT * FROM PORTAL_MEMBERS WHERE MEMBER_ID=1;")
OrigName = rs.fields("m_username")
response.write "Original Username = " & OrigName & ""

Set rs = my_Conn.Execute ("UPDATE PORTAL_MEMBERS SET m_username='BadName' WHERE MEMBER_ID=1;")
Set rs = my_Conn.Execute ("SELECT * FROM PORTAL_MEMBERS WHERE MEMBER_ID=1;")
response.write "New Username = " & rs.fields("m_username")& ""

Set rs = my_Conn.Execute ("UPDATE PORTAL_MEMBERS SET m_username='" & OrigName & "' WHERE MEMBER_ID=1;")
Set rs = my_Conn.Execute ("SELECT * FROM PORTAL_MEMBERS WHERE MEMBER_ID=1;")
response.write "Reset Username = " & rs.fields("m_username")& ""

set my_Conn = nothing

%>
</body>
</html>

------------------------------------------------------------------------

The first page gives the error, the second page runs with no trouble. Obviously I can connect to the db, and have permissions to make changes, but then why do I get the error in the other routine. I have tried to remove the error check from the CMS portal, but then it fails elsewhere. I feel that if I can get this issue resolved, the rest of the portal should probably work as well.

Displaying an image stored in an access database via asp

Crazy Dino — Wed, 13 Feb 2008 19:34:43 GMT

Hi, I have just created a database and plan to store images in it using an 'ole object' data type. I can store images in it but it is then accessing using asp I can't seem to get working. I can do normal queries to display text and numbers from the database, and have included one, but how/what would I need to change to display an image from the field image. How would I get it to display a specific image from a session variable.

The query I have copied and pasted here is for one to list the name of all the images, so everything is how I would have it connected to the database.

Any help would be really helpful.

Thank You
Crazy Dino

<%
Dim adoCon 'Database Connection Variable
Dim strCon 'Holds the Database driver and the path and name of the database
Dim strAccessDB 'Holds the Access Database Name
Dim strSQL 'Database query sring

strAccessDB = "datastore"
Set adoCon = Server.CreateObject("ADODB.Connection")
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=; DBQ=" & Server.MapPath(strAccessDB)
adoCon.Open strCon

'Database Query"

set rsimage=Server.CreateObject("ADODB.recordset")
sql="SELECT imagename FROM images"
sql=sql
rsimage.Open sql, adoCon
'response.write(sql)

Do While Not rsimage.eof
response.write(rsimage("imagename"))
response.write("")
rsimage.movenext
loop
%>

Error '80040e14' within INSERT INTO Statement

Crazy Dino — Fri, 23 Nov 2007 20:17:38 GMT

Hi, I am extremely new with .ASP (I started on tuesday this week), and am using Dreamweaver 8 to construct .ASP code for a project at school. I already have several bits of working .ASP code such as a login page, which restricts banned users, and validation within a registration page to ensure that login name and e-mail address are unique. My big problem is with the registration page, when I click the Register button i am getting this error returned.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/register.asp, line 167

I have checked within dreamweaver, and on line 167, it displays the following bit of code

MM_editCmd.Execute

which I don't think is the problem having a look at results on google for error '80040e14'

Any help would be greatly appreciated, and if needs be I can post all .asp code Dreamweaver generated for me for an insert query.

VISTA Business IIS7 just will not work

dennis_halsey — Fri, 27 Jul 2007 14:16:48 GMT

Ok, now listen guys:

I am the one who started this thread and after 2 weeks ther had been no good simple solution to my problem. why is that? Maybe some of you guys are just geniuses or maybe this problem has no simple solution! I dshould not have to be a genius. this should jsut work. I'm gonna thow my pc and vista in the dumpster! I'm done with it all!

Do you all understand that this should never, ever be this complicated or technical! It should just work period.

I should never have to go into the registry error tracing and so forth and so on and do all this technical stuff just to get II7 to work. Surley bill gates didn't think that joe schmoe could figure all of this out, when i'm an it guy and can't.

When i find out the simple answer that works and always works, then i will be satisfied. I have had my new vista pc for 3 months and i am yet to develop a classic ASP webiste on it becuase it doesn't run.

This is freakin redicolous.

The one guy that said in an earlier post that he had the solution ofr me to impress my boss,, well

It was so technical, application pools, what the heck is that? why do i need to know about it

I just want to see this show up: "Hello world! this is an ASP page" when i broswe my localhost server.

I think maybe i will look for a third party free solution to this.

Surly there are other ASP webservers that will work with vista better than this.

It's obvious that most people in this thread are confused, frustrated, upset and P'OD!!!!

I am still looking for a simple answer, like go here and click such and such and II7 will work!

If i do not get an awser, here I am going to ditch the thing.

Who runs this forum anyway and why don' they have a simple solution? It's probably becuase they do not know either or beucase there is no simple solution. II7 should have worked when i booted up my PC for the first time! in iis6

can i go back to iis6 in Vista?

By the way, I forwared this message to both dell (which i have access to microsoft tech support) and microsoft directly, but they can't seem to get it to work either. Thant's interesting! That means it doesn't work easily!

Thanks for your help!

I'm done now!

Is there a simple way to make iis7 work in Vista, because it just doesn't work! Has anyone ever made it work? Why can't I?

dennis_halsey — Tue, 24 Jul 2007 19:59:59 GMT

I get this service unavailable error!

I would love to freaking scream, because I have been trying to make this works for two weeks, but I will chill until someone shows me how simple it is! LOL

Go ahead P**K Make me love Vista! Joshin!

I need help!

I can't get VISTA Ultimate and IIS7 to work! I get - HTTP Error 503. The service is unavailable.

dennis_halsey — Tue, 24 Jul 2007 19:52:07 GMT

I got IIS Installed and seemingly running (after i screwed it up and had to reinstall Vista) and I set the most obvious things but but now when I go to http://127.0.0.1/iisstart.htm , or any ASP page in wwwroot get the following freaky error:

Service Unavailable

HTTP Error 503. The service is unavailable.

What the crap is that? What service, and why is it unavailalbe? shouldn't it be?

I am the IT guy for a major company and I have read article after article and my boss hasn't figured out that I look like a fool becuase I can't make this thing work. This should not be this complicated. what is the average web builder supposed to do? they could never figure II7/VISTA out.

Here is my very simple question and I would love to have a very simple answer!
What are the exact minimum required settings in Vista and IIS7 to be able to browse ASP pages on your local PC(Webserver)?

If anyone can easily answer this and it works, then you might not need this Forum, you could just post this easy answer and everyone would get it!

I am joking of course!, this forum has been very valuable so far to me and I have gotten a lot of responses in my emails to my question!

I would love to use my 4000.00 new computer to build Ecommerce sites, but I don't have the time at work to figure all of this out, so I just go into the back and fire up my old Xp mahcine and get things done! Please Help!

Thank you,

Dennis Halsey

dennis_halsey@ycharter.net

Re: Problem with Access database and ASP Page - IIS 7 and Windows Vista Ultimate

iisray — Thu, 10 May 2007 21:31:06 GMT

Hi,

To enable ASP error message, please see http://forums.iis.net/thread/1652934.aspx

Regarding the Access/ASP issue, please see http://support.microsoft.com/kb/926939

Ray