Something overlooked with SQL?

[TNO]

Hopefully this is some simple error I'm overlooking in syntax. I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''TestUser','Sun Mar 30 00:17:42 UTC 2008','Foo bar text')' at line 1

/temp/chatBox.asp, line 35

And here is the related lines (JScript):

	SQL = "CREATE TABLE t_chat("+ 
		"name VARCHAR(20),"+
		"date VARCHAR(40),"+
		"msg VARCHAR(100)"+
		");";
	adoConn.Execute(SQL);

	//add a test record
	var dt = new Date();
	SQL = "INSERT INTO t_chat"+
		"VALUES ('TestUser','"+ dt +"','Foo bar text');";
	adoConn.Execute(SQL); //<-- Line 35

Any suggestions? Or is more info needed?

[TNO]

nevermind, it was something simple.....I forgot a space.

SQL = "INSERT INTO t_chat"+ ---> SQL = "INSERT INTO t_chat "+