# Error accessing Sqlite

**URL:** <https://www.ruby-forum.com/t/error-accessing-sqlite/142883>\
**Category:** Ruby\
**Created:** [July 12, 2008, 5:24pm UTC](https://www.ruby-forum.com/t/error-accessing-sqlite/142883 "2008-07-12T17:24:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![toospoiled](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@toospoiled](https://www.ruby-forum.com/u/toospoiled)\
**Post date:** [July 12, 2008, 5:24pm UTC](https://www.ruby-forum.com/t/error-accessing-sqlite/142883/1 "2008-07-12T17:24:15Z")

</div>

Hi, I’ve tried to access to a Sqlite database, or to create one, but the  
result is always the same, when I execute this code:

require ‘rubygems’  
require ‘sqlite3’  
dir=‘C:\Documents and Settings\Andrea Marchese\Desktop\prova.db’  
db = SQLite3::Database.open(dir)

db.execute( “select \* from prova” ) do |row|  
p row  
end

db.close

it stops at the 4th line with this error:

c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize’: unknown error  
(RuntimeError)

```
    from c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'

    from c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlload'

    from c:/ruby/lib/ruby/1.8/dl/import.rb:27:in `each'

    from c:/ruby/lib/ruby/1.8/dl/import.rb:27:in `dlload'

    from

```

c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2-mswin32/lib/sqlite3/driver/dl/api.rb:31

```
    from

```

c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem\_original\_require’

```
    from

```

c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`require’

```
    from

```

c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2-mswin32/lib/sqlite3/driver/dl/driver.rb:1

```
     ... 9 levels...

    from

```

c:/ruby/lib/ruby/gems/1.8/gems/ruby-debug-ide-0.1.10/lib/ruby-debug.rb:90:in  
`main’

```
    from

```

c:/ruby/lib/ruby/gems/1.8/gems/ruby-debug-ide-0.1.10/bin/rdebug-ide:74

```
    from C:/ruby/bin/rdebug-ide:16:in `load'

    from C:/ruby/bin/rdebug-ide:16

```

I don’t know what to do.

Thanks for help!

---

<div class="post-metadata">

**Author:** ![toospoiled](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@toospoiled](https://www.ruby-forum.com/u/toospoiled)\
**Post date:** [July 14, 2008, 6:30pm UTC](https://www.ruby-forum.com/t/error-accessing-sqlite/142883/2 "2008-07-14T18:30:11Z")

</div>

On Sat, Jul 12, 2008 at 9:20 AM, Andrea A. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> end  
> from c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlload’  
> c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
> … 9 levels…
> 
> ```
> from C:/ruby/bin/rdebug-ide:16
> 
> ```
> 
> I don’t know what to do.
> 
> ## Thanks for help!
> 
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).

Do you have the sqlite3 dll installed and visible in your path?

–  
“Hey brother Christian with your high and mighty errand, Your actions  
speak  
so loud, I can’t hear a word you’re saying.”

-Greg Graffin (Bad Religion)