Hi,

I am using the following connection string to run a number of SQL stored
procedures in Excel VBA

"ODBC;Driver={SQL
Server};Server=nae-is-sql1;Database=Database;Trusted_Connection=no;UID=U serID;pword=Password"

I have created a specific login account for UserID with a password, and
allowed it to run the necessary stored procedures, look at tables and look at
certain databases.

When I try to run my script, it keeps showing a dialogue box with the
Username of UserID and it keeps wanting me give it the password which I have
already specified, have I done something really silly here, I want this to be
a DNS less connection, I am using SQL Server 2000 and Excel version 2003.

Thanks PD