Using sql compact from ruby

Does anyone have any experience using Sql Compact with Ruby. I tried
the following code
require ‘dbi’

@server_name=‘C:/Temp/F1Backup.sdf’
@dbh=DBI.connect(“DBI:ADO:Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data
Source=#{@server_name}”)

if @dbh
puts “connected”
else
puts “not connected”
end

and received the following error message
c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in connect': Open (DBI::DatabaseError) OLE error code:80004005 in Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified HRESULT error code:0x80020009 Exception occurred. from c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb: 424:inconnect’
from c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:215:in `connect’
from sqlCompact.rb:4

Thanks,
Luis

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs