error 91

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

I have found the solution....

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

cheers !


"abcd" <abcd@abcd.com> wrote in message
news:utDjOpsZFHA.2940@tk2msftngp13.phx.gbl...
>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
>
>

database permissions ?

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


"abcd" <abcd@abcd.com> wrote in message
news:utDjOpsZFHA.2940@tk2msftngp13.phx.gbl...
>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
>
>

oops.. problem already solved


"Kyle Peterson" <kpete23@hotmail.com> wrote in message
news:O1JBj7uZFHA.3220@TK2MSFTNGP14.phx.gbl...
> database permissions ?
>
> [url]http://www.powerasp.com/content/new/windows_2003_server_and_permissions.asp[/url
]
>
>
> "abcd" <abcd@abcd.com> wrote in message
> news:utDjOpsZFHA.2940@tk2msftngp13.phx.gbl... 
>
>