Login problem

Hi all,
I wrote an ISAPI (dll) application to work with a database on my SQL2K. When
I use windows NT integrated security (MyDomain\Username), The application
works properly. But when I use a specific username and password (using a sql
buildin login) I get this error message when adding a new record to the
database.
Internal Application Error
Application uses a value of the wrong type for the current operation
I granted the user to have full access to the database.
Any help would be appreciated.
Thank you,
MehrdadHi
Does the user have all appropriate permissions to insert data into table?
"M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
news:%23CCQpjtyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I wrote an ISAPI (dll) application to work with a database on my SQL2K.
When
> I use windows NT integrated security (MyDomain\Username), The application
> works properly. But when I use a specific username and password (using a
sql
> buildin login) I get this error message when adding a new record to the
> database.
> --
> Internal Application Error
> Application uses a value of the wrong type for the current operation
> --
> I granted the user to have full access to the database.
> Any help would be appreciated.
> Thank you,
> Mehrdad
>|||Yes, the user have all the permissions to Insert, Delete, Edit, and Create
the table.
Mehrdad
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O4Zq21tyEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Hi
> Does the user have all appropriate permissions to insert data into table?
>
>
>
> "M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
> news:%23CCQpjtyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> When
application[vbcol=seagreen]
> sql
>|||Hi
Perhaps you try to insert a value that has a different datatype (as error
said). Can you show us the INSERT statement?
"M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
news:uK$TWauyEHA.352@.TK2MSFTNGP14.phx.gbl...
> Yes, the user have all the permissions to Insert, Delete, Edit, and Create
> the table.
> Mehrdad
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O4Zq21tyEHA.3120@.TK2MSFTNGP12.phx.gbl...
table?[vbcol=seagreen]
SQL2K.[vbcol=seagreen]
> application
a[vbcol=seagreen]
the[vbcol=seagreen]
>|||Thank you Uru for your notice to my problem. I asked the administrator to
restart the SQL server. It works now properly.
Thank you,
Mehrdad
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OMn4KduyEHA.2568@.TK2MSFTNGP10.phx.gbl...
> Hi
> Perhaps you try to insert a value that has a different datatype (as error
> said). Can you show us the INSERT statement?
>
>
>
> "M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
> news:uK$TWauyEHA.352@.TK2MSFTNGP14.phx.gbl...
Create[vbcol=seagreen]
> table?
> SQL2K.
(using[vbcol=seagreen]
> a
> the
>