[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

database access problem through cgi script

Raju Alluri

12/28/2008 1:40:00 AM

Hi,
I am trying to print a set of data from database with a CGI script. This
script works fine a simple ruby script. But doesnt work in cgi script.
Any help is appreciated.


connection = WIN32OLE.new('ADODB.Connection')
connection.Open('Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\INFOPROJECT\db1.mdb')
recordset = WIN32OLE.new('ADODB.Recordset')
sql = "select * from GuestBook"
recordset.Open(sql, connection)
data = recordset.GetRows #.transpose
puts data
recordset.Close
connection.close

How can i call the above statements in below cgi script to make it work.

#!/usr/bin/ruby
require 'win32ole'
require 'cgi'

cgi = CGI.new("html3")
cgi.out() do
cgi.html() do
cgi.head{ cgi.title{"DATABASE"} } +
cgi.body() do
cgi.form() do
cgi.textarea("get_text") +
cgi.br +

end
end
end
--
Posted via http://www.ruby-....
1 Answer

Tony L.

12/28/2008 7:11:00 PM

0

Raju Alluri wrote:
> Hi,
> I am trying to print a set of data from database with a CGI script. This
> script works fine a simple ruby script. But doesnt work in cgi script.
> Any help is appreciated.

When calling it on the console it is you (i.e. the user ID you are
logged in with).
When calling the CGI it is the webserver (i.e. the user ID under which
it is running) that is executing your code.

Are you sure that the webserver has the permission to connect to the DB?

T.