Hi!

I'd like to check somehow is the used connection, which uses MSDE
database, trusted connection or not. Is there any other possibilities to
check this - except searching used ConnectionString of the connection?

I need this because I'm trying to make it possible Backup Database
directly using my application into file, and my application uses
osql-command to do this.

I already succeeded to make osql-command to work after user has selected
file location where to save backup file using "Save As"-dialog, but it
work only with trusted connection. So if connection is not trusted
connection, then my application should ask User ID and Password needed
for osql-command to work - I think.

--
Thanks in advance!

Mika

Well, checking the connection string is a quite easy and straightforward way
of doing this - why do you not want to do that?

--

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------
---------------

"Mika M" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi!
>
> I'd like to check somehow is the used connection, which uses MSDE
> database, trusted connection or not. Is there any other possibilities to
> check this - except searching used ConnectionString of the connection?
>
> I need this because I'm trying to make it possible Backup Database
> directly using my application into file, and my application uses
> osql-command to do this.
>
> I already succeeded to make osql-command to work after user has selected
> file location where to save backup file using "Save As"-dialog, but it
> work only with trusted connection. So if connection is not trusted
> connection, then my application should ask User ID and Password needed
> for osql-command to work - I think.
>
> --
> Thanks in advance!
>
> Mika

In 2.0, there is the SqlConnectionStringBuilder class that will help parse
connection strings correctly so that you can correctly determine that
answer.

--
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Sahil Malik [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Well, checking the connection string is a quite easy and straightforward
> way
> of doing this - why do you not want to do that?
>
> --
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
> ----------------------------------------------------------------------------
> ---------------
>
> "Mika M" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi!
>>
>> I'd like to check somehow is the used connection, which uses MSDE
>> database, trusted connection or not. Is there any other possibilities to
>> check this - except searching used ConnectionString of the connection?
>>
>> I need this because I'm trying to make it possible Backup Database
>> directly using my application into file, and my application uses
>> osql-command to do this.
>>
>> I already succeeded to make osql-command to work after user has selected
>> file location where to save backup file using "Save As"-dialog, but it
>> work only with trusted connection. So if connection is not trusted
>> connection, then my application should ask User ID and Password needed
>> for osql-command to work - I think.
>>
>> --
>> Thanks in advance!
>>
>> Mika
>
>