ADO and ASP

[Matrix 9]

hi everyone,
I am buildinga site with SQL 7.0 and ASP among other tools. My problems comes
in when I try to add a new record to my database. Prevoiusly I had constructed
a demo site with Microsoft Access and it worked fine.
When I changed to the New Sql Database and the only change i did was to alter
slightly the connectionstring to reflect the change of the database, I am
getting varoius errors, but I can display and edit but not addnew!!.
what cauld possibly be wrong?

Thanks in advance

[Sergey]

Post the errors and code that does insertion.

Sergey.

"Matrix 9" <kenyaga@yahoo.com> wrote:
>
>hi everyone,
>I am buildinga site with SQL 7.0 and ASP among other tools. My problems
comes
>in when I try to add a new record to my database. Prevoiusly I had constructed
>a demo site with Microsoft Access and it worked fine.
>When I changed to the New Sql Database and the only change i did was to
alter
>slightly the connectionstring to reflect the change of the database, I am
>getting varoius errors, but I can display and edit but not addnew!!.
>what cauld possibly be wrong?
>
>Thanks in advance