How to configure Data Sources and Drivers for SQLite?

Answered

I'm trying to configure Datagrip to run SQLite scripts. In "Data Sources and Drivers", when I press "Test Connection", it said "No driver files provided".

Then I have the dialoged

and

and 

but I dont know how to configure it?

I downloaded SQLite into the folder "C:\sqlite"

 

Could you please elaborate on this issue?

2 comments
Comment actions Permalink

You tried to add the sqlite jdbc driver as a custom jar pointing to where you have downloaded sqlite.  That install does not come with jdbc drivers instead you would need to download it from somewhere else and store it there.

Datagrip makes it easy for you to get the driver.  When you add the SQLite jdbc driver you can select provided drivers then select "Xerial SQLite JDBC".  Finally chose the driver version number you would like to use.

Before:

After:

 

1
Comment actions Permalink

Thank you so much! It works perfectly fine for me :)))

0

Please sign in to leave a comment.