Manuel,
Here is a screen I made for watching things on the Tango server and getting
info about the users browser. I attached it as a file because I did not want
the html codes running in your e-mail.
Take this attached file and create a new page in your tango taf, and then call
it. The commands that give you current odbc info are:
DataSourceStatus: [@datasourcestatus> -- gives you a list of all of the
current data sources that the server has open.
Connections: [@connections> -- gives you a list of the datasources that all of
the users are using.
If your datasource is not listed, you need to go access it and then look at
this screen.
This also has some cool Java scripts in it for looking at the clients window.
It should work for you. I did modify it from the version I have running, so
this version has not been tested.
Troy Sosamon
>===== Original Message From [EMAIL PROTECTED] =====
>I think you guys missed the point. The objective of Scott post is to obtain
>information from an RBase engine through ODBC. If on the Tango editor you
>pick SQL Query [Ctrl]Q and was to enter:
> SHOW VERSION or (CVAL('VERSION')), ODBC returns an error message:
> "This command is currently unsupported (1120)S1000"
>
>HOWEVER, if you type:
> SELECT (CVAL('Version')) FROM anyloggedtable WHERE LIMIT= 1
>
>ODBC returns from RBase:
>
> Oterro 2000 v6.5++ Windows (32-bit), U.S. Version, Build:
>1.842xRT03
>
>This is a great trick to get RBase function *** not a part of ODBC or SQL
>*** from RBase!
>
>I LIKE IT!
>Thanks,
>Manuel
>
>
>
>Bill Downall wrote:
>
>> Jim,
>>
>> Take your anti-anxiety medications, and don't worry. Scott is either
>> making extra work for himself, or being lazy, depending on your point of
>> view.
>>
>> You could also do this:
>>
>> SET V vVersion = (CVAL('VERSION'))
>> SHO V vVersion
>>
>> Scott is using a technique that lets him do it with a single command,
>> by selecting the "expression" -- and no columns -- from a table that he
>> knows you have in your database. By the time he adds the WHERE
>> clause, so that you only see the answer once, it's probably as much
>> work as the two commands above.
>>
>> Many developers create a one row, one column table named Dummy to
>> enable tricks like Scott's.
>>
>> Bill
>>
>> On Fri, 21 Sep 2001 16:28:05 -0400, Jim Limburg wrote:
>>
>> >Where on earth did you learn a command like this...?
>> >Where is it in the docs?
>> >
>> >Someone's holding out on me...
>> >I,I,I just don't know what to think about how
>> >deprived I feel right now...
>> >
>> >OK, OK,,, I'm settled down now...
>> >Whew... I still am interested in learning more
>> >about this...
Troy Sosamon
Denver Co
[EMAIL PROTECTED]
<html>
<head>
<title>Manage Users</title>
<link rel="stylesheet" type="text/css" href="styles_sup2.css"
title="rolloversheet">
<script language="Javascript">
<!--
function describeBrowser()
{
document.write("Browser Properties from script <br>")
document.write(navigator.appCodeName+" ")
document.write(navigator.appName+" ")
document.write(navigator.appVarsion+"<br>")
document.write(navigator.mimeTypes.length+" MIME types are
defined.<br>")
document.write("Links: "+document.links.length+"<br>")
for(l=0;l<document.links.length;++l)
document.write(l+". "+document.links[l].href+"<br>")
document.write("<br>")
document.write("Frames: "+parent.frames.length+"<br>")
for(l=0;l<parent.frames.length;++l)
document.write(l+".
"+parent.frames[l].location+"<br>")
document.write("End of Frames<br><br>")
}
-->
</script>
</head>
<body marginwidth="0" marginheight="0" leftmargin="0" topmargin="0"
background="images/background_image.gif">
<@comment>
<!-- refresh page -->
<meta http-equiv="refresh" content="30;url=">
</@comment>
<table width="780" cellpadding="0" cellspacing="0" bgcolor="white" border="0">
<tr>
<td width="780" valign="bottom" colspan="2"
background="images/gray_background_top.gif"><img src="images/header_logon.gif"
width="776" height="51" alt="Company & Service Information" border="0"></td>
</tr>
<tr>
<td width="580" valign="top">
<!--- nested table for content --->
<table width="580" cellpadding="0" cellspacing="0" bgcolor="white"
border="0">
<tr>
<td width="330" colspan="2" valign="top"><img
src="images/title_welcome.jpg" width="321" height="55" alt="Welcome"
border="0"><br></td>
<td width="250" rowspan="2" valign="top"><img
src="images/photoCollage_company.jpg" width="247" height="282" border="0"></td>
</tr>
<tr>
<td width="45" rowspan="2"><img src="images/1x1trans.gif"
width="45" height="1" border="0"></td>
<!--- youll want to put a section of the content in this cell
and the rest in the cell below to keep the page layout
--->
<td width="285" valign="top"><p><font>
Date: <@currentdate>     Time: <@currenttime><br>
Userid: <@var name=userid>   version: 016 <br>
<br>
IP Address: <@cgiparam client_ip><br>
Security Level is: <@var name=userlevel><br>
<br>
NumUsersShared: <@serverstatus value=NumUsersShared><br>
DataSrcCount: <@serverstatus value=DataSrcCount><br>
ActiveDataSrc: <@serverstatus value=ActiveDataSrc><br>
Datasourcelife: <@var name=DataSourceLife> min.<br>
ProcessSize: <@serverstatus value=ProcessSize><br>
QryTrhCount: <@serverstatus value=QryThrCount><br>
ServerStatus UpTime: <@calc "<@serverstatus value=UpTime> /
60" precision="2"> Hr<br>
</font></p></td>
</tr>
<tr>
<td colspan="2" width="535" valign="top"><p><font><br>
<!--- additional content goes in this cell --->
Server Port:<@cgiparam name=server_port><br>
Server Name:<@cgiparam name=server_name><br>
User Agent: <@cgiparam name=user_agent><br>
Is IE? <@if expr="<@locate str=<@cgiparam name=user_agent>
findstr=MSIE> > 0">
Yes
<@else>
No
</@if>
<br>
Referer: <@cgiparam name=referer><br>
<@userreferenceargument><br>
<br>
Memory Cache: <@var NAME="cache" ><br>
Memory CacheSize: <@var NAME="cacheSize"><br>
Memory maxHeapSize: <@var NAME="maxHeapSize"><br>
</font></p></td>
</tr>
</table><!--- end of content table --->
</td>
<td width="200" valign="top">
<!--- nested table for link line and navigation --->
<table width="200" cellpadding="0" cellspacing="0" bgcolor="white"
border="0">
<tr align="center">
<td width="15" colspan="1" align="center" valign="top">
<!--- this gif keeps the links at the same level as other sub
pages with animations --->
<img src="images/1x1trans.gif" width="1" height="148"
border="0">
</td>
<td width="185" colspan="1" align="left" valigh="center">
<p><font>
<b><@var name=ico> <@var name=cname></b><br>
Logo_File: <b><@var name=logo_file
scope=user></b><br><br>
Hello: <b><@var name=screenname></b>
</td>
</tr>
<tr>
<td width="15" valign="top"><img
src="images/link_line_red.gif" width="8" height="145" border="0">
</td>
<td width="185" valign="top">
<a
href="<@cgi><@appfile>?_function=switch_comp&<@USERREFERENCEARGUMENT>">Switch
Company</a><br>
<br>
<a
href="<@cgi><@appfile>?_function=sup_log&<@USERREFERENCEARGUMENT>">Support Log</a><br>
<br>
<a
href="<@cgi><@appfile>?_function=user_list&<@USERREFERENCEARGUMENT>">List
Users</a><br>
<a
href="<@cgi><@appfile>?_function=logon_log&<@USERREFERENCEARGUMENT>">Logon Log</a><br>
<a
href="<@cgi><@appfile>?_function=logon_activity&<@USERREFERENCEARGUMENT>">Logon
Activity</a><br>
<br>
<a
href="<@cgi><@appfile>?_function=web_log&<@USERREFERENCEARGUMENT>">Web Activity
Log</a><br>
<a
href="<@cgi><@appfile>?_function=web_log&option=user&<@USERREFERENCEARGUMENT>">Web
Activity Log By User</a><br>
<@if expr="<@cgiparam name=server_port>=80">
<a href="http://mail.eapdmz"; target="new">EAP
WebMail</a><br>
<@else>
<a href="http://mail.eapintl.com"; target="new">EAP
WebMail</a><br>
<@endif>
<a
href="<@cgi><@appfilepath>members.taf?_function=employees_main&<@USERREFERENCEARGUMENT>">Back
to Employee Section</a><br>
<a
href="<@cgi><@appfilepath>members.taf?_function=hr_main&<@USERREFERENCEARGUMENT>">Back
to HR Page</a><br>
</td>
</tr>
</table>
<!--- end of table for navigation --->
</td>
</tr>
<tr>
<td colspan=4>
DataSourceStatus: <@datasourcestatus><br><br>
Connections: <@connections><br><br>
<script language="Javascript">
<!--
describeBrowser()
-->
</script>
Describe form javascript is here:<br>
<@comment>
<script language="Javascript">
<!--
//describe form 0
document.write("Form <b>"+
document.forms[0].name +"</b> has "+document.forms[0].elements.length+" elements:
<br>")
for(j=0;j<document.forms[0].elements.length;++j)
{
document.write(j + " " +
document.forms[0].elements[j].name + "<br>")
}
-->
</script>
</@comment>
<br>
<a href="#"
onclick="javascript:parent.frames[1].location='index_bottom.html'">index_bottom</a><br>
<a href="#"
onclick="javascript:parent.frames[1].location='<@cgi><@appfilepath>members.taf?_function=bottom&<@USERREFERENCEARGUMENT>'">Put
me Back</a>
Serverstatus: <@serverstatus>
</td>
</tr>
</table>
</body>
</html>
