|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > asp cannot insert data to sql server 2000, but can select data to display
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
asp cannot insert data to sql server 2000, but can select data to display
|
|
| Avinash Neelkant 2002-06-27, 12:25 pm |
| Hi Zidane,
Make sure you have set the proper recordset type...i mean
either adOpenkeyset or adOpenDynamic.Try to use numbers
for these constants .Maybe in case you are using the
adovbs.inc file is not getting included....
if you can send me the ASP file.....i can check it out ....
Avinash
>-----Original Message-----
>in production server, my asp program can insert data and
select data between
>sql server 2000.
>but unluckily, in my testing server, my asp program
cannot insert data to
>sql server 2000, but can select data to display.
>I am pretty sure that my asp program is ok
>any missing in setting sql server 2000
>
>
>.
>
| |
|
| u can go to above topic
you can see 2 attached file
"Avinash Neelkant" <avi@gjan.com>
??????? :111fe01c21e03$73ee56d0$2ae2c9
0a@hosting.microsoft.com...
> Hi Zidane,
>
> Make sure you have set the proper recordset type...i mean
> either adOpenkeyset or adOpenDynamic.Try to use numbers
> for these constants .Maybe in case you are using the
> adovbs.inc file is not getting included....
>
> if you can send me the ASP file.....i can check it out ....
>
> Avinash
>
>
>
> >-----Original Message-----
> >in production server, my asp program can insert data and
> select data between
> >sql server 2000.
> >but unluckily, in my testing server, my asp program
> cannot insert data to
> >sql server 2000, but can select data to display.
> >I am pretty sure that my asp program is ok
> >any missing in setting sql server 2000
> >
> >
> >.
> >
|
|
|
|
|