Re: [Hardhats-members] SQLI

[steven mcphelan]

If you developed anything while being employed by the VA and you did the development on VA paid time or possibly using VA furnished equipment, then that development should fall under the same rules as VistA in regards to FOIA.  You cannot charge anyone for a copy of it except for actual costs of making that copy and distributing that copy to the requestor.  If you want to be 100% covered, then you should require anyone outside of the VA to make a FOIA request for the items to the IRM Service at the VAMC facility.  ----- Original Message ----- From: Mike Baker To: [EMAIL PROTECTED] Sent: Thursday, August 19, 2004 6:59 PM Subject: Re: [Hardhats-members] SQLI I have written an application in Delphi that shows the FileMan Files as a tree with the fields as children, any fields that are multiples have children fields also.  The application allows you to select one file and any or all of the fields under it except for the multiples.  The multiples must be selected seperately since they look like seperate tables.  Anyway, an XML file is generated that maps the FileMan file to a Cache object.  I am assuming that since this was developed on VA time that it falls under the same type of license as VistA software but I don't know that for sure.  I will try to attach some documentation that I have for it.  I don't know if that will work or not. steven mcphelan <[EMAIL PROTECTED]> wrote: If you are running Vista on Cache, you have a SQL manager built into Cache.  As stated though, you need to mapped the VistA FM file structure.  By the end of this year, the VA will have converted all their sites from running various M implementations to all running Cache on VMS.     ----- Original Message ----- From: Christian Alexis Diez Ocaña To: [EMAIL PROTECTED] Sent: Thursday, August 19, 2004 1:29 PM Subject: [Hardhats-members] SQLI Hello I need to access the OpenVista database with SQL/JDBC, and according to the documentation available at: http://www.va.gov/vdl/VistA_Lib/Infrastructure/SQL_Interface_(SQLI)/sqli_sm.pdf It is possible using an M-to-SQL application.   The FAQ at http://www.sanchez-gtm.com/product/gtm_faq.htm names two of these applications: KB_SQL and AIDA. So, I installed AIDA, but now I can’t find any documentation about how I must configure AIDA to have it talking to Vista’s SQLI, I’m not even sure that AIDA can talk to SQLI.   Could you please point me in the right direction? Do you know if AIDA can talk to SQLI? Or do you know where can I find documentation about the AIDA setup? Is there another M-to-SQL application I can use besides KB_SQL and AIDA? I cannot use KB_SQL because of its license cost.     Best wishes, Alexis   Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage!