aspsmartupload error
in [ASP]
|
From: Todd on 1 Apr 2008 10:36 I am using Windows XP and have registered the aspsmartupload dll and moved it into the system32 directory. I get the following error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80070005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x918 Thread 0xa90 DBC 0x96768d4 Jet'. The error occurs on the line where I set my variable called mySmartUpload Here is my code <%Set Cnn = Server.CreateObject("ADODB.Connection") Cnn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq= "& Server.MapPath(".") & "\jobpostingsdb.mdb; uid=admin; pwd=hi12tech" Dim mySmartUpload Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload") mySmartUpload.Upload sql = "insert into jobpostings (testing) values ('"&mySmartUpload.Form("testing")&"')" cnn.execute(sql) I usually get these types of errors when trying to access a database. My understanding is aspsmartupload has nothing to do with a database. And the database I'm using in this program is making a successful connection (at least there was no error on the line of code that opened the connection). Any suggestions? Thanks!!
From: Daniel Crichton on 1 Apr 2008 11:57 Todd wrote on Tue, 1 Apr 2008 07:36:04 -0700: > I am using Windows XP and have registered the aspsmartupload dll and > moved it into the system32 directory. I get the following error > Error Type: > Microsoft OLE DB Provider for ODBC Drivers (0x80070005) > [Microsoft][ODBC Microsoft Access Driver]General error Unable to open > registry key 'Temporary (volatile) Jet DSN for process 0x918 Thread > 0xa90 DBC 0x96768d4 Jet'. > The error occurs on the line where I set my variable called > mySmartUpload > Here is my code > <%Set Cnn = Server.CreateObject("ADODB.Connection") > Cnn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq= "& > Server.MapPath(".") & "\jobpostingsdb.mdb; uid=admin; pwd=hi12tech" > Dim mySmartUpload > Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload") > mySmartUpload.Upload sql = "insert into jobpostings (testing) values > ('"&mySmartUpload.Form("testing")&"')" > cnn.execute(sql) > I usually get these types of errors when trying to access a database. > My understanding is aspsmartupload has nothing to do with a database. > And the database I'm using in this program is making a successful > connection (at least there was no error on the line of code that > opened the connection). > Any suggestions? > Thanks!! That certainly looks like a Jet database error. Does the anonymous account have permissions to write to the temp folder? If you remove the aspsmartupload lines and just run a simple select, do you still get the error? -- Dan
From: Mike Brind on 1 Apr 2008 16:12 "Todd" <Todd(a)discussions.microsoft.com> wrote in message news:9025B01B-10B0-439C-9D24-9162EC62517C(a)microsoft.com... >I am using Windows XP and have registered the aspsmartupload dll and moved >it > into the system32 directory. I get the following error > > > Error Type: > Microsoft OLE DB Provider for ODBC Drivers (0x80070005) > [Microsoft][ODBC Microsoft Access Driver]General error Unable to open > registry key 'Temporary (volatile) Jet DSN for process 0x918 Thread 0xa90 > DBC > 0x96768d4 Jet'. > > The error occurs on the line where I set my variable called mySmartUpload > > > Here is my code > > <%Set Cnn = Server.CreateObject("ADODB.Connection") > Cnn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq= "& > Server.MapPath(".") & "\jobpostingsdb.mdb; uid=admin; pwd=hi12tech" > Dim mySmartUpload > Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload") > mySmartUpload.Upload > sql = "insert into jobpostings (testing) values > ('"&mySmartUpload.Form("testing")&"')" > cnn.execute(sql) > > I usually get these types of errors when trying to access a database. My > understanding is aspsmartupload has nothing to do with a database. And the > database I'm using in this program is making a successful connection (at > least there was no error on the line of code that opened the connection). > > Any suggestions? > > Thanks!! I would stop using ODBC, and use the Jet OLEDB provider instead. http://access.databases.aspfaq.com/why-do-i-get-general-error-unable-to-open-registry-key-driverid.html -- Mike Brind - MVP ASP/ASP.NET
From: iahamed on 1 Apr 2008 23:24 Set MyConn = Server.CreateObject("ADODB.Connection") MyConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("/yourdb/folder/whatever_name.mdb") & ";Persist Security Info=False" And why use aspsmartupload dll like the ASP Old School Style, there are many TOTAL ASP non componant based uploads use them. If not write to me will give them. iahamed123(a)yahoo.com Happy coding. Bye. Todd wrote: >I am using Windows XP and have registered the aspsmartupload dll and moved it >into the system32 directory. I get the following error > >Error Type: >Microsoft OLE DB Provider for ODBC Drivers (0x80070005) >[Microsoft][ODBC Microsoft Access Driver]General error Unable to open >registry key 'Temporary (volatile) Jet DSN for process 0x918 Thread 0xa90 DBC >0x96768d4 Jet'. > >The error occurs on the line where I set my variable called mySmartUpload > >Here is my code > ><%Set Cnn = Server.CreateObject("ADODB.Connection") >Cnn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq= "& >Server.MapPath(".") & "\jobpostingsdb.mdb; uid=admin; pwd=hi12tech" >Dim mySmartUpload >Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload") >mySmartUpload.Upload >sql = "insert into jobpostings (testing) values >('"&mySmartUpload.Form("testing")&"')" >cnn.execute(sql) > >I usually get these types of errors when trying to access a database. My >understanding is aspsmartupload has nothing to do with a database. And the >database I'm using in this program is making a successful connection (at >least there was no error on the line of code that opened the connection). > >Any suggestions? > >Thanks!!
From: Bob Milutinovic on 2 Apr 2008 00:17
"Todd" <Todd(a)discussions.microsoft.com> wrote in message news:9025B01B-10B0-439C-9D24-9162EC62517C(a)microsoft.com... .. .. .. > > Server.MapPath(".") & "\jobpostingsdb.mdb; uid=admin; pwd=hi12tech" Right now would be a very good time to change your password. - Bob. |