[Hardhats-members] RE: SQLI

[Christian Alexis Diez Oca�a]

Hi,   I’m running SemiViva 0.4 on GT.M. Do yo know if there’s any other software/utility I can use to access the Vista database with SQL/JDBC?   Thanks,   Ing. Alexis Diez Oca�a ___________________________________ Instituto Mexicano del� Seguro� Social Divisi�n de Expediente Cl�nico Electr�nico Tel. 5238-2700 x. 12826     --__--__--   Message: 3 Date: Thu, 19 Aug 2004 15:59:55 -0700 (PDT) From: Mike Baker <[EMAIL PROTECTED]> Subject: Re: [Hardhats-members] SQLI To: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]   --0-440171479-1092956395=:80700 Content-Type: multipart/alternative;   boundary="0-2085073596-1092956395=:80700"   --0-2085073596-1092956395=:80700 Content-Type: text/plain; charset=us-ascii   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: st1\:* { BEHAVIOR:   url(#default#ieooui)}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   �