Search results matching tags 'ASP Classic' and 'Database'

Disk or Network Error in Windows 7, Please help

sorasak — Thu, 26 Nov 2009 13:03:33 GMT

Yesterday I upgrade my PC's OS from Vista to Seven Ultimate. After I turned on IIS feature, web applications on my machine do not work anymore. Disk or Network Error appear when I opened pages. I followed every steps of setting up from IIS's Blog (http://blogs.iis.net/bills/archive/2007/05/21/tips-for-classic-asp-developers-on-iis7.aspx). Classic ASP worked fine when I used Vista, but not work in Windows 7. Please help me to make my Classic ASP pages to run on WIndows 7, Thanks

IIS 7 VISTA OS Database Insert/ Update/ Delete Fails

qool — Fri, 25 Apr 2008 17:16:09 GMT

I have a classic ASP application recently moved our development environment from XP to Vista Business.

The application uses ActiveX DLL's to access data from a SQL 2000 box.

This application is currently running on IIS 7 from a vista business copy.

When I try to access the website from a Vista Machine, it reads the data from the database but when it tries to insert or update the records on the database it fails and gives me the following error:

"3421 Application uses a value of the wrong type for the current operation"

It is happening with all the functions and sub procedures.

But the weird thing is when I access the same website from an XP/2000/2003 machines it just works fine.

If we deploy the application on IIS 6.0 and access it from Vista the database operations works fine.

I am really stumped on this one.

I appreciate if someone can help me.

Thank you

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!

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

Floflo117 — Thu, 10 May 2007 08:08:23 GMT

Hello,

I've installed Windows Vista Ultimate with IIS 7 and common ASP pages are working fine ;-))

Nevertheless as soon as I try to do a connection to an Access database (DSN or DSN less) I've got an error 500 page. The pages and connection was working on Windows XP.

Do you have an idea to help me ?

Florian