Not able to open SQLite3 database using Ruby program

Question

I am working on a simple program where I need to open my Sqlite3 database by writing Ruby code but I am getting the following error on executing it: 'initialize': unable to open database file(Sqlite£:CantOpenException) from first.rb:4:in 'new' from first.rb:4:in ''

The code is here:

require "sqlite3"

# Open a database
db = SQLite3::Database.open "C:\Users\aroraku\Desktop\SQL\adaptive.db"


# Find a few rows
db.execute( "
Select count(uuid) as RegistredPeopleNo, strftime('%Y-%m',created_at) AS Month
from users
group by strftime('%Y-%m',created_at)
order by Month;" ) do |row|
  p row
end

Can someone please help me with this problem. Thanks in advance

Community · Accepted Answer · 2017-05-23 11:52:19Z

1

I'd guess that your problem is that a \ inside a double quoted string is used to begin an escape sequence. For example:

> puts "C:\Users\aroraku\Desktop\SQL\adaptive.db"
C:UsersrorakuDesktopSQLdaptive.db

There were also a couple beeps from my terminal that I can't copy'n'paste that well.

You'll need to double your backslashes:

"C:\\Users\\aroraku\\Desktop\\SQL\\adaptive.db"

or use forward slashes instead:

"C:/Users/aroraku/Desktop/SQL/adaptive.db"

Windows has historically allowed either forward or back slashes in path names, I'm not sure if this is still true so the forward slash version may not work.

Single quotes (as noted by Andrew Marshall) are also an option:

'C:\Users\aroraku\Desktop\SQL\adaptive.db'

but you can still run into issues with certain odd filenames as a backslash still has meaning in some narrow cases (such as '\\' and '\'') inside single-quoted strings.

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Dec 23, 2015 at 2:39

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andrew Marshall Over a year ago

Or use single quotes.

mu is too short Over a year ago

@AndrewMarshall True, but you still have to worry about some incredibly rare cases and Ruby people seem to be allergic to single quotes. I use single quotes unless I specifically need something that only double quotes provide but that seems to be very rare.

Collectives™ on Stack Overflow

Not able to open SQLite3 database using Ruby program

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related