I am wanting to move into using OLE DB instead of OBDC.
I am trying to run a script that runs fine using OBDC.

Can anyone tell me why and how to get around these errors.
A little insight into OLE DB would be appreciated also.

My Code:

Create Table:

cn.execute("CREATE TABLE User (User COUNTER CONSTRAINT
PK_User PRIMARY KEY, User_Name TEXT(30) NULL,User_Password
TEXT(30) NULL,User_Agreement TEXT(15) NULL,User_Listed TEXT
(15) NULL,User_Type TEXT(30) NULL)")

Drop Table:

cn.execute("DROP TABLE User")

Both of these come up with syntax error like:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in CREATE TABLE statement.
/connect/database/createdb.asp, line 17