Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread

 

By: James Earl
RE: proxyserver.rb usage [ reply ]  
2006-12-08 23:28
It works! I copied a Perl example for the connect args:

dbh = DBI.connect('DBI:Proxy:hostname=192.168.1.2;port=9001;dsn=DBI:ODBC:mydb')

Just for the record, I'm connecting from FreeBSD to a Pervasive.SQL database running on Windows Server 2003 (not because I want to!).

By: James Earl
RE: proxyserver.rb usage [ reply ]  
2006-12-08 23:12
If I comment out:

#if DBI::DBD::API_VERSION.split(".")[0].to_i != DBI::DBD::DBI::ProxyServer::USE
D_DBD_API.split(".")[0].to_i
# raise "Wrong DBD Version"
#end

proxyserver.rb starts. Looks like the problem is with: DBI::DBD::DBI::ProxyServer...

I get the error on FreeBSD as well as Windows.


By: James Earl
proxyserver.rb usage [ reply ]  
2006-12-08 17:01
Hi,

First, I must say that I was extremely happy when I found out about Ruby DBI and DBD::Proxy! Thank you to those who are working on this stuff.

I've got Ruby 1.8.5 installed, as well as Ruby DBI on Windows Server 2003:

entering install phase...
mkdir -p C:/ruby/bin
install sqlsh.rb C:/ruby/bin
mkdir -p C:/ruby/bin
install proxyserver.rb C:/ruby/bin
mkdir -p C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC
install ODBC.rb C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb
mkdir -p C:/ruby/lib/ruby/site_ruby/1.8/DBD/Proxy
install Proxy.rb C:/ruby/lib/ruby/site_ruby/1.8/DBD/Proxy/Proxy.rb
mkdir -p C:/ruby/lib/ruby/site_ruby/1.8/dbi
install columninfo.rb C:/ruby/lib/ruby/site_ruby/1.8/dbi
install row.rb C:/ruby/lib/ruby/site_ruby/1.8/dbi
install sql.rb C:/ruby/lib/ruby/site_ruby/1.8/dbi
install trace.rb C:/ruby/lib/ruby/site_ruby/1.8/dbi
install utils.rb C:/ruby/lib/ruby/site_ruby/1.8/dbi
install version.rb C:/ruby/lib/ruby/site_ruby/1.8/dbi
install dbi.rb C:/ruby/lib/ruby/site_ruby/1.8
setup.rb: skip ext/dbd_sqlite(dbd_sqlite) by user option
setup.rb: skip ext/dbd_sybase(dbd_sybase) by user option
install done.

I'm just a little confused as to the proper way to use proxyserver.rb. Running 'ruby proxyserver.rb' results in:

proxyserver.rb:168: uninitialized constant DBI::DBD::DBI (NameError)

Am I missing something obvious here?

Thanks again
james