# Windows diesel link issue sqlite - only with cargo test

**URL:** <https://discourse.diesel.rs/t/windows-diesel-link-issue-sqlite-only-with-cargo-test/160>\
**Category:** Diesel 2.0\
**Created:** [July 13, 2020, 12:11pm UTC](https://discourse.diesel.rs/t/windows-diesel-link-issue-sqlite-only-with-cargo-test/160 "2020-07-13T12:11:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ta32](https://avatars.discourse-cdn.com/v4/letter/t/a4c791/32.png) [@ta32](https://discourse.diesel.rs/u/ta32)\
**Post date:** [July 13, 2020, 12:11pm UTC](https://discourse.diesel.rs/t/windows-diesel-link-issue-sqlite-only-with-cargo-test/160/1 "2020-07-13T12:11:14Z")

</div>

Hi

I created a sample project [https://github.com/ta32/issues/tree/master/clion\_sqlite\_build](https://github.com/ta32/issues/tree/master/clion_sqlite_build)

I installed cargo install diesel\_cli --no-default-features --features “sqlite-bundled”

The project builds fine with cargo build  
But you get a link error when you do ‘cargo test’

> s\stable-x86\_64-pc-windows-msvc\lib\rustlib\x86\_64-pc-windows-msvc\lib\libcore-b5aae910499df009.rlib" “C:\Users\aluwihat\.rustup\toolchains\stable-x86\_64-pc-windows-msvc\lib\rustlib\x86\_64-pc-windows-msvc\lib\libcompiler\_builtins-9a7454af4f639d0b.rlib” “kernel32.lib” “sqlite3.lib” “advapi32.lib” “ws2\_32.lib” “userenv.lib” “msvcrt.lib”  
> = note: LINK : fatal error LNK1181: cannot open input file ‘sqlite3.lib’
> 
> error: aborting due to previous error
> 
> error: could not compile `clion_sqlite_build`.  
> To learn more, run the command again with --verbose.

i don’t understand why cargo build works and cargo test has a link error aren’t both using the debug build?

this is not a clion bug because i can reproduce with cargo now

---

<div class="post-metadata">

**Author:** ![ta32](https://avatars.discourse-cdn.com/v4/letter/t/a4c791/32.png) [@ta32](https://discourse.diesel.rs/u/ta32)\
**Post date:** [July 22, 2020, 2:21pm UTC](https://discourse.diesel.rs/t/windows-diesel-link-issue-sqlite-only-with-cargo-test/160/2 "2020-07-22T14:21:19Z")

</div>

solved the issue  
I needed an additional dependency  
libsqlite3-sys = { version = “^0”, features = [“bundled”] }

It’s possible somehow cargo was finding the library somewhere on my path. But when you build with cargo test, it needs to rebuild with additional dependencies and it cant use the version linked with when you do cargo build
