Try putting in a valid user name with no password. That's what works
here.
Cheers,
Carl Reynolds Ph: +64-9-4154790
CJN Technologies Ltd. Fax: +64-9-4154791
[EMAIL PROTECTED] DDI: +64-9-4154795
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at http://www.cjntech.co.nz/
> -----Original Message-----
> From: Gnad, Philip [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 22, 1999 6:41 AM
> To: Multiple recipients of list delphi
> Subject: [DUG]: Accessing Mixed Security SQL Server with a
> Trusted Connection
>
> Hi all
>
> I'm trying to access a SQL Server 7 database via a TDatabase
> component. The
> database is set up for mixed security but I want users to access the
> database for this application using trusted connections.
>
> The database open command fails with invalid user name and password.
> I've tried this successfully in the past with SQL Server 6.5 by
> putting a
> single space user name and no password in the parameter string.
> However SQL Server 7 checks for a space as the username and fails.
>
> Putting in a blank user name causes the app to return a user name of
> MYNAME
> and fail.
> Putting in the trusted username and password also fails.
>
> Is there any way of forcing the application to open the database under
> a
> trusted connection?
>
> Any help appreciated.
> Phil Gnad
> ----------------------------------------------------------------------
> -----
> New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
application/ms-tnef
