Hi There,

I'm learning beginning ASP 3.0 and I've tried chapter 17 and followed the 
code from the book by setup the MSDE(in window2000 it works fine) but in 
win XP I got problem. I setup MSDE2000 from word XP software and I got 
the following error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL 
Server connection.

Any one has any suggestion. Thanks in advance.

Sydney,

Hi Sydney
Check you have only got 'SQL Server and Windows' checked and not just
'Windows' in the security option (Right click the name of the sql server in
Enterprise Manager/properties/security)

That should do it

Cheers

Sam




-----Original Message-----
From: Sydney Le [mailto:sydneyle02@y...]
Sent: 15 August 2002 18:13
To: ASP Databases
Subject: [asp_databases] MSDE2000


Hi There,

I'm learning beginning ASP 3.0 and I've tried chapter 17 and followed the 
code from the book by setup the MSDE(in window2000 it works fine) but in 
win XP I got problem. I setup MSDE2000 from word XP software and I got 
the following error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL 
Server connection.

Any one has any suggestion. Thanks in advance.

Sydney,

Hi guys


I have a access probelm i give a query in the access feild which i want 
to take the first letter in the uppercase



select (ucase(name,1)+lcase(mid(name,2,len(name))) from teststring
it works fine

when i use the update query

update teststring where name=3Dselect 
(ucase(name,1)+lcase(mid(name,2,len(name))) from teststring
update teststring where name=3D(select 
(ucase(name,1)+lcase(mid(name,2,len(name))) from teststring )

both  gives me a syntax error.Where exactly am i going wrong .can 
anybody give me some pointers

thanx in advance
sid