Re: [Hardhats-members] SQLI

[steven mcphelan]

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