hi,
I use a dsn connection to my SQL server database,but it take error from 
this 

sentence: objconn.open "dsn=power" with this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 

'server-name\IUSR_server-name' 

help me plz!

SQL Server is using Integrated Windows Authentication - this means you need
to permit the NT account to login to the database - you can't specify a
username/password in the DSN.

Look in Books Online for more information.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "jino" <jino1380@y...>
Subject: [asp_databases] a DSN problem


: I use a dsn connection to my SQL server database,but it take error from
: this
:
: sentence: objconn.open "dsn=power" with this error:
:
: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
:
: 'server-name\IUSR_server-name'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi,
You have to provide the username and password of your
sql server.

objconn.open "dsn=power;UID=username;PWD=password;" 

Hope this should work.
Thanks
Best regards
--Arshad--


__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com