Database username and password problem

2 次查看（过去 30 天）
Aidin Esmkhani
Aidin Esmkhani 2023-4-7
回答： Deep 2023-6-22
Hi. I have created an ODBC database using microsoft access and set "admin" as username and password but with any password and username it is possible to connect to the database. What is the reason ?
I have set following username and password in ODBC configuration window:
username = 'admin';
password = 'admin';
But with any username and password I can connect to the database. For example:
datasource = 'dbdemo';
username = 'Test';
password = '1234';
conn = database(datasource,username,password);

请先登录，再回答此问题。

回答（1 个）

Deep
Deep 2023-6-22
Hi. There could be a few reasons for this behavior:
  1. The Default User Account Control (UAC) Settings could be causing the issue. The Microsoft Access Driver on your computer might be running with elevated permissions due to the default UAC Settings. This could be allowing any user to access the database without authentication.
  2. The ODBC driver is ignoring the username and password: Some ODBC drivers may not use the username and password for authentication, but instead use the operating system credentials of the user logged in to the client system.
  3. The database does not require authentication: It is possible that the database has been set up to allow anonymous connections, so the username and password are not required to connect.

类别

在 Help Center 和 File Exchange 中查找有关 Configure Environment 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by