Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > error 91

Reply
Thread Tools

error 91

 
 
abcd
Guest
Posts: n/a
 
      06-01-2005
I am using asp page and a VB component

VB component has a simple method which inserts a record into Access databse

like

Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
conn.Open strDSN
Set cmd.ActiveConnection = conn
cmd.CommandType = adCmdText

strQuery = "Insert into Table1 values ("
strQuery = strQuery + "'" & strID & "',"
strQuery = strQuery + "'" & strName & "')"

cmd.CommandText = strQuery

cmd.Execute

<after this command I get error 91>

When I test my component from another VB cient then it works great but
getting error 91 when called from ASP

any clues...

thanks in advance


 
Reply With Quote
 
 
 
 
abcd
Guest
Posts: n/a
 
      06-01-2005
I have found the solution....

my .mdb files needs to have IUSR_<MACHINENAME> permissions !!!

cheers !


"abcd" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using asp page and a VB component
>
> VB component has a simple method which inserts a record into Access
> databse
>
> like
>
> Dim conn As New ADODB.Connection
> Dim cmd As New ADODB.Command
> conn.Open strDSN
> Set cmd.ActiveConnection = conn
> cmd.CommandType = adCmdText
>
> strQuery = "Insert into Table1 values ("
> strQuery = strQuery + "'" & strID & "',"
> strQuery = strQuery + "'" & strName & "')"
>
> cmd.CommandText = strQuery
>
> cmd.Execute
>
> <after this command I get error 91>
>
> When I test my component from another VB cient then it works great but
> getting error 91 when called from ASP
>
> any clues...
>
> thanks in advance
>
>



 
Reply With Quote
 
 
 
 
Kyle Peterson
Guest
Posts: n/a
 
      06-01-2005
database permissions ?

http://www.powerasp.com/content/new/...ermissions.asp


"abcd" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using asp page and a VB component
>
> VB component has a simple method which inserts a record into Access
> databse
>
> like
>
> Dim conn As New ADODB.Connection
> Dim cmd As New ADODB.Command
> conn.Open strDSN
> Set cmd.ActiveConnection = conn
> cmd.CommandType = adCmdText
>
> strQuery = "Insert into Table1 values ("
> strQuery = strQuery + "'" & strID & "',"
> strQuery = strQuery + "'" & strName & "')"
>
> cmd.CommandText = strQuery
>
> cmd.Execute
>
> <after this command I get error 91>
>
> When I test my component from another VB cient then it works great but
> getting error 91 when called from ASP
>
> any clues...
>
> thanks in advance
>
>



 
Reply With Quote
 
Kyle Peterson
Guest
Posts: n/a
 
      06-01-2005
oops.. problem already solved


"Kyle Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> database permissions ?
>
> http://www.powerasp.com/content/new/...ermissions.asp
>
>
> "abcd" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I am using asp page and a VB component
>>
>> VB component has a simple method which inserts a record into Access
>> databse
>>
>> like
>>
>> Dim conn As New ADODB.Connection
>> Dim cmd As New ADODB.Command
>> conn.Open strDSN
>> Set cmd.ActiveConnection = conn
>> cmd.CommandType = adCmdText
>>
>> strQuery = "Insert into Table1 values ("
>> strQuery = strQuery + "'" & strID & "',"
>> strQuery = strQuery + "'" & strName & "')"
>>
>> cmd.CommandText = strQuery
>>
>> cmd.Execute
>>
>> <after this command I get error 91>
>>
>> When I test my component from another VB cient then it works great but
>> getting error 91 when called from ASP
>>
>> any clues...
>>
>> thanks in advance
>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
Error connecting to SQLExpress 2005 locally (error: 26 - Error Locating Server/Instance Specified) hfk0 ASP .Net 2 03-27-2006 08:43 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM
Error 500: ERROR: Cannot forward. Writer or Stream already obtained. Error JavaQueries Java 1 03-01-2005 06:30 PM



Advertisments