aspsmartupload error

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!!

Daniel
Tue Apr 01 10:57:26 CDT 2008

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

Mike
Tue Apr 01 15:12:08 CDT 2008


"Todd" <Todd@discussions.microsoft.com> wrote in message
news:9025B01B-10B0-439C-9D24-9162EC62517C@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

iahamed
Tue Apr 01 22:24:22 CDT 2008

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@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!!

Bob
Tue Apr 01 23:17:16 CDT 2008


"Todd" <Todd@discussions.microsoft.com> wrote in message
news:9025B01B-10B0-439C-9D24-9162EC62517C@microsoft.com...
.
.
.
>
> Server.MapPath(".") & "\jobpostingsdb.mdb; uid=admin; pwd=hi12tech"

Right now would be a very good time to change your password.

- Bob.

Evertjan
Wed Apr 02 02:00:31 CDT 2008

Bob Milutinovic wrote on 02 apr 2008 in
microsoft.public.inetserver.asp.general:

>
> "Todd" <Todd@discussions.microsoft.com> wrote in message
> news:9025B01B-10B0-439C-9D24-9162EC62517C@microsoft.com...
> .
> .
> .
>>
>> Server.MapPath(".") & "\jobpostingsdb.mdb; uid=admin; pwd=hi12tech"
>
> Right now would be a very good time to change your password.

No need, no one wil believe you did not do that already.

;-)


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Bob
Wed Apr 02 05:13:37 CDT 2008

iahamed wrote:
> 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@yahoo.com
>

Why not share them here?
You are aware that non-component-based solutions typically have limited
performance, aren't you? If large files are being transferred and it's a
busy server, users will thank the developer for using a component.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"