How can I connect to MS DataBase

[hyousefGopher]

I'm connected to MS Access database using julia odbc as below:

db=ODBC.DSN("Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=C:/Users/hasan.yousef/Documents/myDB.accdb")

I'm using evcxr_jupyter

How can I do the same using Rust.

[Koka]

Hello, thanks for your question. I've personally never touched jupyter, but your screenshot shows that you're missing some use something; statements. Feel free to refer to examples dir in this repo to see how the connection is done.

[hyousefGopher]

Thanks @Koka
I made some changes, and got the below:

Moreover, What shall I write instead of: TestDataSource, do I need to write the same string I used in Julia, i.e.
let conn = env.connect("Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=C:/Users/hasan.yousef/Documents/ais_sc.accdb", "", "").unwrap();

[Koka]

I guess you could use env.connect_with_connection_string("Your connection string as in julia")

[Koka]

About that type error - try to remove type declaration on env variable

[hyousefGopher]

I got:

And:

[hyousefGopher]

To avoid confusing I moved out of Jupyter and testing in Code:

use odbc::*;

fn main() {
    println!("Hello, world!");
    env_logger::init();
    let mut env = create_environment_v3().map_err(|e| e.unwrap()).unwrap();
    let conn = env.connect_with_connection_string("Driver={Microsoft Access Driver (*.mdb, *.accdb)};
 DBQ=C:/Users/hasan.yousef/Documents/ais_sc.accdb");
}

But got:

    Finished dev [unoptimized + debuginfo] target(s) in 0.86s
     Running `target\debug\db.exe`
Hello, world!
[2020-01-23T16:35:09Z WARN  odbc::result] State: HY000, Native error: 63, Message: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2
224 Thread 0x53e4 DBC 0x51eb00b8                                                              Jet'.
[2020-01-23T16:35:09Z WARN  odbc::result] State: HY000, Native error: 63, Message: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2
224 Thread 0x53e4 DBC 0x51eb00b8    

[Koka]

It's some db specific error from your driver, can't help here

[hyousefGopher]

Thanks, may be this the issue, I'll check it in office next week.