FP2002 Connect to SQL Database-Help!

[Jeff]

I guess this should be easy, but I cant get it to work.
I created a simple database in SQL called mytest
created a table called names (First, Last)

Went into Frontpage, created a website on same server (has IIS and
such loaded), ran the database connect, it sees my table and verifys
connection.

I created an ASP page with a form which submits First and Last as form
fields.

I matched the form fields to the DB field.

Frontpage says it submitted it, the database shoes no changes or
additions! What am I doing wrong!

 

[David Martin]

From your description you appear to created the page properly.

I think that this could be a permissions problem. Check your ODBC connection
properties - if you did not specifiy a user/password the IIS anonomous user
USR_servername isused and must have permissions to the table

David.

 

[Kevin Spencer]

Somewhere in the details of what you did (you only gave us the headlines),
you did something wrong.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.