RE: [Hardhats-members] SQLI

[Nancy Anthracite]

Looks like this calls for a FOIA request, wouldn't you think?  What is it called and has it been officially "released" yet. I have been told that if things are not ready for final release, a FOIA request will be denied.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Mike Baker
Sent: Thursday, August 19, 2004 7:00 PM
To: [EMAIL PROTECTED]
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 Ocaqa

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 cant find any documentation about how I must configure AIDA to have it talking to Vistas SQLI, Im 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!