Prev: PureTkGUI v0.9.0 is out
Next: Accessing GUI of CAD through Tcl/Tk
From: Patrick on 10 Dec 2009 23:15
I am looking for an ingres tcl driver / extension. The wiki has the
following:
http://wiki.tcl.tk/20731

Title:
IICMD - TCL extension for INGRES DBMS

The page has a link to download at http://code.google.com/p/iicmd/ but
I get an access is denied error.

Anyone has more info on the status of this project? Any other
options?

Patrick
From: Patrick on 16 Dec 2009 10:12
To answer my own question here in case anyone cares ...

I was able to connect to the ingres database via TDBC::ODBC and tcl
8.6. I have not figured out a DNS-less connection yet, next on the
list.

For this to work you need to install the Ingress client and setup a
DSN to the Ingres database in ODBC. This should work for any other
odbc database type as well.

% package require tdbc::odbc
% tdbc::odbc::connection create db "DSN=QMS;UID=testuser;PWD=testpass"
::db
% set x [::db prepare "Select col1, col2, col3 from db1.my_table WHERE
col4=10 AND col5= 7926"]
::oo::Obj21::Stmt::1
% $x execute
::oo::Obj22::ResultSet::1
% $y allrows
{col1 {Test Data 1} col2 {1234} col3 {2008-03-28 00:00:00}}
% ::db close

From: Patrick on 17 Dec 2009 17:00
I was able to make the dsnless connection using the following conn
string and bypass the vnode server:

tdbc::odbc::connection create db
"driver=Ingres;servertype=ingres;server=(a)the_server_address,wintcp,I2;uid=myuser;pwd=mypass;database
=mydb"

 | 
Pages: 1
Prev: PureTkGUI v0.9.0 is out
Next: Accessing GUI of CAD through Tcl/Tk