When DMX creates an insert page for me, the page generates the following error. My web server is using .net framework 1.1, I am using vb.net scripting and sqlserver. Whats the deal?

<b>
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'nvarchar'.
Line 1: Incorrect syntax near 'Keys'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()</b>

Andrew
God Bless you

OOPS, I had used the upsizing wizard in access to create the tables in ms sql. There were some spaces in the table names and the spaces were killing the sql comands. Removed the spaces and dreamweaver is interacting great with .net.

I did have to copy the dreamweaver server side files from the bin directory on my local webserver to the production web server.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
When DMX creates an insert page for me, the page generates the following error. My web server is using .net framework 1.1, I am using vb.net scripting and sqlserver. Whats the deal?

<b>
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'nvarchar'.
Line 1: Incorrect syntax near 'Keys'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()</b>

Andrew
God Bless you
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Andrew
God Bless you