ODBC connection failed (SQL Server Native Client)

Question

Dear ..

I tried to connect to ODBC with SQL Server Native Client 11.0.

It successfully connected in SQL mgmt studio : (LocalDB)\AAA

but when I tried to connect to ODBC, it's failed like below..

[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'KKIKKI\Jinsu'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "MAPDB" requested by the login. The login failed.

test failed.

How to initialize all of my SQL Native Client and ODBC configuration?
I tried to remove all SQL application, but it's same situation.. Please help..

---

jinsu

Answer 1

https://www.connectionstrings.com/sql-server-native-client-11-0-odbc-driver/

---

T-SQL Articles
T-SQL e-book by TechNet Wiki Community
T-SQL blog

Answer 2

The error seems to point out that you have a database parameter set in your connection string (MAPDB) which is probably not existent on the server. Please login to the server with the login mentioned using SSMS and verify whether the DB (MAPDB) exists or not and that the specified login has access.

Answer 3

I created MAPDB database manually, then successfully connected betwenn ODBC and Native Client.

Thank you

---

jinsu