|
|
|
| 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
>
>
| |
| Kyle Peterson 2005-06-01, 8:55 pm |
| 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
>
>
| |
| Kyle Peterson 2005-06-01, 8:55 pm |
| oops.. problem already solved
"Kyle Peterson" <kpete23@hotmail.com> wrote in message
news:O1JBj7uZFHA.3220@TK2MSFTNGP14.phx.gbl...
> database permissions ?
>
> http://www.powerasp.com/content/new...permissions.asp
>
>
> "abcd" <abcd@abcd.com> wrote in message
> news:utDjOpsZFHA.2940@tk2msftngp13.phx.gbl...
>
>
|
|
|
|