Jose A) To connect to a RDBMS from Cach�, check-out, it may help (but I think you will still need to configure the ODBC connection in the SQL Gateway in the Configuration Manager).
http://personal.vsnl.com/sukesh_hooganl/ccos.html#Nbr05 Regards -- Sukesh Hoogan e-Linear Enterprise Solutions Bombay, India http//personal.vsnl.com/sukesh_hoogan (updated : June 12, 2004) Jose A. Horton <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am trying to implement a &sql(...) instruction thru an ODBC connection in > a Cache routine and will like to know if &sql(...) has any parameter or if I > there is any way that I can let &sql(...) know that the database is not in > CACHE, but in my ODBC Connection. > > Just to clarify, I don't want to use and am not using SQL Gateway Connection > in Configuration manager to manually configure my ODBC DNS Connection, I > want to create my connection programatically, so that I pass my ODBC DNS, > UserId & Password at the moment that I am opening the connection and before > using the &sql(...) instruction. > >
