-----Original Message-----

From: Jess Ramey [mailto:JRamey@n...]

Sent: 19 June 2000 14:23

To: 'feedback@w...'

Subject: Getting Started With ASP & Databases





Hello,

I recently purchased your book on ASP Databases. I set up a database 

called

"JobQwest"using SQL Server 7.0 with two tables, one called "Recruiter" and

one called "Applicant'. I'm using the PWS on Windows 98. I defined a DSN 

on

my system called "JobQwest" which is linked to the "JobQwest" database, 

and

tests properly on the system.



But when I try to run the ASP code that sends information from the form to

the JobQwest database using ADO, I get an error message, that user "null"

does not have access rights to the database.



What am I ding wrong?



Thanks,

Jesse L. Ramey

You must grant rights to the user account your are using to access your SQL

Server.  Start SQL Server Enterprise manager, open the database you want.

Right-click the tablename you want access to.  Choose Properties and when the

new window appears, Click the Permissions button.  From the screen that appears,

you can add users and grant them access rights on the database.



KD