# ODBC.DSN(dsn, user, password) error: DSN not defined

**URL:** <https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087>\
**Category:** New to Julia\
**Tags:** question\
**Created:** [October 10, 2020, 3:55am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087 "2020-10-10T03:55:26Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![indycdrom](https://avatars.discourse-cdn.com/v4/letter/i/eada6e/32.png) [@indycdrom](https://discourse.julialang.org/u/indycdrom)\
**Post date:** [October 10, 2020, 3:55am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/1 "2020-10-10T03:55:26Z")

</div>

hi, I have been using ODBC.DSN(dsn, user, password) to connect to oracle database using ODBC.jl (v0.8.1) and Julia 1.2.0 with no issue.

But when I upgraded to Julia 1.5.2 and ODBC (1.0.4), I got an error saying that DSN is not defined. The error did not disappear even I downgraded ODBC to v0.8.1. Can anybody advise me how I should resolve this issue?

thanks

---

<div class="post-metadata">

**Author:** ![jling](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jling/32/212909_2.png) [@jling](https://discourse.julialang.org/u/jling)\
**Post date:** [October 10, 2020, 3:59am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/2 "2020-10-10T03:59:47Z")

</div>

[https://juliadatabases.github.io/ODBC.jl/stable/#ODBC.adddsn](https://juliadatabases.github.io/ODBC.jl/stable/#ODBC.adddsn)

api changed it seems

---

<div class="post-metadata">

**Author:** ![indycdrom](https://avatars.discourse-cdn.com/v4/letter/i/eada6e/32.png) [@indycdrom](https://discourse.julialang.org/u/indycdrom)\
**Post date:** [October 14, 2020, 10:06pm UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/3 "2020-10-14T22:06:47Z")

</div>

i figured that it could be case. so I looked through the documentation and here was what I tried. please tell me what I missed.

julia\> ODBC.drivers()  
Dict{String,String} with 2 entries:  
“Oracle in OraClient11g\_home1” =\> “APILevel=1\0CPTimeout=60\0ConnectFunctions=YYY\0DriverODBCVer=03.51\0FileUsage=0\0SQLLevel=1\0”  
“SQL Server” =\> “APILevel=2\0ConnectFunctions=YYY\0CPTimeout=60\0DriverODBCVer=03.50\0FileUsage=0\0SQLLevel=1\0UsageCount=1\0”

julia\> ODBC.dsns()  
Dict{String,String} with 2 entries:  
“test” =\> “Oracle in OraClient11g\_home1”  
“SES1” =\> “Oracle in OraClient11g\_home1”

julia\> ODBC.Connection(“test”, “user”,“password”)  
ERROR: 28000: [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

First all, I checked the source code and it seems that it is the right syntax. but I am also confident that my user/password are right. so what am I missing?

---

<div class="post-metadata">

**Author:** ![alejandromerchan](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/alejandromerchan/32/10500_2.png) [@alejandromerchan](https://discourse.julialang.org/u/alejandromerchan)\
**Post date:** [October 15, 2020, 12:00am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/4 "2020-10-15T00:00:08Z")

</div>

I’m having the same problem and I has been using Julia to connect to an Oracle database for months, but today it didn’t work. Something changed in ODBC because reverting to ODBC@1.0.0 allowed me to connect to the database again.

---

<div class="post-metadata">

**Author:** ![shikil](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@shikil](https://discourse.julialang.org/u/shikil)\
**Post date:** [October 15, 2020, 1:38am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/5 "2020-10-15T01:38:24Z")

</div>

Please try  
ODBC.Connection(“DSN=test;UID=user;PWD=password”)

---

<div class="post-metadata">

**Author:** ![js135005](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/js135005/32/8219_2.png) [@js135005](https://discourse.julialang.org/u/js135005)\
**Post date:** [October 15, 2020, 2:41am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/6 "2020-10-15T02:41:39Z")

</div>

What shikil says is correct, I use

```julia
using ODBC
ltname = "your_dsn"
psuser = "your_user"
pspwd = "your_password"
dsnr = ODBC.Connection(ltname, psuser, pspwd)

```

to create the connection handle `dsnr` which I use for any further ODBC actions.

I am using this to access an MS SQLserver database,

---

<div class="post-metadata">

**Author:** ![indycdrom](https://avatars.discourse-cdn.com/v4/letter/i/eada6e/32.png) [@indycdrom](https://discourse.julialang.org/u/indycdrom)\
**Post date:** [October 15, 2020, 3:52am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/7 "2020-10-15T03:52:20Z")

</div>

Thanks Shikil! your connection string works! Really appreciate the help!

---

<div class="post-metadata">

**Author:** ![indycdrom](https://avatars.discourse-cdn.com/v4/letter/i/eada6e/32.png) [@indycdrom](https://discourse.julialang.org/u/indycdrom)\
**Post date:** [October 15, 2020, 3:54am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/8 "2020-10-15T03:54:19Z")

</div>

thanks js135005. unfortunately, I tried that as well as shown in my example, but did not work. the problem was that instead of plainly telling me that connection string is wrong, ODBC issued a misleading error “invalid username/password” ☹

---

<div class="post-metadata">

**Author:** ![Bryan\_So](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bryan_so/32/16228_2.png) [@Bryan\_So](https://discourse.julialang.org/u/Bryan_So)\
**Post date:** [January 31, 2021, 7:40am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/9 "2021-01-31T07:40:35Z")

</div>

Here is my take on connecting to Oracle DB using Julia ODBC:

> **[GitHub - bryanso/JuliaOracleODBC: Connect to Oracle database using Julia and...](https://github.com/bryanso/JuliaOracleODBC)**
>
> Connect to Oracle database using Julia and its ODBC package - GitHub - bryanso/JuliaOracleODBC: Connect to Oracle database using Julia and its ODBC package

Hope this helps.

Most likely, this will work for you:

`db = ODBC.Connection("DSN=<your DSN name>;Uid=<username>;Pwd=<password>")`

---

<div class="post-metadata">

**Author:** ![Bryan\_So](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bryan_so/32/16228_2.png) [@Bryan\_So](https://discourse.julialang.org/u/Bryan_So)\
**Post date:** [January 31, 2021, 8:04am UTC](https://discourse.julialang.org/t/odbc-dsn-dsn-user-password-error-dsn-not-defined/48087/10 "2021-01-31T08:04:53Z")

</div>

Oh Shikil has already answered…

Ignore my duplicate.