#18 OLEDB connection does not work

[Brant Gurganus]

I set up an OLEDB connection using Jet 4.0 to an Access
2002 database. I ran the setup script and received the
following result (I changed to ODBC connection and it
worked):

Error Occurred While Processing Request

Error Diagnostic Information

OLEDB Error Code = -537398753

Syntax error in field definition.

SQL = "create table fbof_user ( user_id counter not
null, group_id number not null, user_name varchar(15)
not null, password varchar(30) not null, date_created
datetime not null, location varchar(35) null, inst_msg
varchar(30) null, email varchar(50) not null,
bHideEmail number not null, signature varchar(250)
null, profile longtext null, CONSTRAINT PK_USER PRIMARY
KEY(user_id) )"

Data Source = "FORUM"

The error occurred while processing an element with a
general identifier of (CFQUERY), occupying document
position (561:3) to (561:44) in the template file
E:\Inetpub\wwwroot\Mothership\forum\scripts\act_setupTables.cfm.

Date/Time: 08/04/03 13:08:13
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.5b) Gecko/20030803
Remote Address: 192.168.1.123
HTTP Referrer: http://mothership/forum/scripts/