ado connection wont execute vfp

[yostyid]

So I am trying to connect an excel 2000 spreadsheet to foxpro7. I can return a recordset ok, but writing to the db is odd. I can do..

dbconn.execute "create table test(testcol text)
and it will be done. But if I try to exec ute a procedure or create a view, it fails. Here is my code..

Dim conn As ADODB.Connection
Dim rs, rs2 As ADODB.Recordset
Set rs = New ADODB.Recordset
Set rs2 = New ADODB.Recordset
Set conn = New ADODB.Connection
'On Error GoTo error_out
With conn
.CursorLocation = adUseServer
.Open "DSN=db"
End With
conn.Execute "create view custcheck as select * from customer"

..cursors seem to go ok. but proc's and views fail. I am new to this, so its probably something simple. Any help would be great.
thanks