Solved

dsn connection

Posted on 2001-06-23
9
233 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:anwar13
  • 2
  • 2
  • 2
  • +1
9 Comments
 

Author Comment

by:anwar13
ID: 6221499
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'User'.

User here is the user table.
0
 
LVL 15

Expert Comment

by:ericpete
ID: 6222403
Can you post your query?
0
 

Author Comment

by:anwar13
ID: 6222574
ALTER TABLE [dbo].[File] DROP CONSTRAINT FK_File_USER
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[USER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[USER]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[File]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
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
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 15

Expert Comment

by:ericpete
ID: 6224832
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...
0
 
LVL 1

Accepted Solution

by:
dclary earned 200 total points
ID: 6257502
The only message I get with SQL 7.0 is

"The total row size (8353) for table 'File' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added."

Hope that helps
0
 

Expert Comment

by:PhilipT1999
ID: 6873598
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.
 
0
 

Expert Comment

by:PhilipT1999
ID: 6873600
I meant lower it until the total length is below 8060 bytes.  Sorry about the typo.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now