anwar13
asked on
dsn connection
When i am using northwind database (built in when installed sql server) to create a recordset, it is ok.
But when i am using my own creation database to create a recordset, one dialog box come out showing:
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'User'.
I use the same driver in odbc when i create the DSN
I am using Sql server 7.0 and ultradev 4.0 with Windows2000 server.
Please help...
thank you
But when i am using my own creation database to create a recordset, one dialog box come out showing:
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'User'.
I use the same driver in odbc when i create the DSN
I am using Sql server 7.0 and ultradev 4.0 with Windows2000 server.
Please help...
thank you
Can you post your query?
ASKER
ALTER TABLE [dbo].[File] DROP CONSTRAINT FK_File_USER
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[USER]')
drop table [dbo].[USER]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[File]')
drop table [dbo].[File]
GO
CREATE TABLE [dbo].[USER] (
[UserID] [numeric](18, 0) NOT NULL ,
[name] [varchar] (50) NOT NULL ,
[password] [varchar] (50) NOT NULL ,
[email] [varchar] (50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[File] (
[UserID] [numeric](18, 0) NOT NULL ,
[FileID] [numeric](18, 0) NOT NULL ,
[FileDesc] [varchar] (8000) NOT NULL ,
[FileTitle] [varchar] (200) NOT NULL ,
[FilePath] [varchar] (100) NOT NULL ,
[FileDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[USER]')
drop table [dbo].[USER]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[File]')
drop table [dbo].[File]
GO
CREATE TABLE [dbo].[USER] (
[UserID] [numeric](18, 0) NOT NULL ,
[name] [varchar] (50) NOT NULL ,
[password] [varchar] (50) NOT NULL ,
[email] [varchar] (50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[File] (
[UserID] [numeric](18, 0) NOT NULL ,
[FileID] [numeric](18, 0) NOT NULL ,
[FileDesc] [varchar] (8000) NOT NULL ,
[FileTitle] [varchar] (200) NOT NULL ,
[FilePath] [varchar] (100) NOT NULL ,
[FileDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
Looks to me like USER is being thought of as a keyword or reserved word...
Try changing the name of the USER table to something else, and see what happens...
Try changing the name of the USER table to something else, and see what happens...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with dclary your create table is 8336 plus the length of the date. Which exceeds the max row size. You have a fileDesc of 8000 (seems kinda large), just lower that until the total length is less that 8353 or break it out into a second table.
I meant lower it until the total length is below 8060 bytes. Sorry about the typo.
ASKER
User here is the user table.