Re: ODBC connection without knowing user and password

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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:

On Nov 3, 11:40 pm, "Dmitriy Ivanov" <divanov_NOSP@xxxxxxxx> wrote:
"Neo" <mukhtar.o...@xxxxxxxxx> 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/

**************************************
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
.

.

Relevant Pages

  • Re: Understanding SQL Connection
    ... production SQL server being hosted by a 3rd party on an external domain. ... "Rick Brandt" wrote: ... >> the linked table wizard and created a DSN. ... > credentials are automatically passed when the DSN is actually used later on. ...
    (microsoft.public.access.forms)
  • Re: Understanding SQL Connection
    ... > the linked table wizard and created a DSN. ... Connect to SQL Server to obtain default settings for the additional ... In other words it means "While I am creating this DSN use these credentials to ... With SQL Server it is best to set it up using Trusted Connections (Integrated ...
    (microsoft.public.access.forms)
  • Re: ODBC connection without knowing user and password
    ... N> I have provided an application from our data provider which creates ... N> It creates a system DSN atomatically and we dont know which User/ ... As a rule, the a DBMS checks for credentials, not a DSN or the Driver ...
    (microsoft.public.data.odbc)
  • Frage zu OdbcException
    ... passieren, eine OdbcException ausgelöst wird, da noch zusätzlich zur DSN die ... Credentials in den ConnectionString aufgenommen werden müssen. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)