Re: ASP Problem on uploading file into SQL 2005 DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Cinzia

How do you do that? How can I uninstall lower version of MDAC?

Monica

"Cinzia" <cinziapagani-no-spam_please@xxxxxxxxxx> wrote in message
news:OCouHh6XGHA.3444@xxxxxxxxxxxxxxxxxxxxxxx


"Monica" <dfzsdf@xxxxxxxxxx> ha scritto nel messaggio
news:uUYRJagXGHA.752@xxxxxxxxxxxxxxxxxxxxxxx
I have a problem with uploading file into SQL 2005 DB using IIS 6.0
webserver, this code was working in SQL 2000 Db and IIS 5.0. Can you
please
help me to see what the problem is.


Error msg :

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

[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not
include
the table being modified or the table is not updatable through the
cursor.

/uploadnewrequest.asp, line 158


Code:
rstrNewFiles = ""
Set rstrNewFiles = Server.CreateObject("ADODB.Recordset")
rstrNewFiles.Open "tblrFiles", Conn, 3, 3
Set cmd = Server.CreateObject("ADODB.Command")
with cmd
.ActiveConnection = conn
.Parameters.Refresh
.CommandTimeout = 3600
End With


rstrNewFiles.AddNew
rstrNewFiles("ProjectNo") = strprojNumber
rstrNewFiles("projectID") = Uploader.Form("ProjNo")
rstrNewFiles("FileName") = File.FileName
rstrNewFiles("FileSize") = File.FileSize
rstrNewFiles("CreatedBy") = strUSer
rstrNewFiles("IPAddress") = varIPAddress
rstrNewFiles("DateCreated") = strDateCreated
If varFileExtension = "doc" then
rstrNewFiles("ContentType") = "application/msword"
Else
rstrNewFiles("ContentType") = File.ContentType
End if
rstrNewFiles("FileData").AppendChunk File.FileData
Line 158 - rstrNewFiles.Update
rstrNewFiles.Close


Hi Monica,
I had a similar problem.
The problem in my case, was generated by different release od ADO
installed
on the server running the application.
To work fine with SQL Server 2005 you need MDAC 2.8, but if in your
system
you have also MDAC 2.6, 2.1 ecc...
could be IIS don't use the last version ... so if you can, try to
remove
the old version of mdac.


--
Cinzia
---------------------------------------
| http://www.riolab.org |
--------------------------------------->




.

Relevant Pages

  • Re: ASP Problem on uploading file into SQL 2005 DB
    ... this code was working in SQL 2000 Db and IIS 5.0. ... Microsoft OLE DB Provider for ODBC Drivers error '80040e23' ... To work fine with SQL Server 2005 you need MDAC 2.8, ...
    (microsoft.public.inetserver.asp.db)
  • Re: IISState log - Please help decipher
    ... System state when ASP hangs is not very remarkable other than DLLHost.exe. ... > What version of MDAC are you running? ... > Microsoft IIS ... > Newsgroup Support ...
    (microsoft.public.inetserver.iis)
  • Re: data access providers
    ... but something is failing with the RDS / MDAC ... i had set up the website in IIS and added a ... followed all their instructions the error still appears. ... error saying - internet server error: ...
    (microsoft.public.inetserver.asp.db)
  • Re: Newbie ques - client workstation computers
    ... Do the workstations need MDAC or anything updated? ... that Sql Server 2000 may want to use? ... SQL shouldn't need your IIS files. ... One thing I usually do when rolling out clients is choose a version of MDAC ...
    (microsoft.public.sqlserver.clients)
  • Re: ASP Problem on uploading file into SQL 2005 DB
    ... How can I uninstall lower version of MDAC? ... this code was working in SQL 2000 Db and IIS 5.0. ... To work fine with SQL Server 2005 you need MDAC 2.8, ...
    (microsoft.public.inetserver.asp.db)