Hello, Imar.

I am trying to use a form to insert data on an SQL Server 2000 databank located on an "exterior server", using your Chapter 12 of "Begining Dreamweaver MX 2004" as a guide (very good, by the way).

I guess my connection is ok (it created the dbo user... and the testing gets ok) , I put the web.config on the server (correcting a previous mistake) and I think the table related to the data was properly created on the databank.

When I press "insert record" (button) I am NOT redirected to the page defined to be send and the following message appears, with my form, filled, right below these lines.

System.Exception: Unsupported TYPE attribute: GUID
at DreamweaverCtrls.DataSet.GetDbTypeFromString(Strin g str)
at DreamweaverCtrls.DataSet.AddParameters(IDbCommand myCommand)
at DreamweaverCtrls.DataSet.DoInit()

Please help!

Thanks a lot,
Fábio.

It looks like you're using ASP.NET with Dreamweaver's Data controls right?

That's not discussed in the book, as the book focuses on ASP only.

How does the rest of the code look like? Personally, I am not a fan of the Dreamweaver controls for .NET so maybe it's easier / better to write your own custom code for inserts and updates....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks for your extremely quick response, Imar!

You are right, I am using ASP.NET (the "Apendix A" in your book was very useful on this matter but... yes, the book is ASP-focused).

A couple of minutes ago I created a very-small-table-and-coding "testInsert.aspx" page trying to "isolate" the error and... it didn´t get one! :)

It seems to me that the only reasonable conclusion is that (in the real SQL table) I defined some fields badly. My best guess is to change "autonumber" (uniqueidentifier) to "int" , by the way. (I used the first in the real stuff and "int" - with identity checked and seed 1 - in the testing case...

If it does not work I will stop being lazy and write the code. If I still have trouble I will let you know and be once-more very grateful for your expertise and kindness.

Best regards,
fskilnik

The uniqueidentifier is not a number, but a GUID, in the form of something like:

{F705DA25-FA81-4028-AA0D-7D51C833B4F3}

This cannot be converted to a number, so maybe this type isn't supported in the Dreamweaver controls??

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hello, Imar. You are probably right!

That´s (probably) the reason for the Error Message. Anyway, I changed that field type (as mentioned in the previous email) and it all went right!

Thank you very much for your support,
fskilnik.