Dreamweaver MX Insert Record Server Behavior Error
I am using dreamweaver MX v6.1
when i try and connect to my sql database in order to use the server behavior's, 'insert record' or 'recordset', it will connect to the database, see the table, but not any of the fields/columns within the table! however when i perform a test on the recordset i can see all of the information within the fields in the table.
the field names in the table on the database relate the names in the form all ok
i can't perform an insert record through dreamweaver if i can't see the columns
i hope this makes sense!
any help would be apreciated, ive been on this for ages lol