ODBC connection without knowing user and password

[Neo]

Hi,
I have provided an application from our data provider which creates a
System DSN when run on any PC.
It creates a system DSN atomatically and we dont know which User/
Password has been used by this application.

Now in my C# .NET application i want to connect to that DSN and access
tables to get data.

The Problem i am facing is that when connecting through ADO.Net, in
Connection String it requires UserName and Password for that DSN,
which in my case i dont know.
How can i connect to that DSN without having user/password?

It sucks when i search internet, but no information found

[Dmitriy Ivanov]

"Neo" <mukhta...@gmail.com> wrote:

N> I have provided an application from our data provider which creates
N> a System DSN when run on any PC.
N> It creates a system DSN atomatically and we dont know which User/
N> Password has been used by this application.
N>|...snip...|

As a rule, the a DBMS checks for credentials, not a DSN or the Driver
Manager :-)

You have not specified the DBMS you are connecting to. But many DBMSs
provide a default user login, sometimes with the empty password. For
instance, an Access database usually include the "admin" user.
--
Sincerely,
Dmitriy Ivanov
Common Lisp ODBC interface - lisp.ystok.ru/ysql/

[Neo]

On Nov 3, 11:40 pm, "Dmitriy Ivanov" <divanov_NOSP@M_aha.ru> wrote:

**************************************
I know the rule. When creating DSN we are providing login credentials
and then we just communicate to DSN and rest will be done by DSN.
Is'nt there any way to get those credentials which are saved somewhere
in ODBC DSN?
I have SQL Server 2000 DSN, not Access.
Not provided with any user name/password from to application provider.
Just an application which creates a DSN and then i have to user it

[Pak-Ming Cheung - MSFT]

Actually, ODBC System DSN did not store password. Therefore, if the
application is connecting via the DSN, it has to provide credential
information in each of the connection.

Actually, there is no way to connect if you do not have the credential
information.

You may try one of the following:
- Contacting the software vendor which develop the ODBC application so that
you can know the credential information
- If you are the administrator of the SQL Server, you may reset the password.

Thanks,
Ming.
P.S. We recommend customers to use the forum to ask questions in the future,
where you can obtain a faster response (Forum is at:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/)

"Neo" wrote:

> .
>